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