php-general | 2001122

[PHP] RE: [PHP-DB] Re: while...if statements??? From: matt stewart (matt <email protected>)
Date: 12/19/01

and i always thought the best tactic was to go ugly early.

seriously, this isn't really that ugly a solution, most textbooks tend to
tell you to use this method to start with as its a bit simpler to understand
for beginners - an if...else statement to see if an initial row is returned,
then you can happily use a do...while on that first row, and it'll carry on
outputting the following rows if there are any more.

-----Original Message-----
From: Chris Lee [mailto:lee <email protected>]
Sent: 18 December 2001 20:49
To: php-general <email protected>; php-db <email protected>
Subject: [PHP-DB] Re: while...if statements???

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']) )
    do
    {
        echo $return['pet_name'] ."<br>";
    } while( $return = mysql_fetch_row($result) );
else
    echo " No Pets <br>";

its ugly but it works. I dont like ugly, so I wrote my own db wrappers.

http://www.mediawaveonline.com/examples/

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. 

--

  Chris Lee
  lee <email protected>

"Jay Fitzgerald" <jayfitz <email protected>> wrote in message
news:5.1.0.14.2.20011218135212.014b4f30 <email protected>
> 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_pictur
e\"
> 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
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01
 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>