i've managed to code so that the records in my "proj" table are diplayed the way i want, but i would like the page to display something simple like "End of Files" when all are printed. i'm assuming a "while - else" loop would be applicable here, but none of my attempts work.

Here is the code as i have it presently:
<?php

$result = mysql_query("SELECT * FROM proj",$dbcnx);

printf("<font size='-1' face='Arial, Helvetica, sans-serif'><P><b>Project: %s<br></b></font>\n", mysql_result($result,0,"name"));
printf("<font size='-1' face='Arial, Helvetica, sans-serif'>Project Complete: %s<br></font>\n", mysql_result($result,0,"projcomplete"));
printf("<font size='-1' face='Arial, Helvetica, sans-serif'>Pages Complete: %s<br></font>\n", mysql_result($result,0,"pagecomplete"));
printf("<font size='-1' face='Arial, Helvetica, sans-serif'>Database: %s<br></font>\n", mysql_result($result,0,"db"));
printf("<font size='-1' face='Arial, Helvetica, sans-serif'>Updated: %s<br></font></p>\n", mysql_result($result,0,"updated"));

?>

anyone have the input to tweat it to do what i want?
thanks all.