oh,what a stupid mistake i just made.
thx
<[EMAIL PROTECTED]> ??????:[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 <[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

Reply via email to