Re: Not getting results if 0

Wow, the only thing I can say for myself is DUH as I slap my forehead. I don't know why I didn't think of that. But thank you Natalie. "Natalie Leotta" <LeottaN@ims.nci.nih.gov> wrote in message news:7546CB15C0A1D311BF0D0004AC4C4B0C024AC071@SSIMSEXCHNG... > Are you looking it up in a database? If so you'd want to do something like > where price > 0. Then it wouldn't return those results. > > -Natalie > > -----Original Message----- > From: Jennifer Downey [mailto:jendowney@attbi.com] > Sent: Monday, April 29, 2002 2:01 PM > To: php-db@lists.php.net > Subject: [PHP-DB] Not getting results if 0 > > > Hi all, > > I am wondering how to keep something from beind displayed if a price is set > to 0? > > I have a store where the user looks up items, but it shows all items even if > the price is 0. Is there a way to prevent the items set at 0 from being > displayed? > > Thanks > Jennifer > > -- > The sleeper has awaken > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002