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