Hi guys

Im a beginner with SQL so forgive me for being stupid. Im trying to insert simple data into a database table, it doesnt seem to work. I am using phpMyAdmin to check the contents of the table but it never seems to include the information sent to it from my website.

The code is as follows:

$dbname= 'database1';
$dbcnx = mysql_connect('111.111.111.111', 'username', 'password');
or die("Connection Failure to Database");
mysql_select_db($dbname, $dbcnx) or die ($dbname . " Database not found. ");
$sql ="INSERT INTO `test` ( `id` , `name` , `answer1` ) VALUES ( NULL , $user , $q1);";
mysql_db_query($dbname, $sql) or die("Failed Query of " . $sql);

Your help would be greatly appreciated.
:D
Cheers in advance

Hi,
What is the error you are getting, try with this code,

$dbcnx= mysql_connect('111.111.111.111', 'username', 'password')OR die(mysql_error());
mysql_select_db("database1",$dbcnx)or die("did not select database");
$sql="insert into test(name,answer1) values('$user','$q1')";
mysql_query($sql);

i think in your code following line only some errors
$sql ="INSERT INTO `test` ( `id` , `name` , `answer1` ) VALUES ( NULL , $user , $q1);";

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com