Selecting from table using yes/no variable

Andy_Pugh

Hi,

Hoping someone can help me!!

I have a database to publish my news..

I have a table called active .... it can be inputted into the database via a dropdown box saying yes no..

basically I want to include in my select from query, whereby only the storys with active yes will appear?

Hope this makes sense.. heres the code to order by category i'm assuming it needs a simple WHERE active LIKE 'YES'".$_GET["active"] ???

it's just getting it in the right place.. can anyone help?

<?
if ($showbizid == "") {
$sql="SELECT * FROM showbiz WHERE category LIKE '" . $_GET["category"] . "%'";
$result=mysql_query($sql);
$ncount=0;
echo "<font size=1> </font>";
while ($myrow=mysql_fetch_array($result)) {
if ($ncount<100)
{
$ncount=$ncount+1;
$showbizlong = str_replace("\'", "'", $showbizlong);
?>

Thanks a lot!
Andy