table joining question

[imarockstar]

I am currently joining these 2 tables ->

 

<?php

$sql="SELECT * FROM todo INNER JOIN users ON todo.userid = users.id WHERE  todo.userid = '{$_SESSION['id']}' " or die(mysql_error());
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
?>

<div class='boxd'><a href=''><? echo $rows['title']; ?></a></div>
<div class='boxb'><span class="submitted">submitted by</span> <? echo $rows['name']; ?></div>		
<div class='boxb''><span class="submitted">complete by</span> <? echo $rows['deadline']; ?></div>


<br class="clear">
<? } ?>

 

 

Works fine .. but i need to add one more table to the join .. .which is a table called BANDS and i need to join is based on the USERID .. so the join would look like this 'users.id = bands.userid' but I am not sure how to include that into the query ...

 

any help would be rad !!!

 

[corbin]

SELECT blah FROM bleh JOIN bleck JOIN blerh;

 

 

 

Is the basic skeleton of what you're asking.

[imarockstar]

what about the 'INNER JOIN users ON' do i need to do the 'ON' again ?

[fenway]

Yes... one join, one join condition.

[imarockstar]

i did this ....

 

$sql="SELECT * FROM todo INNER JOIN users ON todo.userid = users.id  INNER JOIN bands ON todo.userid = bands.userid WHERE  todo.userid = '{$_SESSION['id']}' "

 

and it like doubled all my output lol ..

 

oh ya sorry ... mysql v4.5 . i believe

[fenway]

There's nothing wrong with that... not sure what you mean by doubled -- you're asking for *.