Re: What does"Query was empty" mean?
| From: | quickshow | Date: | Fri, 28 Mar 2003 06:14:51 +0000 |
| Subject: | Re: What does"Query was empty" mean? | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-19175@lists.php.net to get a copy of this message | ||
oh,what a stupid mistake i just made.
thx
<cpdm@efn.org> ??????:1048823195.3e83c59b915d4@secure.efn.org...
> 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