Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
February 4, 2006, 10:27 am
rate this thread
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
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
$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);