By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,951 Members | 1,069 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,951 IT Pros & Developers. It's quick & easy.

how to get records from a parameter query in Access?

P: n/a
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();
?>
Feb 4 '06 #1
Share this Question
Share on Google+
1 Reply


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

Feb 9 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.