Heya, is it possible to run a mysql query in a while loop? It's not working for me with the code below..
It's suppose to select from table "bookmarks" where favourite = "1", if favourite is 1 then it's suppose to show one part of the code, if not another part of the code inside a while loop.(see below) Apparently I did something wrong as it only show one part of the code no matter if favourite is 0 or 1.
echo "<td><a href=\"favourite_delete.php?name=$row[name]\" alt=\"Favourite Remove\" ><img name =\"Favourite Remove\" src=\"/pictures/favourites-star-filled.png\"></a></td>";
if($favourite){
echo "<td><a href=\"favourite_delete.php?name=$row[name]\" alt=\"Favourite Remove\" ><img name =\"Favourite Remove\" src=\"/pictures/favourites-star-filled.png\"></a></td>";
}
else
{
echo "<td><a href=\"favourite_add.php?name=$row[name]\" alt=\"Favourite Add\"><img name =\"Favourite Add\" src=\"/pictures/favourites-star-gray.png\"></a></td>";
}
$result = mysql_query("SELECT * FROM bookmarks
WHERE username='$name' ORDER BY name");
$favourite = mysql_query("SELECT * FROM bookmarks WHERE favourite = '1' and username='$name'");
while($row = mysql_fetch_array($result)){
echo "<center><table width=\"300\" height=\"30\" border =\"1\"><tr>";
echo "<td width=\"300\">";
echo "$nr. <a href=\"link_click.php?link=$row[link]\" target=\"_blank\">$row[name]</a>";
if($favourite){
echo "<td><a href=\"favourite_delete.php?name=$row[name]\" alt=\"Favourite Remove\" ><img name =\"Favourite Remove\" src=\"/pictures/favourites-star-filled.png\"></a></td>";
}
else
{
echo "<td><a href=\"favourite_add.php?name=$row[name]\" alt=\"Favourite Add\"><img name =\"Favourite Add\" src=\"/pictures/favourites-star-gray.png\"></a></td>";
}
echo "<td><a href=\"delete_link.php?name=$row[name]\" alt=\"Delete\" onclick=\"return confirm('Are you sure want to remove $row[name] from your list?');\"><img name =\"Delete\" src=\"/pictures/delete.gif\"></a></td></tr><br /></table></center>";
$nr = $nr+1;
}
