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 produc

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

Re: [PHP] SQL help

2004-02-10 Thread Marc Greenstock
_data.Default_Img in ('Yes', '') > GROUP BY user_data.User_ID > > hope this works for you, good luck, > > Warren Vail > > > -Original Message----- > From: Marc Greenstock [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 10, 2004 6

RE: [PHP] SQL help

2004-02-10 Thread Larry Brown
PROTECTED] Sent: Tuesday, February 10, 2004 9: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 i

Re: [PHP] SQL help

2004-02-10 Thread Marc Greenstock
t; do some reading up on how to do it... > > HTH > Martin > > > > -Original Message- > > From: Marc Greenstock [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, 11 February 2004 1:53 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP] SQL help

RE: [PHP] SQL help

2004-02-10 Thread Vail, Warren
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 information and image_data has all the image informatio

RE: [PHP] SQL help

2004-02-10 Thread Martin Towell
day, 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 information and > image_data has all

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

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

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

[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 (http://w

[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, vis