Can't Write in the Database using INSERT INTO

PHP/MySQL

[Francis]

This is my script:

$table_to_use = "irr_accounts";
include ($_SERVER['DOCUMENT_ROOT'].'/snippets/cnx.php');

$query = "INSERT INTO $table_to_use (account_number, handling_branch, acct_type, school, address, street, city, contact_person, contact_number, first_name, last_name, date_applied, date_approved, end_date, status) VALUES

('$account_number', '$handling_branch', '$account_type', '$school', '$address', '$street', '$city', '$contact_person', '$contact_number', '$first_name', '$last_name', '00-00-00', '00-00-00', '00-00-00', '$status')";

mysql_query("COMMIT");

Looks ok. However, it is not writing. Please help. Thanks.

[jaski]

> mysql_query("COMMIT");

try this instead

mysql_query($query);

[Francis]

Wow. Thanks very much for the help! IT WORKED!