Re: What does"Query was empty" mean?

nah, just a common one. ;) --Christopher Quoting quickshow <quickshow@msn.com>: > 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 > > > > -- > 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