Having Some Trouble . . .

[blinkitout]

This is just the snippet of a page I am working on that I cannot get working properly.

[php]$favbands = mysql_query(“SELECT id,bandid,userid FROM favbands WHERE bandid=’$band[id]’ AND userid=’$userid’”);

if ((!$favbands[id])) { $faveband = “<a href=$baseURL/favband.pro.php?id=$band[id]&userid=$userid class=myButton>Add To Favorites”;}
else { $faveband = “<a href=$baseURL/unfavband.pro.php?id=$band[id]&userid=$userid class=myButton>Remove From Favorites”;}[/php]

I want it to show “Add To Favorites” when a user had not yet added it to their favorites. And show “Remove From Favorites” when they have already faved it. I know this should be a fairly simple thing to do, but it seems EVERYTHING I tried did not work. Thanks for the help in advance!

[jSherz]

When you use mysql_query, it either returns FALSE (if the query failed) or (in the case of a SELECT query), a MySQL resource that you can then use to get the data.

[php]$favbands = mysql_query(“SELECT id,bandid,userid FROM favbands WHERE bandid=’$band[id]’ AND userid=’$userid’”);

if($favbands == false) {
echo mysql_error();
} else {
if(mysql_num_rows($favbands) == 1) { // A result was found - they’ve got this as a favourite
$faveband = “<a href=$baseURL/unfavband.pro.php?id=$band[id]&userid=$userid class=myButton>Remove From Favorites”;
} else {
$faveband = “<a href=$baseURL/favband.pro.php?id=$band[id]&userid=$userid class=myButton>Add To Favorites”;
}
}[/php]

mysql_query
mysql_num_rows

[blinkitout]

@jSherz Thank you so much. It works now.