Re: Inserting a String Variable into mysql_query() returns "Query was empty" error
| From: | Jason Wong | Date: | Wed, 17 Apr 2002 06:06:05 +0000 |
| Subject: | Re: Inserting a String Variable into mysql_query() returns "Query was empty" error | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18581@lists.php.net to get a copy of this message | ||
On Wednesday 17 April 2002 05:35, Richard Emery wrote:
> Are you trying to create a table named "How Are You"? If so, can't do it.
> It MUST be a one-word name.
Not strictly true. You can surround the table name with backticks:
CREATE TABLE
How Are You ...
However this is /not/ recommended, better to use underscores -- How_Are_You.
> You would have discovered this yourself had you typed your CREATE statement
> into the mysql command line.
>
> Second ALWAYS include an "or die("Error: ".mysql_error())" part after your
> mysql_query().
I second this!
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Q: Know what the difference between your latest project
and putting wings on an elephant is?
A: Who knows? The elephant *might* fly, heh, heh...
*/