I am new to PHP and trying to insert information into a table automatically by going to a URL. For example. I want it so when I go to
www.url.com?user=test&password=word
it will automatically add the user name and password into the table (users)
I tried using the following for
www.url.com/index.php
<?
$DBhost = "localhost";
$DBuser = "userdb";
$DBpass = "password";
$DBName = "namedb";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to select
database $DBName");
mysql_query("INSERT INTO `Users` VALUES ('$user','$password')") or die(mysql_error());
mysql_close();
?>
This brings me to a blank page but does not add anything to the table
Is there something I might be doing wrong?