[SOLVED] mysql Joints and php fetch array

[jaikar]

 

Hi,

 

i use joints in my query

for example .  $query = "SELECT a.id, b.name FROM xxx AS a, yyy AS b WHERE a.id=b.id" and execute this query and use

 

$res = mysql_fetch_array($query);

 

now.... how do i get the value..

 

is it

        $val = $res['a.id']

 

or

 

  $val = $res['id']

 

PLease advice .. Thanks !!

 

Jaikar

[Barand]

$val = $res['id']

 

You reference the column name or the column alias if used. So if the query is

 

SELECT a.id as identity, b.name FROM .......

 

then would need to use

 

$val = $res['identity']

[jaikar]

Thanks...

 

what if the query is like this

 

SELECT a.name, b.name FROM a, b.......

 

then if i use it like  $val=$res['name']  .. which value it will take ?....

 

Thanks again....

[artacus]

Then you'll get b.name because it overwrites a.name. So in that situation, you'd have to alias your fields in order to get the value of a.name

[jaikar]

Excelent !.. Thanks !...