Re: php-mySQL insert problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Try this:
$insertQuery = "Insert into TABLE 
		(
			col_one,
			col_two
		)values (
			'" . $this -> firstName . "',
			'" . $this-> lastName . "'
		)";
$db =& new DB;
$res = $db->query($insertQuery);
if(DB::isError($res)){
    exit("Insert query failed: ".__FUNCTION__."() <br>in file
".__FILE__."<br>on line ".__LINE__."<br>".$res->getDebugInfo());
}else{
    return;
}

you need to have quotes arround your varchar items and you should also
specify which column you want the values to go into.
It is also good practice to check if there is an error and try to get
the most information available.

On Tue, 2005-08-02 at 00:44 +0200, Adi Zebic wrote:
> $insertQuery = "Insert into TABLE values (".$this ->
> firstName.",".$this 
> -> lastName)");
> $db = new DB;
> $db -> query($insertQuery);

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux