Outputting data problem

[eluser]skribe[/eluser]
[quote author="mi6crazyheart" date="1293533880"]Then i think there might've some problem in sql query. May be query is not able to match with any records...[/quote]

I considered that. This query runs fine in mysql:

Code:

SELECT ct.type, pc.details FROM person_contact pc LEFT JOIN contact_type ct on pc.contact_id = ct.id WHERE pc.person_id = '1';

I substitute 1 with $id in php.

I've substituted the active records query with this and end up with the same no result.

Thanks for the help so far btw.