[SOLVED] Troubles with SQL Queries

[garry]

So I'm having a little trouble with my SQL queries and distinguishing between the different ID's that I want to get. Here's an example of a query (just made up to show you what i mean):

 

$query="
SELECT artists.id, reviews.id
FROM artists, reviews
WHERE blah blah blah
";

$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result)) {
echo  $row['id'];
}

 

So how can I make it so I can distinguish from which table I want to get the ID from?

 

Thanks!

[Barand]

use aliases

 

SELECT artists.id as artistid, reviews.id as reviewsid

[garry]

Works like a charm, thanks buddy