PHP SQL query

[emc]

I've been trying to get to working all night but no luck...
The query works and gives the right answer when i put it into phpmyadmin directly as an SQL but does not give a value whenever i have it as part of a php code
'teacherid' is a value

//userlevel
$qry = "SELECT accesslevel.level FROM accesslevel, teacher WHERE accesslevel.position= teacher.position AND teacher.teacherid= 'teacherid'";
$result=mysql_query($qry);
 $row = mysql_fetch_assoc($result);
     $level = $row['level'];

[NogDog]

Should there be a "$" before "teacherid" at the end of the query (to make it a PHP variable)?

[__berfuzz]

emc> You should get a editor that highlights the kod. Then you wouldn't miss things like that.