On Mon, 6 Sep 2004 php-list-replies@xxxxxxxxxxxxxxxxxxxxx wrote: > you should copy/paste that into a command-line msyql > session and see if that works. 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
