[PHP-DB] Select query with Forein key Relation

2008-04-23 Thread Nasreen Laghari 
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

Re: [PHP-DB] Select query with Forein key Relation

2008-04-23 Thread Evert Lammerts 

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: [PHP-DB] Select query with Forein key Relation

2008-04-23 Thread Evert Lammerts 
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 [EMAIL PROTECTED]
To: Nasreen Laghari [EMAIL PROTECTED]
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



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