because the while() statement works like this
- do something while x is true. if x is not true dont do anything.
- do something while conent is in the db. if there is no conent in the db
dont do anything.
your if() statement is never run if there is no content.
$return = mysql_fetch_row($result);
if ( isset($return['pet_name']) )
echo $return['pet_name'] ."<br>";
} while( $return = mysql_fetch_row($result) );
echo " No Pets <br>";
its ugly but it works. I dont like ugly, so I wrote my own db wrappers.
foreach( $db->select_array('', 'petinfo', '') as $pos => $val )
echo $val['pet_name'] ."<br>";
if ( !isset($val['pet_name']) )
echo " No Pets <br>";
I like that more. but whatever.
"Jay Fitzgerald" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Does anyone know why this isn't working?? What I am trying to do is
> photos from a database based on each month. This part works fine when I
> it to the current month of December (today) as that is when I uploaded the
> 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"
> $connection = mysql_connect($hostname, $user, $pass) or die ("Unable to
> $query = "SELECT petname, petDesc, petpicture FROM petinfo WHERE petmonth
> $result = mysql_db_query($database, $query, $connection) or die ("Error in
> query: $query. " . mysql_error());
> while (list($pet_name, $pet_Desc, $pet_picture) =
> if ($pet_picture == "")
> echo "No Animals have been posted for $date at this moment. Please check
> back soon.";
> echo "
> <FONT FACE=\"Arial, Helvetica\"><B>Pet of the month</B></FONT><BR>
> <FONT FACE=\"Arial, Helvetica\" SIZE=\"-1\">$pet_Desc<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
> Sorry, we can not hold $pet_name for you (First come first serve
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]