SQL Values

[01hanstu]

Is there a way of having a script perform the following :

 

 

If room is booked then print who booked it and who for i.e. Mr Jones Y7

" If Bkd = yes then [print name/Year]"

else

" If Bkd = no then [print picture that is linkable to the booking form]" ;

 

Please Advise

 

[The Little Guy]

Something like this:

 

// Connections to Database go here.


$sql = mysql_query("SELECT * from table_name WHERE id = '23'");
$row = mysql_fetch_array($sql);
if($row['Bkd'] == 'yes'){
     echo $row['name'].' / '.$row['year'];
}else{
     echo '<a href="/someLink.php">No</a>';
}

[01hanstu]

Thanks for your reply, my booking system actually looks better with the pictures.

 

Once again Thanks