Re: [PHP-DB] SELECT LIKE with % and without %
Eleonora De Marinis eleonora.demari...@garr.it, haber iletisinde sunlari yazdi:49fe92d0.2060...@garr.it... $sql = SELECT * FROM table WHERE ID ='$_GET[id]' AND title LIKE '%$_GET[word]%'; Original Message Subject: [PHP-DB] SELECT LIKE with %' and without %' From: Emiliano Boragina emiliano.borag...@gmail.com To: php-db@lists.php.net Date: 05/03/2009 01:43 AM Hello. I am using this: $sql = SELECT * FROM table WHERE ID LIKE '%$_GET[id]%' AND title LIKE '%$_GET[word]%'; But I want exactlu ID, not one part of many possibles Ids in the DB. How can I do that? Thanks + _ // Emiliano Boragina _ // Diseño Comunicación // + _ // emiliano.borag...@gmail.com / // 15 40 58 60 02 /// + _ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PHP- Mysql problem
Mysql Username or password error.please testing connect setting -- NADARAJAH SIVASUTHAN NADARAJAH nsivasut...@live.com, haber iletisinde sunlari yazdi:col106-w49cf8a0029c9582f1c0161d5...@phx.gbl... Dear all, When I try to retrive data from two tables using JOIN OR INNER JOIN it display error message given below; Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\ap_v5\inc\profile.inc.php on line 285 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\wamp\www\ap_v5\inc\profile.inc.php on line 285 Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\wamp\www\ap_v5\inc\profile.inc.php on line 288 what may be the reason? Normally PHP-mysql works fine. Can you figure it out and give me the possible solution? Thank you. suthan _ Windows Live: Keep your life in sync. Check it out! http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_allup_explore_012009 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php