retrieving data using odbc

[Coz]

I am trying to use data from a form to construct a query to retrieve data from my access database. I am using the following code, but I am getting errors when I try to run the query.

$sql="SELECT answer,questionno FROM '$POST[survey]' WHERE questionno='$POST[number]' ";

$result=odbc_exec($connect,$sql);
$num_r = odbc_num_rows($result);

I am not a php guru and I was wondering if any1 notices something that is wrong the the $sql statement.

Thanks
Chris

[iceiceboom]

$survey = $HTTP_POST_VARS["survey"];
$number = $HTTP_POST_VARS["number"];
$sql="SELECT * FROM $survey WHERE questionno='$number'"; 

$result=odbc_exec($connect,$sql); 
$num_r = odbc_num_rows($result);

Hope this helps...

[Coz]

Yeah, I see my goof-up. Thanks for the help!