View Single Post
  #1 (permalink)  
Old 01-04-2005, 09:33 PM
eagle00789 eagle00789 is offline
Junior Member
 
Join Date: Dec 2004
Posts: 20
no result from database, then show message
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
Reply With Quote