php and microsoft access2000

[alternative]

does anyone know how to query access2000's data to a php pages?

[cgraz]

I haven't done this personally, but a quick search on php.net brought me to ODBC functions

Cgraz

[barand]

set up an ODBC DSN and use php's odbc functions

$cnx = odbc_connect(DSN,user,password);

$result = odbc_exec($cnx,SQL_query_string);

while (odbc_fetch_row($result)) {
	$fieldVal = odbc_result($result,N);
	//or $fieldVal = odbc_result($result,’fieldname’);
	. . .
	process row
	. . .
}
or
while (odbc_fetch_into($result,$array)) {
	list($fld1, .., $fldn) = $array;
	. . .
	process row
	. . .
}

hth