no I meant between House and Rent or House and Store
if it was stored in db like:
id | item |
0 | House Rent |
1 | House Sell |
you could
$query = "select * from house";
$result = mysql_query($query, $mysql_link); //where mysql_link = connection
$increm = "001";
while($row = mysql_fetch_row($result))
{
$number = explode(" ", $row[1]);
$one_number = chop($number[0]);
$two_number = chop($number[1]);
$number = "$one_number$two_number"; //This will give you your HR and HS
$increm = (($increm*1)+1); // This would be because I don't know that you can ++ a 001 number and retain 00 value;
}
Try this.
