Justtechjobs.com Find a programming school near you






Online Campus Both


php-windows | 2003032

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

nah, just a common one.
;)
--Christopher

Quoting quickshow <quickshow <email protected>>:

> 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
>

------------------------------------------------------------
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