I'm a newbie so any help is much appreciated.
I have connected to an sql server db ok but have no idea as to how i check if my username and password match those in the db.
These have been submited from a form on a seperate page
Here is the code i thought would work:
<?php
require('dbconnect.php'); // database connect script.
$sql= "SELECT * FROM tbl_users";
$rs= mssql_query ($sql, $con);
if (password==$password)/AND(username==username) /{
echo 'correct';
}
else{
echo 'incorrect';
}
mssql_close ($con);
?>
