Odbc..

[stezz]

I have posted this before, but I am desperate for some help with the matter..

Hey!! I keep getting a supplied argument error when I try and pull some info out of my access db.

Im using ODBC to connect to the db and the connection is successful. But it's giving me a problem when I try and pull out some info. The fields Iv'e selected the data from exist and the condition is also valid..

code:--------------------------------------------------------------------------------
$result = odbc_exec($conn, "SELECT Username FROM tblusers WHERE ID = 1");
$r = odbc_fetch_row($result);
$user = odbc_result($r,1);

echo $user;

Can anyone see the cause of this problem? I feel like the script is just pissing me off for fun

And another thing..

I read on php.net that odbc_fetch_array() was a valid function from php version 4.2.0 up.. im running version 4.3.0 and it said im calling an undifined function. Anyone got any ideas?

Please help!!!

Regards, Stezz.

[Tracer]

Include this function:

function odbc_fetch_array($odbcResID) {
while(odbc_fetch_row($odbcResID)) {
$odbcFieldNum=1;
while($odbcFieldNum<=odbc_num_fields($odbcResID)) {
$odbcFieldName=odbc_field_name($odbcResID,$odbcFieldNum);
$odbcResArr[$odbcFieldName]=odbc_result($odbcResID,$odbcFieldNum);
$odbcFieldNum++;
}
return $odbcResArr;
}
}

The internal odbc_fetch_array is not yet implemented. I'm not sure why it's documented.

Please post more info regarding the error messages you are recieving for the odbc results and what version of windows your running. Are the Acess db and apache server all on the same machine?

To acess odbc drivers from php/apache on a windoze machine, the odbc driver must be SYSTEM, not user.

[stezz]

I am running windows XP home edition and apache. The access mdb file and the apache webserver are on the same machine, yes.

With regard to the error message...

Warning: odbc_result(): supplied argument is not a valid ODBC result resource in c:\documents and settings\stezzy\desktop\files\projects\conn.php on line 7

Regards, Stezz.