how to get records from a parameter query in Access?

[Bill]

Hi,

Our database is Access (i know, i would be better to use Mysql, but at the
present time, it's access ...) and i created a parameter query (like a
stored procedure in Mysql) for identification with name 'proctest'. The
criterium in the query is [na]. PHP must execute the query with the value of
variable 'name'.
I know how to use PHP with access using dynamic sql, but i don't know how to
do with a query.
Here is a attempt, but doesn't work.
Thanks for helping
Bill

<?php
name="bibi";
$db = 'c:\\mydb.mdb';
$conn = new COM('ADODB.Conn ection');
$conn->Open("Provider =Microsoft.Jet. OLEDB.4.0; Data Source=$db");
$rs = $conn->Execute('proct est' na);
while (!$rs->EOF)
{
$lg=$rs->fields[0];
echo $lg;
echo "<br>";
$rs->MoveNext();
}
$rs->Close();
$conn->Close();
?>

[Drakazz]

Re: how to get records from a parameter query in Access?

try msdn.com / microsoft.com / google -> "Microsoft Access procedure
list SQL query" , using Access and ODBC is not a php issue