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 <evert.lammerts@gmail.com> To: Nasreen Laghari <nasreen_laghari@yahoo.com> 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. <http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ%20>