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
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
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
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
: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
-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
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
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
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
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
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
--
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,
12 matches
Mail list logo