CODE 1 and CODE 2

[Bickey]

I just did a simple modification to this code and it doesn't seem to work now.

CODE 1 works but CODE 2 doesn't. Could someone help me fix CODE 2.

 

CODE 1

mysql_query("INSERT INTO tbl (username, password, surname, firstname, nickname, company, street, suburb, postal, phone, email, product, status, id) VALUES ('$username', '$password', '$surname', '$firstname', '$nickname', '$company', '$street', '$suburb', '$postal', '$phone', '$email', '$product', '$status', '$id')");

 

CODE 2

$go =sprintf("INSERT INTO tbl (username, password, surname, firstname, nickname, company, street, suburb, postal, phone, email, product, status, id) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s'", mysql_real_escape_string($username), mysql_real_escape_string($password), mysql_real_escape_string($surname), mysql_real_escape_string($firstname), mysql_real_escape_string($nickname), mysql_real_escape_string($company), mysql_real_escape_string($streetx), mysql_real_escape_string($suburb), mysql_real_escape_string($postal), mysql_real_escape_string($phone), mysql_real_escape_string($email), mysql_real_escape_string($product), mysql_real_escape_string($status), mysql_real_escape_string($id));
$result = mysql_query($go);

 

[denno020]

Is it supposed to be streetx in CODE 2??

 

Denno

[Bickey]

Yep!!! that did it! Thanks!

 

Bickey.