Does anyone see anything wrong with the following code/query syntax? I'm
using the PEAR DB class for PHP. When this runs, it correctly inserts
the row to the table, but is failing to retrieve the last_insert_id().
function StartOrder()
{
global $dbhandle;
global $OrderID;
global $CustomerID;
if (!($OrderID)) {
$query = "INSERT INTO Orders (CustomerID) VALUES(";
if ($CustomerID) {
$query .= "\"" . $CustomerID . "\"";
} else {
$query .= "\"" . "\"";
}
$query .= ")";
$dbhandle->query("LOCK TABLES Orders WRITE");
$dbhandle->query($query);
$res = $dbhandle->query("select last_insert_id()");
$dbhandle->query("UNLOCK TABLES");
$result = $res->fetchRow();
return $OrderID = $result[0];
} else {
return $OrderID;
}
} // end func
--
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
---
--
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.286 / Virus Database: 152 - Release Date: 10/9/2001
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
