[PHP] php'ed mysql query

Hello, Can anyone tell me why this query errors out? It works from the mysql client command line just fine $query1 = "select * from zip_base where '$zip1' = zip '$zip1' = CONCAT (SUBSTRING(zip , '1' , LENGTH (zip) - LENGTH (range) ), range)"; Christopher C. M. Allen -- PHP

RE: [PHP] php'ed mysql query

Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Christopher Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 2:25 PM To: php Subject: [PHP] php'ed mysql query Hello, Can anyone tell me why this query error