On Mon, 6 Sep 2004 [EMAIL PROTECTED] wrote:
> you should copy/paste that into a command-line msyql
> session and see if that works.
Advertising
I cut the query back to
SELECT * FROM Directory WHERE `LastName` LIKE Joe ORDER BY Street, HouseNum, LastName
and ran it manually. I got
---
SQL-query :
SELECT *
FROM Directory
WHERE LastName
LIKE Joe
ORDER BY Street, HouseNum, LastName
LIMIT 0 , 30
MySQL said:
Unknown column 'Joe' in 'where clause'
--------
Perhaps I don't understand LIKE. LastName is a column; Joe
is a value. ???
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php