Left Join problem....now Id's in result...

[sgtpepper]

Hello,

This is very odd...my query is this

SELECT * FROM mastertable LEFT JOIN featuredlistings20 ON mastertable.Id=featuredlistings20.Id
where mastertable.lister_office_name='Jim' or mastertable.lister_office_name='Jam'
ORDER BY featuredlistings20.our_listings DESC
");

I am able to echo all results from this query echo $row[field]

EVERYTHING works....except now values are returned for echo $row[Id].

Any ideas?

[leatherback]

• You can (Read should) specify which colums you want to be shown, and/or returned from the query:

while$row=mysql_fetch_array))
{
echo $row[NAME]. $row[NAME2];
}

and:

Select COLUMNAME, COLUMNAME, ... FROM mastertable LEFT JOIN featuredlistings20 ON mastertable.Id=featuredlistings20.Id
where mastertable.lister_office_name='Jim' or mastertable.lister_office_name='Jam'
ORDER BY featuredlistings20.our_listings DESC
");