PHP-Function Coding for MS-Access Query

[Anon]

Please find the function coding. please help me in the select statement syntax. i am able to display all records from the access database. but i want to display only the user input idno. equal to field variable in my table in access.

i am using apache php4.0

function Output_Entries() {
/
Make the connection to the database. The syntax is

odbc_connect( 'SYSTEM_DSN' , 'USER', 'PASSWORD' );
$cnx will hold the
pconnect is used to establish a persistent database

connection to the Database until the procedure is completed.
/

$cnx = odbc_connect( 'final' , 'root', '' ); 
if (!$cnx) { 
    Error_handler( "Error in odbc_connect" , $cnx ); 
} 

// send a simple odbc query . returns an odbc cursor 



$cur= odbc_exec( $cnx, "SELECT * FROM Adm_Result Where Number = ?????????"); 
if (!$cur) { 
    Error_handler( "Error in odbc_exec( no cursor returned ) " , $cnx ); 
} 

In the select statement can any one help me in syntax. i want to put a condition for fieldname number is equal to the idno which is form variable (idno) passed from another php file.

the select statement is in a function. i am able to display formvariable if i place echo ($idno) statement above the function statement.

if anyone please help me .. i spend almost 2 days figuring to get the code...

thanx
salim

[salim]

function Output_Entries($idno) {
/
Make the connection to the database. The syntax is
odbc_connect( 'SYSTEM_DSN' , 'USER', 'PASSWORD' );
$cnx will hold the
pconnect is used to establish a persistent database
connection to the Database until the procedure is completed.
/

$cnx = odbc_connect( 'final' , 'root', '' );
if (!$cnx) {
Error_handler( "Error in odbc_connect" , $cnx );
}

// send a simple odbc query . returns an odbc cursor

$cur= odbc_exec( $cnx, "SELECT * FROM Adm_Result Where Number = '$idno");
if (!$cur) {
Error_handler( "Error in odbc_exec( no cursor returned ) " , $cnx );
}