Re[2]: [PHP-DB] Dates and Count

2004-07-05 Thread Pablo M. Rivas
Hello Shannon, mmhh.. i think this is simple as: Select * from mytable where nextcontact>='$today' and nextcontact<='$week' and (custid=3 or custid=5) and (languaje='de' or languaje='en') I'm not sure if it helps, but you can ask again or provide an example... ;) SD> Secon

RE: [PHP-DB] Dates and Count

2004-07-05 Thread zareef ahmed
nt to > search from a variety of > different fields, show those that are between the > dates and are equal to one > other criteria. > > Any help on these two? > > Cheers, > > Shannon > > > -Original Message----- > From: Pablo M. Rivas [mailto:[EMA

RE: [PHP-DB] Dates and Count

2004-07-04 Thread Shannon Doyle
ECTED] Sent: Monday, 28 June 2004 9:21 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Dates and Count Hello Shannon, SD> First, I have two dates stored in a MySQL DB that I want to do a compare on SD> and then only display via a web page those records that have a 5 or greater SD> day d

Re: [PHP-DB] Dates and Count

2004-06-28 Thread Pablo M. Rivas
Hello Shannon, SD> First, I have two dates stored in a MySQL DB that I want to do a compare on SD> and then only display via a web page those records that have a 5 or greater SD> day difference in them. What would be the best way to achieve this. Depends on your mysql version... select * from

[PHP-DB] Dates and Count

2004-06-27 Thread Shannon Doyle
Hi People, I have two queries for the list:- First, I have two dates stored in a MySQL DB that I want to do a compare on and then only display via a web page those records that have a 5 or greater day difference in them. What would be the best way to achieve this. Second, I want to be able to r