Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
num_rows and fetch array using access
- Thread starter manicleek
- Start date
you want something like:
$conn=odbc_connect("yourodbcsource","","");
$qry = "select firstname,lastname from staff where staffid = 3";
$rs = odbc_exec($conn,$qry);
while (odbc_fetch_row($rs))
{
$firstname = odbc_result($rs,"firstName");
$lastname = odbc_result($rs,"lastName");
printf("%s %s\n",$firstname,$lastname);
}
$conn=odbc_connect("yourodbcsource","","");
$qry = "select firstname,lastname from staff where staffid = 3";
$rs = odbc_exec($conn,$qry);
while (odbc_fetch_row($rs))
{
$firstname = odbc_result($rs,"firstName");
$lastname = odbc_result($rs,"lastName");
printf("%s %s\n",$firstname,$lastname);
}
- Thread starter
- #3
Fair enough, I'm not aware of an ADO extention for PHP but it does have a COM interface. ADO is a wrapper (and more) over oledb so you should be able to get it to work, but I bet it will be hard.
My question is why do you not want to use ODBC ?
My question is why do you not want to use ODBC ?
- Status