if else statement with update function

I am trying to run a function that will update one column with either a 1 or a 0

function directoryent(){
$a=”1″;
$b=”0″;
$result = mysql_query (“SELECT directory FROM clubauth WHERE authorised = 1 and clubid=$_SESSION[‘clubid’]”);

if ($a){
echo ‘You are currently a member of the online directory. Click update to be removed’ ;
else
if ($b){
echo ‘You are not a member of the onine directory. Click update to be entered’;
}
}

The idea is that it checks the database, gives a message and then provides an update button to update the column based on the users id.
Any idea on how i should go about it?

Thanks

Dave

Also in #PHP _↴