I have this page with 3 database connections setup (correctly)
But whenever I try to insert data into ONE table, it just won't do anything.
There are no errors, and query never executes.
My database connection: (The problematic one)
[syntax=php]$db1 = mysql_connect("127.0.0.1", "USERNAME", "LOLPASSWORD")or die("Connection error (AUTH|Mi)");
mysql_select_db("DB_NAME")or die("Connection error (DB|Mi)");[/syntax]
The script I'm trying to run:
[syntax=php]$for = mysql_real_escape_string(htmlentities($_POST['acc_for']),$db1);
$reg_id = mysql_real_escape_string(htmlentities($_POST['reg_id']),$db1);
$reg_pass = mysql_real_escape_string(htmlentities($_POST['reg_pass']),$db1);
$crt = mysql_real_escape_string(htmlentities($_POST['crt']),$db1);
mysql_query("INSERT INTO reg_id (for, registration_number, registration_password, CRT, registrar) VALUES ('$for', '$reg_id', '$reg_pass', '$crt', '$usr')", $db1);[/syntax]
I could only assume syntax? Thats always the problem with me
![Razz :P](./images/smilies/icon_razz.gif)
Please help me, its been annoying me all day :/