RE: [PHP-DB] localhost versus remote
| From: | John W. Holmes | Date: | Sun, 27 Oct 2002 22:30:03 +0000 |
| Subject: | RE: [PHP-DB] localhost versus remote | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22735@lists.php.net to get a copy of this message | ||
> MySQL Error: You have an error in your SQL syntax near 'Field2 LIKE
'%%'
> Field3 LIKE '%%' ORDER BY ' at line 2
> SQL: SELECT * FROM airline_a WHERE Field1 LIKE '%%' Field2 LIKE '%%'
> Field3
> LIKE '%%' ORDER BY
You need some ANDs between each of your field LIKE '%%' clauses.
WHERE field1 LIKE '%%' and field2 LIKE '%%' ...
---John Holmes...