This is a discussion on how to get records from a parameter query in Access? within the alt.comp.lang.php forums, part of the PHP Programming Forums category; Hi, Our database is Access (i know, i would be better to use Mysql, but at the present time, it'...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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(); ?> |