PHP version - Do while not EOF (ASP)

[fRostiE]

i'm having afew problems converting this into PHP:

--- ASP Version ---
If (Not rsClean.EOF) Then
	Do While Not rsClean.EOF
		////////// Do Stuff
	Loop
End If

rsClean.EOF is a recordset from a stored proceedure pulling *currently* 154 records from a database... the /////// Do Stuff section makes a date comparison and if a file exists that is over 3 days old with a reference number from rsClean it is deleted...

all of this is fine, other than the flipping loop, whats the PHP equivilant of:

DO While Not .EOF?

 

[fRostiE]

using a function i now know exactly how many rows are being returned by the stored proceedure each time the page is run,

is there any way of returning a specific row? like the 72nd row which met the criteria of:

Select * from TableName where (Z = Z) AND (V = V)

?

 

[fRostiE]

hi, im using ODBC

i'll take another look at your links when im back in at work infront of the code on monday

thanks for the reply

 

[fRostiE]

ended up with this and it seems to work

$rsClean = odbc_exec(connection,"exec stored procedure @f_ref_link='%'");
while (odbc_fetch_row($rsClean)) {

}

Cheers