Query Help...
| From: | SBCSI) | Date: | Mon, 10 Mar 2003 17:23:57 +0000 |
| Subject: | Query Help... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26235@lists.php.net to get a copy of this message | ||
I am having a lot of trouble with a query that works fine from a
basic SQL command line, but fails in my web script. Here is the portion of
code including the query:
mysql_select_db($database, $Prod);
$query_groups = "SELECT name FROM group";
$groups = mysql_query($query_groups, $Prod) or die(mysql_error());
Here is the error I am receiving:
You have an error in your SQL syntax near '"group"' at line 1
I am wondering if for some reason group is trying to be
interperetted as the "GROUP BY" MySQL function? I am running PHP 4.2.3
against a MySQL DB on an Apache 1.3.27 server. Thanks in advance for the
help.
Scott Nipp
Phone: (214) 858-1289
E-mail: sn4265@sbc.com
Web: http:\\ldsa.sbcld.sbc.com