SQL Query Trouble

[livethedead]

Alright when I run this query in MySQL everything goes smoothly:

INSERT INTO accounts (id, password, email) VALUES ('1022911', 'blahblah7', '[email protected]')

 

But when this runs in my script:

	$sql = "INSERT INTO accounts (id, password, email) VALUES ('
{$account_number}', '{$account_password}', '{$email}')"; 

 

the id changes from the users input, I believe because the field is set to auto-increment but, I don't understand why the query works correctly through MySQL and not my script.