[Resolved] Array from an insert command

spriensr

Hello

I'm trying to insert a row of data into my database.

When I insert it, I want to save it as an array like with mysql_fetch_array. So I can get the autoincrement number from mysql.

Does anyone know how to do this???

bradgrafelman

Ok, I'm thoroughly confused with what you've asked.

Once you have your INSERT query, say:

$query = "INSERT INTO MyTable ( name, data ) VALUES ( 'test1', 'my test')";

and you want the next auto increment number (assuming you have a field set as type AUTO_INCREMENT in MySQL), you simply would say:

$next_number = mysql_insert_id($mysql_connection) + 1;

[man]mysql_insert_id/man just returns the ID of the last INSERT statement.

Is this not what you wanted? If not, try to clarify your problem, posting examples of both code/desired effect if you can.

spriensr

Actually I want to do the insert and then do the

mysql_insert_id($mysql_connection) + 1;

except I don't want the plus one, so this will return the last auto_increment number from the last insert statement.

Is that correct???

bradgrafelman

Correct. The plus one would have given you the ID of the next INSERT statement. If all else fails, read the manual on the command (link posted in above post).