Home > Archive > PHP SQL > February 2006 > how to get records from a parameter query in Access?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
how to get records from a parameter query in Access?
|
|
|
| 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.Connection');
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db");
$rs = $conn->Execute('proctest' na);
while (!$rs->EOF)
{
$lg=$rs->fields[0];
echo $lg;
echo "<br>";
$rs->MoveNext();
}
$rs->Close();
$conn->Close();
?>
| |
| Drakazz 2006-02-09, 7:56 am |
| try msdn.com / microsoft.com / google -> "Microsoft Access procedure
list SQL query" , using Access and ODBC is not a php issue
|
|
|
|
|