INNER JOIN - Question - PHPBuilder Forums

INNER JOIN - Question

listenmirndt

I am using :

mysql_query ("SELECT * FROM $table INNER JOIN PACKAGES ON LISTINGS.PACKAGE = PACKAGES.ID $string ORDER BY PACKAGES.RANK ASC, $_GET[sortby] LIMIT $start,$_SESSION[limit]");
while ($row = @mysql_fetch_array ($query2))

Just one problem, I want to print the ID of the LISTINGS table, but instead, when I use echo $row[ID], I get the ID of the PACKAGES table..,

How can I print the ID of the LISTINGS table?

Thanks!

NogDog

The shortest solution might be:

$sql = "SELECT *, LISTINGS.ID AS LID FROM . . . ";

You could then reference that field as $row['LID']. Probably a little more efficient (especially if there are any columns in the tables you are not using) plus providing less ambiguity would be to explicitly list all fields to be selected, using column prefixes and "AS" aliases where needed to avoid ambiguity.

listenmirndt

thanks!!

bogu

Don't forget to mark this thread as RESOLVED...