[RESOLVED] How to simulate a While - Else?

[djwinder]

Hi all

I have a bit of code that runs the standard WHILE there is a record in the record set print info for that record. My questions is, does anyone know of a way to run some code if no records are returned?

To me it would seem like a while - else would work perfectly but this doesnt seem to work/exist. I can't be the only person who has come across this so could someone give their ideas or a solution?

Cheers

Dan

[leatherback]

if($result && mysql_num_rows($result) > 0)
{
while(...)
{
}
}
else
{
echo 'No matching records found';
}

[djwinder]

your a star! thanks