[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

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 the following

RES: [PHP] mysql joins

2008-03-25 Thread Thiago Pojda
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 logical sense) All users from user with sum

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 above tables (in my

[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

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
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

Re: [PHP] MySQL joins

2002-02-25 Thread Richard Baskett
- 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 the query is: select appointment.*, date_format