RE: [PHP-DB] Help with

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@btinternet.com> To: <php-db@lists.php.net> Subject: [PHP-DB] 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