Something like:

if ($array_result = mysql_fetch_array($result)) {
        do {
                // do your thing here
        } while ($array_result = mysql_fetch_array($result));
}

HTH
Jon


-----Original Message-----
From: Jamie Thompson [mailto:[EMAIL PROTECTED]]
Sent: 23 May 2001 14:33
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL Select


ok...sorry to ask a stupid question but....

$result = mysql_query("SELECT jazz FROM funk WHERE foo='bar'")

but where do you go from there. How would you iterate through the array a
row at a time, doing your thing as you go along?

thanks,

jamie


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



**********************************************************************
'The information included in this Email is of a confidential nature and is 
intended only for the addressee. If you are not the intended addressee, 
any disclosure, copying or distribution by you is prohibited and may be 
unlawful. Disclosure to any party other than the addressee, whether 
inadvertent or otherwise is not intended to waive privilege or
confidentiality'

**********************************************************************

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to