Check out abstraction layers
I use adodb http://adodb.sourceforge.net/
makes coding much much easier ;-))
eg - mysql example
$sql = "insert into table (col, col2)values('$this','$that')";
$db->execute $sql;// get last id
$new_id = $db->getOne('select last_insert_id()');have fun Pete
ross@xxxxxxxxxxxxx wrote:
Is there a way to retrieve and display a single value (customer number) from a database and display it without using
while ($row = mysql_fetch_array) ($result)){
I have a value I know the query will only ever return a single value. I want to get it from the database and convert it to a variable so I can use it on my php page.
Thanks in advance,
Ross
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
