select about 2 or more tables (syntax)

[nappel]

hey,
i looked for any solution in different forums and tutorial but never got what i need....

i understood how to create a join with php and mysql, what i didn't understand is how to get all entries from this select.
a normal select i managed with this syntax:

$query = mysql_query("SELECT alttag FROM $table WHERE ID='$ID'");

$i=0;
while ($this = mysql_fetch_array($query))
{
$alttag[$i]=$this["alttag"];
}

what do i have to write instead the while-statement to get different field values of 2 or more tables??

thanx for help...

[ultraslacker]

You just use the attribute names from the SELECT.

$query = mysql_query("SELECT alttag, foo, bar FROM table_a, table_b WHERE a.key = b.fkey AND ID='$ID'"); 

 $i=0; 
 while ($this = mysql_fetch_array($query)) 
 { 
 $alttag = $this['alttag']; 
 $foo = $this['foo']; 
 $bar = $this['bar'];
 } 
 

[nappel]

ok, that works.
but what if i have in each table a field called 'ID'?
how can i say which ID i mean??

-sorry for my bad english-

[ultraslacker]

One way is to alias the field -

SELECT a.ID as a_id, b.ID as b_id FROM a, b..

[nappel]

ok, i will check this out!

thanx for your help!!