[PHP-DB] mysql versus mysqli versus db abstraction

Hello, I was wondering how many of you have made the switch to mysqli from the mysql library? I teach a class in PHP/MySQL and want to keep current with what industry folks are doing. I did not immediately adopt mysqli into my classroom and am wondering if it's time. I was also wondering how man

[PHP-DB] Warning

Hi all, I received a mail today subject "URGENT ASSISTANCE NEEDED" This is a scam, I relieved it to my mail address were I only receive mail from the PHP DB List so it seems that they are now scanning our list for e-mail addy's You can read more on this type of fraud at www.419eater.com

Re: [PHP-DB] MySQL query, using DISTINCT...

On Tuesday 06 July 2004 17:58, [EMAIL PROTECTED] wrote: > I have a system that tracks downloads, capturing loadsa info, but of > interest here, is email and filename. > Simply put, I wanna show all results where file name AND email are unique. > (so if email '[EMAIL PROTECTED]' has filename 'word.d

Re[2]: [PHP-DB] Re: MySQL query, using DISTINCT...

Hello Tristan, Select count(id) as howmany, file_name, email from `completed_downloads` where bu='reech' and date BETWEEN '2004-06-01' AND '2004-06-30' group by file_name, email >> > I have a system that tracks downloads, capturing loadsa info, but of >> > interest here, is

Re: [PHP-DB] Re: MySQL query, using DISTINCT...

Hi, using "group by" can also be usefull. zareef ahmed --- Torsten Roehr <[EMAIL PROTECTED]> wrote: > "Tristan Pretty" <[EMAIL PROTECTED]> > wrote in message > news:[EMAIL PROTECTED] > com... > > I have a system that tracks downloads, capturing > loadsa info, but of > > interest here, is emai

Re: [PHP-DB] Re: MySQL query, using DISTINCT...

> > I have a system that tracks downloads, capturing loadsa info, but of > > interest here, is email and filename. > > Simply put, I wanna show all results where file name AND email are unique. > > (so if email '[EMAIL PROTECTED]' has filename 'word.doc' 5 times in a table, > > I want to only see

[PHP-DB] Re: MySQL query, using DISTINCT...

"Tristan Pretty" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] com... > I have a system that tracks downloads, capturing loadsa info, but of > interest here, is email and filename. > Simply put, I wanna show all results where file name AND email are unique. > (so if email '[EMAIL PROT

[PHP-DB] MySQL query, using DISTINCT...

I have a system that tracks downloads, capturing loadsa info, but of interest here, is email and filename. Simply put, I wanna show all results where file name AND email are unique. (so if email '[EMAIL PROTECTED]' has filename 'word.doc' 5 times in a table, I want to only see it once.) What am

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

"Pablo M. Rivas" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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