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