is there a better way of doing this?

[freefony]

function one_venue($time,$venue,$date,$code){
    $qry="select * from timetable where time='$time' and date='$date' and venue='$venue'";
    $rst=mysql_query($qry) or die (mysql_error());
    if(mysql_num_rows($rst)>0){
        $msg="An Event is holding in".$venue."at".$time.".! Please fix this event for another time or venue";
        return $msg;
    }
    else{
        one_class($time,$code,$date);
    }
}
function one_class($time,$code,$date){
    $qry="select * from timetable where time='$time' and date='$date' and code='$code'";
    $rst=mysql_query($qry) or die (mysql_error());
    if(mysql_num_rows($rst)>0){
        $msg="An Event has been scheduled for this class at this time (".$time.")!. Please fix this event for another time";
    }
    else{
        $msg="The event has been registered successfully!";
    }
    return $msg;
}
 

[Markus]

Probably. Could you be more specific?

[freefony]

the first function check if there is an event holding in the chosen venue at the time the user chose if there is then the new the user have to fix the event for another time or venue this so that no 2 event will scheduled for the same venue at the same time if false then it will call the second function to check if the class is not engaged in another event its a project for school timetable