How To select last inserted Row in PHP , Mysql

Question

I m trying to create ID like "A1 , A2, A3 .. etc So i tried like this

$q = mysql_query("SELECT merge_id FROM merge_info ORDER BY merge_id DESC LIMIT 1;");
$s = mysql_fetch_array($q);
$merge_id5 = $s['merge_id'];
$count2=mysql_num_rows($q);
if($count2>0)
{
    $merge_id5 = explode("A",$merge_id5);   
    $mergeid_no = $merge_id5[1]+1;  
    $merge_id6 = $mergeid_no;
}
else
{
    $merge_id6 ="1";
}
if($count<1)
{
    $merge_id = $merge_id5;
}

Everything is working fine... but after creating A9, it create A10 then again it creates A10 not moving to A11 , A12 . etc., i think if i write correct query to fetch last inserted row i'll fix this issue

Please someone help me

db table :

merge_id  |  name |
      A1  |  xxxx |
      A2  |  yyyy |
      A3  |  zzzz |
        ....
        ....
      A9  |   sds |
      A10 |  dsfs |

@wrecklez yes the merge id should be like this and i dont have to add autoincrement id like 1,2,3,4,.etc :( without using auto increment i have to do this — user3419304
– user3419304, Commented Jun 30, 2014 at 7:15
try my posted solution, i know it is not the best solution but it will help you to solve your problem — wrecklez
– wrecklez, Commented Jun 30, 2014 at 7:52

wrecklez · Accepted Answer · 2014-06-30 08:12:34Z

1

i know it is not the best solution to your problem, but this will help you. and just get the first record because if i add LIMIT 1 the output is wrong :(

SELECT * FROM merge_info ORDER BY LENGTH(merge_id) DESC

edited Jun 30, 2014 at 8:12

answered Jun 30, 2014 at 7:48

wrecklez

3472 silver badges4 bronze badges

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

3 Comments

user3419304 Over a year ago

it returns A10 but after inserting A11 again it returns A10 not moving to next "A11'

wrecklez Over a year ago

@user3419304 try it now, just get the first record

wrecklez Over a year ago

@user3419304 just remove the limit, then get only the first record in your PHP atleast we found out what is the latest record :) hope it will help, if i got a new and a better solution i will let you know!

Ankit Bajpai · Accepted Answer · 2014-06-30 06:53:50Z

0

Change your query to:-

SELECT MAX(merge_id) FROM merge_info;

answered Jun 30, 2014 at 6:53

Ankit Bajpai

13.6k4 gold badges27 silver badges43 bronze badges

3 Comments

user3419304 Over a year ago

it returns A9 , but i want A10

Ankit Bajpai Over a year ago

change explode to implode. This maght be your solution.

user3419304 Over a year ago

i think there is no need to change any part of coding..! after A9 the the A10 stores after A1 ( A1,A10,A2,A3,A4,A5,A6,A7,A8,A9) so i need to order the table as 1,2,3,4..9,10 then select last row. i dont know how to do that, someone help to solve this issue

lopo · Accepted Answer · 2014-06-30 07:54:05Z

0

I think it's better you use an auto_increment field, to get the last insert row with LAST_INSERT_ID(), otherwise you can't be sure if the last row, the one you have inserted.

So long. To order with your solution, use this.

ORDER BY SUBSTRING(merge_id,2) DESC

edited Jun 30, 2014 at 7:54

answered Jun 30, 2014 at 7:35

lopo

3061 silver badge5 bronze badges

2 Comments

user3419304 Over a year ago

SELECT merge_id FROM merge_info ORDER BY SUBSTRING( merge_id, 2 ) LIMIT 1 this query returns A1

lopo Over a year ago

Use DESC for ORDER, ASC is default

v2solutions.com · Accepted Answer · 2014-06-30 08:05:35Z

0

Better approach to your problem could be , use AUTO_INCREMENT field and while displaying append 'A' to it.

Now to solve this you can use below SQL statement

SELECT * FROM `merge_info` ORDER BY SUBSTRING(merge_id,2) DESC limit 1

answered Jun 30, 2014 at 8:05

v2solutions.com

1,4399 silver badges8 bronze badges

Comments

Ashok sri · Accepted Answer · 2014-06-30 08:10:32Z

0

should change you merge_id column into auto increment column,and the change your query into below mentioned,

SELECT MAX(merge_id) FROM merge_info;

if you want id like A1,A2,A3 ... then you can use the below code for get it

 $q = mysql_query("SELECT merge_id FROM merge_info ORDER BY merge_id DESC LIMIT 1;");
                                         $s = mysql_fetch_array($q);
                                         $merge_id5 = $s['merge_id'];
                                         $count2=mysql_num_rows($q);

                    $merge_id="A".$merge_id5;

after above process,noe we have a meger_id like A1,A2.. on application side

answered Jun 30, 2014 at 8:10

Ashok sri

737 bronze badges

1 Comment

user3419304 Over a year ago

Without autoincrement have to do this stuff !! if autoincrement has i do easily !!

Collectives™ on Stack Overflow

How To select last inserted Row in PHP , Mysql

5 Answers 5

3 Comments

3 Comments

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

3 Comments

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related