[RESOLVED] Query array question

[182x]

hey guys, I was trying to do a join query and display results from both tables. I think I went wrong with the array syntax or was there another problem?

thanks.

$test=select * from tableA, tableB where tableAId = tableBId;
$query=mysql_query($test, $link_id) or die(mysql_error());

while($get=mysql_fetch_array($query))
{

 echo "<tr class='style4'><td>".$query['tableA.ds']."</td><td>".$query['tableB.hy']."</td></tr>";
}

[NogDog]

I'm not sure how the array elements returned by mysql_fetch_array are labeled in a query like that, when you have a table join but have selected on "*". I'd suggest trying the following to find out, after doing the query:

$get = mysql_fetch_assoc($query);
printf("<pre>%s</pre>\n", print_r($get, 1));

[NogDog]

PS: Alternatively, explicitly select the desired columns, using aliases so that you know how they'll be labeled in the query output:

$sql = "SELECT t1.col_name AS alias1, t2.col_name AS alias 2 FROM table1 AS t1
INNER JOIN table2 AS t2 ON <...etc....>";

[182x]

Ah I think I see how it works now, I used the code you kindly provided in your first reply which showed that instead of having elements for both tableA.example and tableB.example it will just have one element'example'.

Im not sure why it does it this way should this be questioned or is this just the mysql way?

[NogDog]

I believe it is a MySQL thing: the labels come from what is returned by the query.