Re: retrieve single field from database without while loop

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@aztechost.com 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