help with query ... join issue

[imarockstar]

 

i have this JOIN query ..

 

$sql="SELECT * FROM tourdates INNER JOIN bands ON tourdates.bandid = bands.id WHERE tourdates.id = '$id' && tourdates.userid = ". $_SESSION['id'];

 

it works great  the only prob is that when I try and display the ID from my TOURDATES table .. its displaying th ID gtom the BANDS table ..

 

how can i display both IDs ?

 

thanks

b

 

 

php v 5

mysql v 4

 

 

[kickstart]

Hi

 

Best not to use SELECT *

 

Specify the columns you are interested in, and if a column name is shared between 2 tables then give them an alias.

 

$sql="SELECT tourdates.id AS tourdateId, bands AS bandId FROM tourdates INNER JOIN bands ON tourdates.bandid = bands.id WHERE tourdates.id = '$id' && tourdates.userid = ". $_SESSION['id'];

 

All the best

 

Keith

[imarockstar]

oh ok .. let me give that a try .. thanks man ..

 

b

[imarockstar]

oh ya duh .. i forgot to mention that i need to retrieve all the info in the table as well .. so i can display it ..

 

thanks

b

[kickstart]

Hi

 

Just add them in, but specify the columns you want (even if all of them, just in case someone adds a massive image as a column on one table which you do not want in this script) and use alias names if needs be.

 

All the best

 

Keith