Re: [PHP-DB] Another newbie question

[Pete Holsberg]

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