Justtechjobs.com Find a programming school near you






Online Campus Both


php-windows | 2003032

Re: [PHP-WIN] What does"Query was empty" mean? From: quickshow (quickshow <email protected>)
Date: 03/28/03

oh,what a stupid mistake i just made.
thx
<cpdm <email protected>> ??????:1048823195.3e83c59b915d4 <email protected>
> 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 <email protected>>:
>
> > 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 

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php