dharmil
New Member
- Messages
- 1,656
- Reaction score
- 0
- Points
- 0
i get repeated results with this, dose any one know why
PHP:
$result = mysql_query("SELECT albums.id AS albumsid, albums.name AS albumsname, users.id AS usersid, users.album AS usersalbum FROM albums, users");
while($row = mysql_fetch_array($result))
{
echo "<option ";
if($row['albumsid'] == $row['usersalbum'] && $row['usersid'] == $_GET['id']){
echo "selected=\"selected\"";
}
echo " value=\"".$row['albumsid']."\">".$row['albumsname']."</option>";
}
Last edited: