prepare( "select subject_id, subjectname from subjects where subjectname = '$tsubj'") ; $sqls->execute() ; $rowsubs = $sqls->FETCH(PDO::FETCH_ASSOC) ; $snob = $rowsubs['subject_id'] ; ?>