can't get mysql_insert_id() to work

[Anon]

I've run into a snag trying to insert the correct id into another table.

What's wrong with this?

$query1 = "INSERT INTO events (id, name, location, city, state, st_date, end_date, coachid, playerid, contactid, organizerid)
VALUES ('$id', '$eventname', '$location', '$city', '$state', '$startdate', '$enddate', '$id','$id','$id','$id')";

$query2 = "INSERT INTO user (id, username, password, accessid)
			VALUES ('$id', '$coach_name', '$coach_pass', '$coach')";

$coachid = mysql_insert_id();

$query3 = "UPDATE events SET coachid = '$coachid' where id = '$id'"; 

[[deleted]]

1) you should not insert the ID if it is defined as auto_increment (what's the point in making it auto_increment if you are going to overwrite it with your own value?)

2) you have quotes around numeric values all over the place. Numbers should never be quote.

[Anon]

When you're inserting into an auto_increment field, you should insert NULL instead of an ID (so the db can assign the id).

insert into blah (id, num) values (NULL, 5)

then you can use insert_id()

[[deleted]]

You can insert a NULL, but you can also just leave the ID column out of the insert (which makes sense if you have defined the table insert it's own value)