Similar columns in separate tables

[netfrugal]

I have a few tables with similar columns in 2 of them. But they are not columns I would match up.

$sql = mysql_query("SELECT c.*, t.* FROM table1 c, table2 t WHERE c.customer_id = t.customer_id"); 
 while ($row = mysql_fetch_array($sql)) {

$type = $row['type'];
 }

<? echo $type; ?>

There is a 'type' column in table1 and a 'type' column in table2. But they are completely different. Is there a way to display the type from table1 only? Or will I have to rename one of the columns?

[NogDog]

I would probably explicitly list the fields to be retrieved, and use aliases to differentiate them as needed:

SELECT c.foo, c.bar, c.type AS c_type, t.blah, t.yadda, t.type AS t_type FROM . . .

You would then reference it as $row['c_type'] in this example.