Are you trying to create a table named "How Are You"? If so, can't do it.
It MUST be a one-word name.
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().
----- Original Message -----
From: eat pasta type fasta <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 16, 2002 4:13 PM
Subject: [PHP-DB] Inserting a String Variable into mysql_query() returns
"Query was empty" error
I am creating a string out of bunch of variables and an array and I need
it to become a query which will make me a table.
It looks like this when I echo it:
CREATE TABLE How Are You (Reply1 VARCHAR(255), Reply2 VARCHAR(255),
Reply3 VARCHAR(255), Reply4 VARCHAR(255), Reply5 VARCHAR(255), date
DATE)
and it appears in the code under the name $all_sections, however when I
put into the mysql_query function like so:
$sql = mysql_query($all_sections);
it returns "Query was empty" error, any ideas?
Thanks in Advance.
R>
________________________--__-______-______________
eat pasta
type fasta
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
