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