you don't have a connection to the db...either because the name.password, db
name are wrong or you lack the needed permissions to allow the query...
note that this query is a really back idea...opens the whole db up...better
to provide one connection and allow the users basic read write access only
bastien
From: "Richard Hart" <rjhart10@xxxxxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Subject: Help with Date: Mon, 29 Aug 2005 23:27:46 +0100
Hi
I'm new to PHP/MySQL and wondered if anyone on this list would be kind
enough to help me solve
this problem. I'm trying to automatically set up a users privileges on a
MySQL table using the
username and password selected by them in an html form. I get the error
message:
"Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource"
for the code below:
<?php
$username=$_POST['username'];
$password=$_POST['password'];
@ $db = new mysqli('localhost', 'root', 'password', 'database_table');
if (mysqli_connect_errno())
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$grant_privilege = "grant select, insert, delete, update on name_of_table
to
$username identified by '$password'";
mysql_query($grant_privilege, $db);
$db->close();
?>
Can anyone help?
Thanks
Richard
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
