Select query with Forein key Relation

--0-1394483920-1208941893=:628
Content-Type: text/plain; charset=us-ascii

Hi,

I have a table which contains 2 foreign key relation columns. I'm trying to get all columns from main table as well as all column from those 2 foreign key relation tables.

The query i'm using is :

select * from gig where gig.gigid = $gigDetail LEFT JOIN genre ON gig.genreId=genre.genreId LEFT JOIN venue ON gig.venueID = venue.vid ORDER BY gig.gigid";

is this query OK?

I know how to get value from gig table colums but how could i get value of columns from venue table?

Regards

Nasreen






Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.


____________________________________________________________ ________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--0-1394483920-1208941893=:628--

Re: Select query with Forein key Relation

SELECT *
FROM gig
LEFT JOIN genre ON gig.genreId = genre.genreId
LEFT JOIN venue ON gig.venueID = venue.vid
WHERE gig.gigid = $gigdetail

I'd replace the dash with [table].[columnames]. Also, you're using four
different naming conventions in your columns - gigid, genreId, venueID
and vid. If I were you I'd go for one of them and apply this to all.

Evert

Nasreen Laghari wrote:
> Hi,
>
> I have a table which contains 2 foreign key relation columns. I'm trying to get all columns from main table as well as all column from those 2 foreign key relation tables.
>
> The query i'm using is :
>
> select * from gig where gig.gigid = $gigDetail LEFT JOIN genre ON gig.genreId=genre.genreId LEFT JOIN venue ON gig.venueID = venue.vid ORDER BY gig.gigid";
>
> is this query OK?
>
> I know how to get value from gig table colums but how could i get value of columns from venue table?
>
> Regards
>
> Nasreen
>
>
>
>
>
>
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
>
>
> ____________________________________________________________ ________________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Select query with Forein key Relation

It'd be consistent to use uniform naming conventions for your columns.
E.g., an ID column is called 'id' in every table, and if you use two
words in a column name, to separate them either by an underscore or by a
capital letter for the second word.

In PHP a dot is an append operator - to reference a member of a certain
namespace you use '->'. In this case you don't need it though. To get a
column 'vname' from the table 'venue' you use:

while ($row = mysql_fetch_assoc($result)) {
$sub = $row["venue.vname"];
}

Remember that in this case, $sub will always only hold the value of the
last result - or of the only result if there is only one result row.

Nasreen Laghari wrote:
> Hi Evert,
>
> What to you mean by this "If I were you I'd go for one of them and
> apply this to all."
> also to get the value of columns do i need to do following in php
>
> /while ($row = mysql_fetch_array($result))
> {/
> / $sub= $row[venue].[vname];/
> /}/
>
> Regards
>
>
>
> ----- Original Message ----
> From: Evert Lammerts
> To: Nasreen Laghari
> Cc: php-db@lists.php.net
> Sent: Wednesday, April 23, 2008 11:48:39 AM
> Subject: Re: [PHP-DB] Select query with Forein key Relation
>
> SELECT *
> FROM gig
> LEFT JOIN genre ON gig.genreId = genre.genreId
> LEFT JOIN venue ON gig.venueID = venue.vid
> WHERE gig.gigid = $gigdetail
>
> I'd replace the dash with [table].[columnames]. Also, you're using four
> different naming conventions in your columns - gigid, genreId, venueID
> and vid. If I were you I'd go for one of them and apply this to all.
>
> Evert
>
> Nasreen Laghari wrote:
> > Hi,
> >
> > I have a table which contains 2 foreign key relation columns. I'm
> trying to get all columns from main table as well as all column from
> those 2 foreign key relation tables.
> >
> > The query i'm using is :
> >
> > select * from gig where gig.gigid = $gigDetail LEFT JOIN genre ON
> gig.genreId=genre.genreId LEFT JOIN venue ON gig.venueID = venue.vid
> ORDER BY gig.gigid";
> >
> > is this query OK?
> >
> > I know how to get value from gig table colums but how could i get
> value of columns from venue table?
> >
> > Regards
> >
> > Nasreen
> >
> >
> >
> >
> >
> >
> > Be a better friend, newshound, and know-it-all with Yahoo! Mobile.
> Try it now.
> >
> >
> >
> ____________________________________________________________ ________________________
> > Be a better friend, newshound, and
> > know-it-all with Yahoo! Mobile. Try it now.
> http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
> >
>
>
>
> ------------------------------------------------------------ ------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try
> it now.
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php