Re: [GENERAL] SELECTing on age

2004-12-13 Thread Scott Marlowe
On Mon, 2004-12-13 at 15:15, Kall, Bruce A. wrote: > I'm attempting to select records from my postgresql database using php > based on whether someone is at least 17 years old on the date of a > particular visit. > > My sql is: > > $db_sql = "SELECT * from list WHERE ((visit_date - birth_date) >

Re: [GENERAL] SELECTing on age

2004-12-13 Thread Kall, Bruce A.
I'm attempting to select records from my postgresql database using php based on whether someone is at least 17 years old on the date of a particular visit. My sql is: $db_sql = "SELECT * from list WHERE ((visit_date - birth_date) >= 17)'" $db_result = db_exec($db_sql) $num = pg_num_rows($db_resul