Hello guys, I have a table contains 413,000 places name (Pris, London,...) is there a way (query) to select locations from specified text. for example: " Transport for London (TfL) is in talks with its American, Australian and European partners about issuing a single contactless card for Paris, New York". I want a query to get: * Lo...
Hi all, I have following code: SELECT q21, q21coding AS Description FROM `tresults_acme` WHERE q21 IS NOT NULL AND q21 <> '' ORDER BY q21coding It brings back the following (excerpt): Text Description Lack of up to date equal pay cases&legislation - t... Content needs updating The...
Hello, The table below prints of the results of a query called $sqlStr3. It works fine. The query is set to return the top 25 results. I would like to apply a unique CSS class (called "class1" for purposes of this question) to the top ten results in the query. How can I do this? Thanks in advance, John $result = mysql_query($sql...
Is there way to insert null into mysql from an empty text field in vb.net thanks.. ...
I would like to know if it's possible in innodb in mysql to have a table with foreign key that references another table in a different database ? And if so, how this can be done ? ...
Hi, Im not sure how to correct these errors, can someone help me. search.php Notice: Undefined index: submit in C:\wamp\www\i-document\search.php on line 12 Notice: Undefined index: search in C:\wamp\www\i-document\search.php on line 13 After clicking 'search' : Notice: Undefined variable: x in C:\wamp\www\i-document\search.php on l...
Hello Having rebuilt my Windows 7 PC, I am trying to get Tomcat running under NetBeans to connect to MySQL. I believe MySQL is alright because the various tools retrieve data correctly. But when my Java web app is run from NetBeans, Tomcat shows the homepage but then gives a Java null pointer error. The logs tell me this is to do with ...
Hi all, Further to a recently answered question, I have the following code: SELECT q21coding, COUNT(q21coding) AS Count FROM tresults_acme WHERE q21 IS NOT NULL AND q21 <> '' GROUP BY q21coding ORDER BY IF(q21coding = 'Other', 1, 0) ASC, Count DESC It brings back the following: q21coding ...
How should we treat the data if they have no values in it. I mean, at some places, they have no value. Should we populate it as it or should we write something at that place? ...
I am new to django I would like to start a project but when i run it i get this error Error loading MySQLdb module How do i add the MYSQL module or any other module for that matter ...
Is it possible to use subquery and at the same time use data in values when Inserting in mysqli? insert into articles(description) values('Information'); insert into blogs(blog, article_id) values('example.com/', SELECT LAST_INSERT_ID()); ...
Hi again, Ok, have the following code: SELECT q21 as Comment, q21coding AS Description FROM `tresults_acme` WHERE q21 IS NOT NULL AND q21 <> '' ORDER BY q21coding = 'Other', q21coding = 'Positive comments', Count ASC This brings back the following (excerpt): Text Description La...
ERROR 1044 (42000) at line 17: Access denied for user 'user'@'117.120.4.172' to database 'bios' Hi, I encounter the following error when I to access my database. What should I do to resolve this issue? ...
Hi all and thank you for reading... Ive been trying to find a fix to a SQL and PHP problem I have. below is a snippet of the table I am trying to work with. The table is called web_navbar_links the field is called slug +------------------+-------+ | slug | child | +------------------+-------+ |business-multiseat| 1 | +...
I've the code shown below but nothing happens after execution system('mysqldump -u USER -pPASS DB > /tmp/bckp.sql'); What is wrong with this code? Sultan ...
Hello I've performed mysqldump -uroot --add-drop-table --default-character-set=latin1 dbname >/backup/new.sql DB 7GB issue it take tooo much and the output is still 0 size , and mysqladmin processlist show | 8219 | root | localhost | dbname | Query | 1413 | | LOCK TABLES `wp_10000_comments` READ /*!32311 LOCAL */,`wp_10000_...
i have function file called models.php, which stores all my database functions, for example // get the updates for the $user_id profile function getProfileUpdates($user_id) { $query="SELECT m . * , u.picture, u.username FROM notes m, user u WHERE m.user_id = u.user_id AND u.user_id ='$user_id' ...
Hi guys, I want to query a database for records where the date is equal to, or greater than 90 days. This is what I have so far: $format = 'Y-m-j G:i:s'; $date = date ( $format ); // -90 days from today date ( $format, strtotime ( '-90 day' . $date ) ); I'm just a bit unsure now how to structure the MYSQL query. Would it be s...
I'm looking for the built-in MySQL information function that returns the number of rows just selected, like ROW_COUNT() does for INSERT, UPDATE, etc. In a stored procedure I wish to do this: ... select episode_name from bestLOSTepisodes set _episodes_found = SELECTED_ROWS(); ... I've done a fair amount of digging and have been unable...
I've recently came across a problem for which I can only think of muddy solutions. Imagine a table has several objects (lets say photos to make it easier). Every single photo/object must have it's own set of permissions. 1 - photo must always be seen by uploader 2 - photo belongs to a group of photos and all users that have access to t...