get one record at a time from select query

[fimbria]

hi,

im trying to do a select query that returns, one record at a time... Basically i want it to return a code each time and then to a query on it...for example:-

SELECT code from database;

i.e. query returns.....

1231
1237
1234
1239

So first all i want to return is the first value, then once i have done work on the first value, i then want to work on the next value ("1237").

So each time i only want to return one value so i work on that certain "code", then move onto the next one....and so on...

Thanks

[leatherback]

$query = "SELECT code from database";

$Results = mysql_query($query)
    or die ("<b>Couldn't execute query</b>");

while ($row =@ mysql_fetch_array($Results)) 
 	{
                 Do Your stuff here. Use the results as $row[code]
                 }

[fimbria]

thanks, leatherback....

that worked great....didn't think of doing the problem from that angle...

laters
fimbria