quick while question

[jesushax]

the while function loops through records yes?

so if there is nothing to loop through what can i put, it doesnt like else this is what i mean

 

this doesnt work...?

while ($row = mysql_fetch_array($SQL)) {

im loopign records here
}
else {
echo "There are no current records.";
}

[Barand]

Method A (most common)

<?php
if (mysql_num_rows($SQL) > 0) {
    while ($row = mysql_fetch_array($SQL)) {

        // im looping records here
    }
} else {
    echo "There are no current records.";
}
?>

 

Method B

<?php
if ($row = mysql_fetch_array($SQL)) {             // returns false if no record
    do {
        // im looping records here
    } while ($row = mysql_fetch_array($SQL));     // use do..while so first row gets processed in the loop
    
} else {
    echo "There are no current records.";
}
?>

[jesushax]

thanks!