How to view last inserted value of auto increment field

Question

In my database I have a field called spaj_per as an auto increment primary key.

How can I display the lastest inserted value in the field spaj_per. I tried this.

<?php
    $con = mysql_connect("localhost", "SuperAdmin", "***");
    if (!$con) {
        die('Could not connect: ' . mysql_error());
    }

    $db_selected = mysql_select_db("sistem_pengurusan_fail",$con);

    $q = "SELECT MAX(id) AS spaj_per FROM unit_pengambilan"; 
    $result = mysql_query($q); 
    $row = mysql_fetch_array($result); 

?>
<?php echo $row['spaj_per']; ?>

But it won't work.

duplicate http://stackoverflow.com/questions/1685860/php-how-to-get-last-inserted-id-of-a-table — Pragnesh Chauhan, Jan 29 '13 at 05:25

score 0 · Answer 1 · edited Jan 29 '13 at 05:21

0

Use PHP's mysql_insert_id() function

edited Jan 29 '13 at 05:21

Pragnesh Chauhan

8,363
9
42
53

answered Jan 29 '13 at 05:19

sjkon

633
2
10
24

score 0 · Answer 2 · answered Jan 29 '13 at 05:20

0

You may use

SELECT id FROM mytable ORDER BY id DESC LIMIT 1;

or like

$last_id = mysql_insert_id();

answered Jan 29 '13 at 05:20

GautamD31

28,552
10
64
85

score 0 · Answer 3 · answered Jan 29 '13 at 05:20

0

Try this,

$q = "SELECT MAX(spaj_per) AS spaj_per FROM unit_pengambilan"; 
$result =mysql_query($q); 
$row = mysql_fetch_row($result); 

echo $row[0];

answered Jan 29 '13 at 05:20

Edwin Alex

5,118
4
28
50

score 0 · Answer 4 · edited Jan 29 '13 at 05:23

0

Try with mysql_insert_id

For more reference use following link
http://php.net/manual/en/function.mysql-insert-id.php

edited Jan 29 '13 at 05:23

Pragnesh Chauhan

8,363
9
42
53

answered Jan 29 '13 at 05:20

vivek salve

991
1
9
20

score 0 · Answer 5 · answered Jan 29 '13 at 05:22

0

Try the following

<?
$q = "SELECT MAX(spaj_per) AS last_spaj_per FROM unit_pengambilan"; 
$result =mysql_query($q); 
$row = mysql_fetch_array($result); 

 echo $row['last_spaj_per']; 
?>

answered Jan 29 '13 at 05:22

Vamsi

873
1
8
16

score 0 · Answer 6 · answered Jan 29 '13 at 05:22

0

$row = mysql_fetch_array($result); Change to $row = mysql_fetch_assoc($result); and try

answered Jan 29 '13 at 05:22

Prasanth Bendra

31,145
9
53
73

How to view last inserted value of auto increment field

6 Answers6