Re: php-mySQL insert problem
| From: | Jack Scott | Date: | Mon, 01 Aug 2005 23:44:51 +0000 |
| Subject: | Re: php-mySQL insert problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-219802@lists.php.net to get a copy of this message | ||
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);