how to autoincrement a string value fetch from mysql

Question

I have a field outlet_id having values like this:

AA1
AA2
AA3
AA4

It's not mysql auto incrementing field. I have to fetch the last value inserted into the outlet_id and increment it like AA5,AA6,AA7 ...

What I have done so far is:

$sql_outlet_id=mysql_query("SELECT MAX(outlet_id) FROM outlets");
$val = mysql_fetch_row($sql_outlet_id);
$new_array = explode('AA',$val[0]);

echo $outlet_id=$new_array[1]+1;

Output always shows 10 even if last inserted id is AA20 or AA21 or so on.

Sougata Bose · Accepted Answer · 2015-11-25 13:50:45Z

2

Try with -

$val = 'AA4';

$temp= str_replace('AA', '', $val);

$new = 'AA' . ($temp + 1);

echo $new;

Output

AA5

answered Nov 25, 2015 at 13:50

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

3 Comments

priyabrata Over a year ago

how to fetch the last value from database like AA4 @sougata

Sougata Bose Over a year ago

Is there any field that is auto incremented? like id, date or something like this?

priyabrata Over a year ago

ya i got it id is auto incremented.

Collectives™ on Stack Overflow

how to autoincrement a string value fetch from mysql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related