Re: What does"Query was empty" mean?
| From: | cpdm at efn dot org | Date: | Fri, 28 Mar 2003 03:46:35 +0000 |
| Subject: | Re: What does"Query was empty" mean? | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-19173@lists.php.net to get a copy of this message | ||
your query variable is mis-named in the assignment statement:
$addtmt = "Insert into....
$addstmt is the variable you are passing to mysql_query()
the $addstmt variable is empty, hence the error.
--Christopher
Quoting quickshow <quickshow@msn.com>:
> i am php&mysql newbie.
> i have created a table like:
> =======================================================
> CREATE TABLE $data_dep(
> ID int(3) DEFAULT '0' NOT NULL auto_increment,
> department_name VARCHAR(10),
> department_desc TEXT,
> publishtime DATE,
> updatedby VARCHAR(8),
> updated TIMESTAMP,
> PRIMARY KEY (ID)
> )
> =======================================================
> when i use :
> $addtmt = "Insert into
> $data_dep(department_name,department_desc,editedby,publishtime)
> values(%s,%s,%S,%s)";
> mysql_query(sprintf($addstmt,$department_name,$department_desc,$editedby,$pu
> blishtime),$link);
>
> an error occured:
> Query was empty .
> ========================================================
> Must i insert
> ID int(3)
> department_name
> department_desc
> publishtime
> updatedby
> updated
> COMPLETELY?
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
------------------------------------------------------------
Visit http://www.efn.org for all your community networking needs