Get information from specific row of most recently inserted database entry

Question

Apparently this...

$lastid = $wpdb->insert_id

...will give me the last inserted row (as noted here: How to get last inserted row ID from wordpress database?).

But how can I target a specific table, and get information from the latest inserted row after a form was just submitted?

For example, I have a table called 'license' and each row contains the columns 'email' and 'name' (among others).

The idea is that after I insert something into that row with a form, I need to display the email and name on screen.

Any help would be awesome.

If the get table contains an auto increment id, you could order by id desc and limit one. — chrisShick, Nov 22 '15 at 22:48
My apologies. I just realised my initial question lacked some important information. I've updated it for clarification. — User_FTW, Nov 22 '15 at 22:53
This isn't necessarily a MySQL issue. What language are you using with MySQL? — chrisShick, Nov 22 '15 at 22:55
Nevermind, I see that you are using PHP. Are you wanting to display the email and name on the same page that you submitted your form? — chrisShick, Nov 22 '15 at 23:21

score 0 · Answer 1 · answered Nov 22 '15 at 22:52

You can use the value of an auto-increment column. You might already have the ID column doing so.

In a new SELECT-statment use ORDER BY myCol DESC the auto-increment-coloumn and use LIMIT 1 to only get the one with the highest value (wich is the most recent one)

score 0 · Answer 2 · answered Nov 22 '15 at 22:56

According to what you already have you have to use the last inserted id for a new query.

$query = "select * from license where id = ".$lastid;

Using the result of this query you can print out the other information of the last inserted row.

If you need more info on the php code, provide your code so we can edit it accordingly

Ivan Veštić · Answer 3 · 2015-11-22T23:11:36.493

ID of the Last Inserted Record in general (in your example from Wordpress), can only fetch (as the name says) only the ID (AUTO_INCREMENT) from a column as a result of the most recently executed INSERT statement. mysql doc

There is no direct way if specifying "get me lastID of XYZ table" for a particular in reverse point in time, only works as described above.

Even with the proper usage in php you need to be careful if other INSERT statements on other tables (ones you don't want) are executed before you try to fetch LAST_INSERT_ID, so you don't end up getting IDs from unwanted tables.

Your possible workarounds:

do a SELECT from your desired table ordered by ID desc, e.g:
```
SELECT id FROM xyz ORDER BY id DESC LIMIT 1;
```
this is presuming id is an AUTO_INCREMENT or similar
another option is if possible in code locate the "position" of INSERT statements of the table you want e.g. xyz and fetch the id right there with:
```
$wpdb->insert_id
```

Get information from specific row of most recently inserted database entry

3 Answers3