Get the results from a mysql_query insert

Question

After I insert values into a new row, I need the results from that query. mysql_query() only returns true or false when doing a INSERT command. The only solution I can think of for something like this is by creating a temporary number/id in PHP and inserting it into its own column. Then fetching that row it with a second command. However it may be possible that my random id is not random enough to accidentally select the wrong row when the script is executed multiple times.

Is there a way to execute the INSERT command on a mysql_query() call so that it returns the rows created?

What kind of data, that you are inserting, you don't know so you have to retrieve it? Apart from the id, of course. — Aurelio De Rosa
– Aurelio De Rosa, Commented May 21, 2012 at 23:44

Community · Accepted Answer · 2023-11-17 20:38:18Z

5

It sounds like you should be using AUTO_INCREMENT and mysql_insert_id(). AUTO_INCREMENT will create a unique ID for each row automatically which you can retrieve using mysql_insert_id();

edited Nov 17, 2023 at 20:38

CommunityBot

11 silver badge

answered May 21, 2012 at 23:44

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get the results from a mysql_query insert

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related