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:[EMAIL PROTECTED]] Sent: 18 December 2001 20:49 To: [EMAIL PROTECTED]; [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 [EMAIL PROTECTED] "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 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [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 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]