while...if statements???
| From: | Jay Fitzgerald | Date: | Tue, 18 Dec 2001 20:08:43 +0000 |
| Subject: | while...if statements??? | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-15090@lists.php.net to get a copy of this message | ||
Does anyone know why this isn't working?? What I am trying to do is display photos from a database based on each month. This part works fine when I set it to the current month of December (today) as that is when I uploaded the photos.
However, when I manually set the date to a month that has no photos in it, I want it to echo the No Animals string below....This is only working half-way...meaning that it will display a blank page with nothing on it instead of actually echoing the No Animals string....
Can anyone please help?? Is there really a way to have a "while...if" statement????
========<CODE>=========
<?
$connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!");
$query = "SELECT petname, petDesc, petpicture FROM petinfo WHERE petmonth = 'Apr'";
$result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());
while (list($pet_name, $pet_Desc, $pet_picture) = mysql_fetch_row($result))
{
if ($pet_picture == "")
{
echo "No Animals have been posted for $date at this moment. Please check back soon.";
exit;
}
else
{
echo "
<FONT FACE=\"Arial, Helvetica\"><B>Pet of the month</B></FONT><BR>
<BR>
<IMG SRC=\"http://moss.bayou.com:8888/oppj/admin/animalcontrol/photos/$pet_picture\" HEIGHT=150><BR>
<BR>
<FONT FACE=\"Arial, Helvetica\" SIZE=\"-1\">$pet_Desc<BR>
<BR>
To adopt $pet_name please visit the Ouachita Parish Animal Shelter.<BR>
The adoption fee is \$50.00 which includes Spade, Neutering and 7-N-1 Shot.<BR>
<BR>
Sorry, we can not hold $pet_name for you (First come first serve basis).</FONT>
<BR><BR>";
}
}
?>
========</CODE>=========
Thanks,
Confus3d