Syntax? on retrieval of data

[rkimball]

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

[Barand]

Be specific in your select clause, so you just have the one \'url\' field from the table you want

 

[php:1:f4a47b0d76]<?php

mysql_select_db(\"woohoo\");

$query = \'select a.url, b.name,b.website from table1 a, table2 b where a.website = b.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\"]);

}

?>[/php:1:f4a47b0d76]

if you want both urls, add ..., b.url as urlB ...

[rkimball]

Thanks, the code worked.

 

rkimball