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