[Syntax? on retrieval of data]

Thanks, the code worked.

 

rkimball

[Syntax? on retrieval of data]

Hello.

 

If I am retrieving data from multiple tables using a join and two of the tables have fields that are the same name how do I spit it back out in PHP?

 

e.g.

 

mysql_select_db(\"woohoo\");

$query = \'select * from table1, table2 where table1.website = table2.website;

$result = mysql_query($query);

$num_results = mysql_num_rows($result);

 

for ($i=0; $i<$num_results; $i++)

{

• $row = mysql_fetch_array($result);

echo stripslashes($row[\"url\"]);

echo stripslashes($row[\"name\"]);

• }

 

 

Both tables have a url value. I\'ve tried using \"table1.url\" instead of \"url\" but to no avail. If I just use \"url\" it gives me the later \"table2.url\"...possibly writing over?

 

Any suggestions, smart a** comments or slaps in the head are welcome.

 

Thanks,

 

rkimball