trouble using ADO object with php

[adren]

I'm making a forum script in php, storing data in Microsoft Access DB. I've a problem when I try to use some recordset properties and methods.
Those are EOF BOF and eof() bof().
When I send a query to DB like

$rs = $db->execute("SELECT * FROM users WHERE usrname = '$name' AND password = '$usrpass'");

and the quey give no results
$rs is a blank recordset...
EOF may be set true
BOF may be set true
eof() may return true
bof() may return true

but this code do not work properly

if(!$sel->eof())
{
$value = $sel->fields['usrname']->value();
echo "Welcome $value";
}
else
{
echo ="Sorry, uncorrect information. Not logged in";
}

Could you help me, please?
(Excuse me for my mistakes)

[bastien]

PHP does not support ADODB with out the module for adodb loaded
see the php manual at
http://www.php.net/manual/en/function.dbx-connect.php

hth

bastien

[bogdanzagan]

Try this:
$value = $sel->fields[0]->value();
where 0 is the first column in your Access Database Table.
So change 0 with the ursname column number -1

Enjoy