Porblem With Simple SQL statements
| From: | Pradeep Dsouza | Date: | Sat, 22 Jun 2002 07:35:50 +0000 |
| Subject: | Porblem With Simple SQL statements | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-1742@lists.php.net to get a copy of this message | ||
Hi List
I have been using PEAR for sometime now and it seems that i have run into
a bit of Problem
I have a SQL statement -
$sql = "STATEMENT ";
$res = $db->query($sql);
/// Get the result
-------------Works Fine ----------------------
In the same page i run the Second query
$sql = "STATEMENT ";
$res = $db->query($sql);
/// Get the result
-------------Works Fine ----------------------
( I am using $sql and $res again in the second )
// now again
In the same page i run the third query
$sql = "STATEMENT ";
$res = $db->query($sql);
/// Get the result
----------- THIS FAILS ------------------------------------------
The third query show s the error Unkown error
Is it because of res->free () written / Not written
Or is it because of using the same variables $sql , $res
?????
Please Help
Pradeep Dsouza
pradeep@aspbytecreations.com