Justtechjobs.com Find a programming school near you






Online Campus Both


php-windows | 2003032

Re: [PHP-WIN] What does"Query was empty" mean? From: cpdm <email protected>
Date: 03/27/03

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 <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