Hope you can help me. I’m retreving info from a database from two seperate tables. With foreign keys. Heres my sql :
$list = mysql_query("SELECT * from desta_serviceproviders, desta_towns WHERE province = $Id AND desta_serviceproviders.TownId = desta_towns.Id LIMIT $from,$max_results");
So what I’m trying to get… in the table desta_serviceproviders there’s a field called TownId which is a foreign key of table desta_towns. When I get the result, it still only shows the letter in the desta_serviceproviders and not the full name as seen in desta_towns…
Hope this is clear.
Appreciate…