RE: [PHP-DB] Dates and Count

2004-07-05 Thread zareef ahmed
Hi, $query="select * from clients where date between $date1 AND $date2"; zareef ahmed --- Shannon Doyle <[EMAIL PROTECTED]> wrote: > > Hi Pablo, > > Its exactly what I wanted. Thanks. > > I now have an additional question. > > I need to show results that appear between two dates > as spec

Re: [PHP-DB] Random select -- Where am I going wrong?

2004-07-05 Thread Alvaro Zuniga
See Below On Sun, 2004-07-04 at 05:54, Ronald "The Newbie" Allen wrote: > Here is my code I keep on getting a Resource id #2 ..whatever that > meansany help would be appreciated! > > > > > > Top Frame > > > > alink="#ff"> > > > $db_host = '##; > $db_user = '##

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

[PHP-DB] DB connections ?

2004-07-05 Thread Michael Gale
Hello, I am designing a web that will require access to a specific database. I am also using sessions and am storing the session data in the database. So on every page that loads there will be a connection to the mysql server (local) to access the session db and tables and the web app d

Re: [PHP-DB] DB connections ?

2004-07-05 Thread John W. Holmes
Michael Gale wrote: I am designing a web that will require access > to a specific database. I am also using sessions and > am storing the session data in the database. So on every page that loads there will be a connection > to the mysql server (local) to access the session db and > tables and th

Re[2]: [PHP-DB] MySQL: Random select with specific count of a column

2004-07-05 Thread Pablo M. Rivas
Hello Torsten, TR> thanks for your help. Unfortunately it's always returning the same row for TR> each category (maybe because of the group by) and only one row for each TR> category. I need to select 2 random rows for each category. Any more ideas? I'ts returning 2 rows each RECORD, but the fie