RE: [PHP] sqlite AND OR query ?

chris@aquanuke.com wrote: > Hello, > > I want to select two dates one being todays date and the > other being 0000-00-00 which just a date in the database when > no proper date has been entered. > > Ive tried this but it does not work... > > $today = date('Y-m-d'); > $result = sqlite_query($db, "SELECT * FROM domains WHERE date = > '0000-00-00' AND '$today'"); > > I just get items with '0000-00-00' returned or if I reverse it ie... > > WHERE date = '$today'AND '0000-00-00'"); > > I just get $today items returned. > > I also tried using OR instead of AND ie... > > WHERE date = '0000-00-00' OR '$today'"); > > But that seems to be returning all items in the db. > > > Thanks. SELECT * FROM domains WHERE (date = '0000-00-00' OR date = '$today') -B