Re: date select question (better explained)

2001-04-07 Thread Bob Hall
>> > I'm trying to figure out how to select records from an events >>> database which (from today) will take place on next weekend. The >>> table has a from_date and a to_date fields, among other. I've found a >>> way mixing PHP with SQL, but I'm curious to know if is there a neat >>> and pur

date select question (better explained)

2001-04-07 Thread Llorenc Sole
> > I'm trying to figure out how to select records from an events >> database which (from today) will take place on next weekend. The >> table has a from_date and a to_date fields, among other. I've found a >> way mixing PHP with SQL, but I'm curious to know if is there a neat >> and pure SQL

Re: date select question

2001-04-05 Thread Steve Werby
"Llorenc Sole" <[EMAIL PROTECTED]> wrote: > I'm trying to figure out how to select records from an events > database which (from today) will take place on next weekend. The > table has a from_date and a to_date fields, among other. I've found a > way mixing PHP with SQL, but I'm curious to know if

date select question

2001-04-05 Thread Llorenc Sole
Hi, I'm trying to figure out how to select records from an events database which (from today) will take place on next weekend. The table has a from_date and a to_date fields, among other. I've found a way mixing PHP with SQL, but I'm curious to know if is there a neat and pure SQL version usi