Re: [PHP] SQL help?

2009-05-18 Thread Marcus Gnaß
Skip Evans wrote: Hey all, I have a SQL requirement I'm not quite sure how to compose. I have two tables, shows, and shows_dates. It's a one to many relationship where there is a single entry in shows and multiple entries in shows_dates that list each date and time for a play production

[PHP] SQL help?

2009-05-17 Thread Skip Evans
Hey all, I have a SQL requirement I'm not quite sure how to compose. I have two tables, shows, and shows_dates. It's a one to many relationship where there is a single entry in shows and multiple entries in shows_dates that list each date and time for a play production for a run of entries

[PHP] SQL help

2004-02-10 Thread Marc Greenstock
Hi all here's my problem, I have two tables: 'user_data' and 'image_data' obviously user_data has all the user information and image_data has all the image information in image_data are the fields: Image_ID int(11), User_ID int(11) and Default_Img enum('Yes','No'). Users can have as many images

RE: [PHP] SQL help

2004-02-10 Thread Martin Towell
To: [EMAIL PROTECTED] Subject: [PHP] SQL help Hi all here's my problem, I have two tables: 'user_data' and 'image_data' obviously user_data has all the user information and image_data has all the image information in image_data are the fields: Image_ID int(11), User_ID int(11

RE: [PHP] SQL help

2004-02-10 Thread Vail, Warren
:53 PM To: [EMAIL PROTECTED] Subject: [PHP] SQL help Hi all here's my problem, I have two tables: 'user_data' and 'image_data' obviously user_data has all the user information and image_data has all the image information in image_data are the fields: Image_ID int(11), User_ID int(11

Re: [PHP] SQL help

2004-02-10 Thread Marc Greenstock
-Original Message- From: Marc Greenstock [mailto:[EMAIL PROTECTED] Sent: Wednesday, 11 February 2004 1:53 PM To: [EMAIL PROTECTED] Subject: [PHP] SQL help Hi all here's my problem, I have two tables: 'user_data' and 'image_data' obviously user_data has all the user

RE: [PHP] SQL help

2004-02-10 Thread Larry Brown
To: [EMAIL PROTECTED] Subject: [PHP] SQL help Hi all here's my problem, I have two tables: 'user_data' and 'image_data' obviously user_data has all the user information and image_data has all the image information in image_data are the fields: Image_ID int(11), User_ID int(11) and Default_Img enum

Re: [PHP] SQL help

2004-02-10 Thread Marc Greenstock
Vail -Original Message- From: Marc Greenstock [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 6:53 PM To: [EMAIL PROTECTED] Subject: [PHP] SQL help Hi all here's my problem, I have two tables: 'user_data' and 'image_data' obviously user_data has all the user

[PHP] sql help ?

2002-06-18 Thread Septic Flesh
select * from tracker where day='1' and month=' .$month. ' XXX; XXX = but donot return values with the same value in the sess_id field what should XXX be ? thanks in advance... -- Sapilas/dev/pinkeye -- PHP General Mailing List

Re: [PHP] sql help ?

2002-06-18 Thread w . w . w
select * from tracker where day='1' and month=' .$month. ' XXX; XXX = but donot return values with the same value in the sess_id field what should XXX be ? one line for each sess_id select * from tracker where day='1' and month=' .$month. ' group by sess_id; or one line for

Re: [PHP] sql help ?

2002-06-18 Thread w . w . w
or one line for each sess_id with only one row: select * from tracker where count(sess_id)=1 and day='1' and month=' .$month. ' group by sess_id; sorry that was wrong! correct: select * from tracker where day='1' and month=' .$month. ' group by sess_id having count(sess_id)=1; michi --

[PHP] SQL Help

2002-04-16 Thread De Necker Henri
Hi There. I want to ceate a query that deletes the duplicates for a certain attributes.The table consits of a company id and a course. If a company id and a certain course appears more than once it must be deleted Thank you. -- PHP General Mailing List (http://www.php.net/) To unsubscribe,