if (($row[0]==1) || ($row[0]==2))
{
echo "Successful.";
die();
}
}
else
{
echo "Go Away!";
echo "You are not authorized to view this resource.";
die();
}
- Original Message -
From: "Rick Emery" <
Hi,
I am setting up a mysql database, with two tables. One keeps the user
authentication info such as user name, password and user level. The other
table with contains files for upload and download. Is there a good way to
setup the user authentication table so it can check appropriate user rights
Hi,
I have setup a table with user login name and password. The password is
encrypted with the MySQL's password(). How do I compare these info with the
user's input.
I had
$query = "select * from auth where
usrname='$logname' and usrpass=password('$logpass')";
mysql_query($query);
But I can'
Hi,
I have a table with username and password. The password is encrypted using
mySQL's password function. But when I try to perform a match using PHP,
e.g.,
$query = "select count(*) from auth
where usrname='$logname' and usrpass=password('$logpass')";
$result = mysql_query($query) or exit ("C
Hi,
I assigned rights to a user in mysql,
mysql> grant all on books.* to bookorama@localhost identified by
'bookorama123';
Then I tried to access mysql in as a regular user,
[bookorama@a177 bookorama]$ mysql -u bookorama books -p;
Enter password: bookorama123
And I get the following error mes
