Re: [PHP] mysql joins

2008-03-25 Thread Wolf
Steven Macintyre <[EMAIL PROTECTED]> wrote: > I have three tables, namely; > > User > - UID > - Firstname > - Surname > - Tel > - Cell > - Email > > Tracker > - UID > - Points > > Winners > - UID > - Datetime (-00-00 00:00:00) > > I need to get the following information from the

RES: [PHP] mysql joins

2008-03-25 Thread Thiago Pojda
09:21 Para: php-general@lists.php.net Assunto: [PHP] mysql joins I have three tables, namely; User - UID - Firstname - Surname - Tel - Cell - Email Tracker - UID - Points Winners - UID - Datetime (-00-00 00:00:00) I need to get the following information from the above tables (in my lo

Re: [PHP] mysql joins

2008-03-25 Thread Andrew Ballard
On Tue, Mar 25, 2008 at 8:20 AM, Steven Macintyre <[EMAIL PROTECTED]> wrote: > I have three tables, namely; > > User > - UID > - Firstname > - Surname > - Tel > - Cell > - Email > > Tracker > - UID > - Points > > Winners > - UID > - Datetime (-00-00 00:00:00) > > I need to get th

[PHP] mysql joins

2008-03-25 Thread Steven Macintyre
I have three tables, namely; User - UID - Firstname - Surname - Tel - Cell - Email Tracker - UID - Points Winners - UID - Datetime (-00-00 00:00:00) I need to get the following information from the above tables (in my logical sense) All users from user with sum(points) as points and d

Re: [PHP] MySQL joins

2002-02-25 Thread Richard Baskett
person you meet - and everything you do in life - is an opportunity to learn something." - Tom Clancy > From: "Alexander P. Javier" <[EMAIL PROTECTED]> > Date: Mon, 25 Feb 2002 15:40:47 -0800 (PST) > To: [EMAIL PROTECTED] > Subject: [PHP] MySQL joins > >

[PHP] MySQL joins

2002-02-25 Thread Alexander P. Javier
the query is: select appointment.*, date_format(appointment.startdatetime,'%m-%d-%Y') as yrappt from appointment left join guest on appointment.appointment_id = guest.appointment_id i think it's syntactically correct, it returns the correct rows when run with the mysql.exe program but gets a

RE: [PHP] MySQL joins

2002-02-25 Thread Martin Towell
can you supply some examples please -Original Message- From: Alexander P. Javier [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 10:34 AM To: [EMAIL PROTECTED] Subject: [PHP] MySQL joins why do i get errors on MySQL queries that have joins? alyx

[PHP] MySQL joins

2002-02-25 Thread Alexander P. Javier
why do i get errors on MySQL queries that have joins? alyx - Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games