selecting more than one distinct

[contra10]

how can i select more than one distinct

i want the name variable and the id

<?php
	 mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("userimages") or die(mysql_error());

$queryi = "SELECT DISTINCT(name) FROM `photoalbum` WHERE `userid` = '$id'";
$resulti = mysql_query($queryi);
while($rowid = mysql_fetch_assoc($resulti))
{
	$ca= "{$rowid['name']}";
$iduu= "{$rowid['paid']}";

echo "<a href='http://localhost/photoalbum/albums.php?alb=$iduu'>$ca</a><br>"; 

}
?>

[contra10]

i tried something like this but it doesn't work

 

$queryi = "SELECT DISTINCT(name, paid) FROM `photoalbum` WHERE `userid` = '$id'";

[skiingguru1611]

Try

 

$queryi = "SELECT DISTINCT name, paid FROM `photoalbum` WHERE `userid` = '$id'";

 

I've never used DISTINCT, but I think that should work.

[JonnoTheDev]

SELECT DISTINCT will only work with an individual field, use a GROUP BY claus