How to retrieve it?

[kamy99]

I need to do EXACTLY whay jdh was talking about...

As I said , I did try the code , but I couldn't retrieve from it. Since my out put is through an array, I tried every field (ie $i[0];.....), they all produced data from the Products table, I even can extract the CatID number from Products table, but I need to display the Cat name not ID.

Does this make sense?

[Mahamoti]

Try this:

(assume two tables, A and B, A has columns id and name, B has columns id and phone)

$sql= "select * from A, B ".
"where A.id=B.id ".
"order by A.id";

$q= mysql_query($sql);

while($r= mysql_fetch_array($q)){
echo("ID: ".$r['id'].", Name: ".$r['name'].", Phone: ".$r['phone']);
}

• Mahamoti

[kamy99]

Thanx a lot, that worked beutifully!