catch a sql result and place as a variable, problems.
| From: | Louie Miranda | Date: | Mon, 19 Jul 2004 00:24:28 +0000 |
| Subject: | catch a sql result and place as a variable, problems. | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-13736@lists.php.net to get a copy of this message | ||
How can i catch a result on a mysql query and make it as a variable?
## code, im doing.. ##
$last_date = "select max(dateposted) from datafiles where office = '"
.$_SESSION['username']. "'";
$q2 = $db_view->query($last_date);
if (DB::iserror($q2)) {
die($q2->getMessage());
}
## end of code ##
How can i get the max(dateposted) result as a variable or global? if
im going to issue it as a query on PEAR?
Will this work? if i use this?
DB_Common::getCol() -- Fetch a single column
pls help, thanks!
--
Louie Miranda
http://www.axishift.com