Re: [PHP-DB] PHP and Mysql help

2005-04-24 Thread Amos Glenn
ReClMaples wrote: $zipcode = mysql_query( "SELECT * FROM zip_code where ZG_LATITUDE >= $Lat1 and ZG_LATITUDE <= $Lat2 and ZG_LONGITUDE >= $Lon1 and ZG_LONGITUDE <= $Lon2"); Try putting single quotes around the variables in your query string; mysql sees them as strings, not variables: ... ZG_LATIT

Re: [PHP-DB] inserting due date into database

2006-01-04 Thread Amos Glenn
with mktimes, but I only get the timestamp of the due date. I have troubles to write that into a dabasefield that was set to datetype. Regards, Ruprecht -- Amos Glenn amos+amosglenn.com www.amosglenn.com 299 Le Roi Road Pittsburgh, PA 15208 There are 10 kinds of people in the world: thos