[SOLVED] Help inserting data into MySQL

[ncorrieri]

hey all - im trying to go back and repair some old code, and i dont know what im doing

 

This should be able to connect to database fine, however, it is not inserting.

 

Posting data to this page. What do you think is wrong with this page?

 

 

-------------

<?
require_once("config.php");


$data = $_POST;
$data['dob'] = "$data[dobYYYY]-$data[dobMM]-$data[dobDD]";
$t = "registration";
$q = "INSERT INTO $t (`id`,`prefix`,`suffix`,`fname`,`lname`,`gender`,`dob`,
	`address1`,`address2`,`city`,`state`,`email`,`areacode`,
	`regtime`,`ipaddress`,`offer`,`affiliate`,`subaffiliate`)
	VALUE (	null,[prefix],[suffix],[fname],[lname],[gender],[dob],
	[address1],[address2],[city],[state],[email],
	[areacode],NOW(),[ipaddress],[offer],[affiliate],[subaffiliate])";
foreach ($data as $key => $value)
{
	$value = "'".mysql_real_escape_string($value)."'";
	$q = str_replace("[$key]",$value,$q );	
}				

mysql_query($q);
?>

[Balmung-San]

Replace mysql_query($q) with mysql_query($q) or die (mysql_error());

 

That will give us a better description of what's wrong.

[ncorrieri]

did that, got this error.

 

 

You have an error in your SQL syntax near 'VALUE ( null,'298','3920','James','McDoodle','M','1980-12-1', '101 1st Street' at line 4

 

following value would have been address2 but it was blank

 

[Balmung-San]

*hits head*

 

Change:

 

VALUE

 

To:

 

VALUES

[ncorrieri]

that worked! thanks!

 

now i just need to figure out whats wrong with this reporting page (ill make another thread hehe)