RE: [PHP] COM
| From: | jon roig | Date: | Mon, 31 Mar 2003 20:21:11 +0000 |
| Subject: | RE: [PHP] COM | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-141734@lists.php.net to get a copy of this message | ||
Is there some reason you want to access it through com?
I'm assuming that you've added the access db as an odbc data source? I'm not
sure, but it seems like you might be using the wrong syntax.
You might want to check out this:
http://www.php.net/manual/en/ref.odbc.php
... or... this, which is a good example of how to use odbc in php:
http://php.weblogs.com/odbc
Also, is it giving you an error or just not returning results?
-- jon
-------------
jon roig
senior manager, online production
epilepsy foundation
http://jonroig.com
-----Original Message-----
From: Kiswa [mailto:Kiswa@telia.com]
Sent: Saturday, March 29, 2003 4:17 AM
To: php-general@lists.php.net
Subject: [PHP] COM
Server Win2000 +ISS5 +PHP
Trying to get access to an access DB through COM but i wont work. there is
no results generated.
Can anyone help me
Here is the code
$rownum =0;
$conn = &ADONewConnection('access');
$conn->PConnect('webdb.mdb');
$result = &$conn->Execute('SELECT Produkt, Artikelnr, Pris, Lagerstatus,
Beskrivning, Kategori, Bild FROM Data');
while(odbc_fetch_row($result)){
$Produkt = odbc_result($result, Produkt);
$Artikelnr = odbc_result($result, Artikelnr);
$Pris = odbc_result($result, Pris);
$Lagerstatus = odbc_result($result, Lagerstatus);
$Beskrivning = odbc_result($result, Beskrivning);
$Kategori = odbc_result($result, Kategori);
$Bild = odbc_result($result, Bild);
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php