Help with an insert query

[SteveFrost]

Hi,

How can I make the following insert query into php with variables instead of the values in there now?

INSERT INTO `sjfrost_test14`.`home` (
`ID` ,
`Title` ,
`Date` ,
`Body` ,
`Link 1` ,
`Link 2` ,
`Link 3`
)
VALUES (
NULL , 'Title', '2009-08-13 13:29:23', 'Main Content', 'Link', 'Link2', 'Link3'
);

Thanks in advance,

Steve

[johanafm]

$title = mysql_real_escape_string('Title');
$date = mysql_real_escape_string('2009-08-13 13:29:23');

// ...
VALUES (
NULL , $title, $date, 'Main Content', 'Link', 'Link2', 'Link3'
);

And since you provide NULL as value for the id field, you can drop id/null from the query alltogether assuming it's an AUTO_INCREMENT field.