Get records

momal_1

hi,

I have this SQL query:

$recordSet = $db->Execute("SELECT * FROM customer WHERE Member_ID='$appUsername' AND Cust_ID='$appPassword'");

Is ther anyway in which i can display all the records which have been retrieved.

eg.
member_id , cust_id, name
1 1 2
(only the fields are to be viewed)

One will be retrieved is the password and user name are correct - im just trying to try eliminate all problems which there could be with my login script

Thanks

Pig

Yeah, if you are using mysql, then you would do:
while($row = mysql_fetch_array($recordSet) )
{
echo($row['member_id'] . ", " . $row['cust_id'] . ", " . $row['name'] . "<br>");
}

momal_1

Is there a more simpler, universal way as im using microsoft access?

Thanks

Pig

Nope. It's database specific. Looks like you are using a database class already. It should have something like that built in. If it doesn't, look around for access classes and see if there is something already built.