[RESOLVED] help with mysql query insert into

[fearfx]

ok below is this insert into code from another program.
This is my learning grounds so bare with me...

$query = sprintf("INSERT INTO `user_events` (`event_id`, `location`, `title`, `event`, `picture_1`, `picture_2`, `day`, `month`, `year`, `date`, `time`) VALUES (NULL, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');", $location, $title, $event, $picture_1, $picture_2, $day, $month, $year, $date, $time);

Now before it inserts event_id I want to insert my varialbe $id before that.

How would I modify this code accordingly?

[NogDog]

It's not clear to me what you are asking. In general, you need the column list and the values lists to have the same number of elements in the same sequence. For each "%s" in the string you need a corresponding sprintf() argument in the same sequence in relation to the other "%s" place-holders. Other than that, without further clarification I don't know what to suggest.

[fearfx]

$query = sprintf("INSERT INTO user_events ($id,event_id, location, title, event, picture_1, picture_2, day, month, year, date, time) VALUES (NULL, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');", $location, $title, $event, $picture_1, $picture_2, $day, $month, $year, $date, $time);

ok the BOLD portion of the code, I want to insert that variable $id.

I want to know how to do that.

[NogDog]

Change the NULL to another '%s' and then add $id, before $location.