no result from database, then show message

eagle00789 · **no result from database, then show message -** 01-04-2005, 08:33 PM

When the code below is executed, it can happen that there was no result. When this happens i want to show the user a message that there were no items in the database to show for the upcomming period. How can i do that

Code:

   Opentable();
   $resultpersons = sql_query("SELECT * FROM ".$prefix."_probs_agenda WHERE Datum >= ".date("y-m-d")." ORDER BY Datum", 

$dbi);
   echo "<table border=1>";
   for ($m=0; $m < sql_num_rows($resultpersons, $dbi); $m++) {

Also, The date returned by mysql is in the format Year, Month, Day. I want this to be Day, Month Year. What do i have to do for that

eagle00789 · 01-05-2005, 04:28 AM

This is the solution. if it seems to be incorrect, please say so

Code:

   if (1 > sql_num_rows($resultpersons, $dbi)) {
      echo "Geen items gevonden";
   } else {
      for ($m=0; $m < sql_num_rows($resultpersons, $dbi); $m++) { 
         list($id, $datum, $tijd, $klantid, $description, $addby) = sql_fetch_row($resultpersons, $dbi);
         $resultname = sql_query("SELECT Naam, Voornaam FROM ".$prefix."_probs_klant WHERE id='$klantid'", $dbi);
         list($lastname, $firstname) = sql_fetch_row($resultname, $dbi);
      }
   }