[SOLVED] simple echo from mysql

[contra10]

I want to echo the input from my mysql but only one of each album name...ie if there is 4 "Dogs" and 3 "Cats" it only echoes 1"Dog" and 1"Cat"

 

<?php
$queryi = "SELECT * FROM `photoalbum` WHERE `userid` = '$idpic'";
$resulti = mysql_query($queryi);
while($rowid = mysql_fetch_assoc($resulti))
{
$iduu= "{$rowid['album']}";

echo"<option value='$iduu'>$iduu</option>"; 
}
?>

[pocobueno1388]

Try to change your query to:

 

$queryi = "SELECT DISTINCT(album) FROM `photoalbum` WHERE `userid` = '$idpic'";

[contra10]

it worked but do u know why only the first one is being echoed in the select option and the rest are outside?

<?php echo "<select type='Submit' name='album' disabled>"; 

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

$queryi = "SELECT DISTINCT(album) FROM `photoalbum` WHERE `username` = '$usernamecookie'";
$resulti = mysql_query($queryi);
while($rowid = mysql_fetch_array($resulti))
{
$iduu= "{$rowid['album']}";

echo"<option value='$iduu'>$iduu</option>"; 
echo"</select>";
}

?>

[pocobueno1388]

Because you are closing your select inside the loop.

 

Change your while loop to this:

 

   while($rowid = mysql_fetch_array($resulti))
   {
$iduu= "{$rowid['album']}";

echo"<option value='$iduu'>$iduu</option>"; 
   }

echo"</select>";