Re: php'ed mysql query

Have you tried adding or die(mysql_error()) to try and let mysql tell you what's wrong? That and the previously-suggested echo-ing the SQL statement solve most of my problems. --Toby ----- Original Message ----- From: "Christopher Allen" <callen@driver8.org> To: "Sam Masiello" <smasiello@chekinc.com>; "php" <php-general@lists.php.net> Sent: Tuesday, January 16, 2001 3:00 PM Subject: Re: [PHP] php'ed mysql query > > If you are going to do a comparison from one of the fields in your table, > > doesn't the field name need to be on the left hand side of the comparison? > > So instead of "where '$zip1' >= zip", shouldn't it be > > "zip < '$zip1'" (et > al > > for the other comparisons in your query) . > > > Didn't matter. Is there a trick for using concat or substring or any string > functions in a mysql query that is sent by php?? > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >