Sorry i think this is my mistake the format that i gave did not get reoected
by the mailing liste
so my structure is
provider books music
video
provider_id title title
title
provider_name provider_id provider_id provider_id
I am making a smal search engine for the site. people can look up all the
books, cd, video from a specific provider. So i need to out put all the
title that correspond to the "keyword they entered" witch would be the
providers name right ... and the providers name
Yann
----- Original Message -----
From: "Bob Hall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 8:26 AM
Subject: Re: Complex mysql query
> >Hi everybody. I got a complexe question well according to me. I am
> >working with PHP and i am making some queries to some database. here
> >is a description of the tables.
> >
> > provider book video music
> > provider_id title title title
> > name provider_id provider_id provider_id
> >
> >
> >
> >I need to select all the title from book, video, music that matches
> >a provider name and not a provider id.
> >
> >I know i can make 2 queries to do it but i am shure i can do a
> >complexe join somewhere that would allow me only to connect once. I
> >want to do it this one because to connect twince to a db could slow
> >down the performance.
> >
> >This problem goes beyound my knowledge of MySQL a bit of help would
> >be appreciated :-)
> >
> >Thanks
> >
> >
> >Yann Larrivée
> >www.ProtonicDesign.Com
>
> Sir, I doubt that you have a table with three columns with the same
> name. If I am wrong, then your copy is MySQL is broken.
>
> If your table structure is what I think it is (It's impossible to be
> sure from your description), it's going to cause you a lot of
> problems. Get a book on relational database design and learn to
> normalize tables. In the interim, if you post a description of what
> you are trying to do, there are a number of active contributors here
> who can make suggestions for a schema.
>
> Bob Hall
>
> Know thyself? Absurd direction!
> Bubbles bear no introspection. -Khushhal Khan Khatak
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
