MySQL problem with Insert Clause

Question

Hi! I've spent hours on this problem and for the life of me I can't figure it out, I have an Insert MYSQL command that is not executing, I've tried manually running the query on phpMyadmin and it actually does work but for some reason when the site runs the command, nothing is entered into the database. I have

$sql = "INSERT INTO beforeActivation (about, 
  firstname, lastname, businessname, typeofpractice, 
  practicespecial, gender, address, city, zip, cellphone, 
  businessphone, email, username, password, date) 
VALUES('$about', 
  '$firstname', '$lastname', '$businessname', '$typeofpractice', 
  '$practicespecial', '$gender', '$address', '$city', '$zip', '$cellphone', 
  '$businessphone', '$email', '$username', '$password', CURDATE())";

mysql_query($sql) or die(mysql_error());
$_SESSION["idForBeforeAct"] = mysql_insert_id();

Importantly, the script continues to run it does not 'die' or spit out any type of error it merely announces that the info was entered and continues to the next form. I ran the exact same query on phpmyadmin and it filled the table up with the variable names like $cellphone because they aren't assigned to anything (obviously). But the main point is the insert command is working, no syntax error, if anyone has any advice it would be a huge help thank you!

Answer 1

Check that you have autocommit turned on if your table is InnoDB.

Answer 2

i found my mistake, the command works, there was a stray opendb() function which pointed to the db prior to .com switch, sorry guys thanks for all your efforts