[csv]

Hi all ,

i want to generate ID for asset that is based on input in different fields. When the asset is first time added to data base..
its ID is defined as...

PHP Code:

$MY_ID="const"."/".$month."/".$year."/".$class_of_asset."/"."number"; 

its o/p should look like this


MY_ID=aaa/02/08/PSB/1
MY_ID=aaa/02/08/SE/2
MY_ID=aaa/02/08/CP/3


as u can see in the $MY_ID o/p "number" every times increment
by one. so somebody give me the idea to remember the number is to
read the last entry in the asset table n read its MY_ID and separate the
last part of string which is number .so that u can increment it by one for
making a ID for asset


bt the problem is how to read the last row of database
ny command or query to slove this problem..
or Any other logic to solve this problem..


Thanks in Advance
$V

[lnunesbr]

simple man....

for example:

PHP Code:

//insert a record in data base
$qry = mysql_query("insert into db a record");

//now we get the last id inserted in db, be sure to be exactly after the insert query
$last_id = mysql_insert_id();

//defining $MY_ID variable
//$MY_ID="const"."/".$month."/".$year."/".$class_of_asset."/"."number";
$MY_ID="const"."/".$month."/".$year."/".$class_of_asset."/". $last_id; 

That's it!

[csv]

Thanks for d reply bt the problem is the command tat u hav suggested is used for auto increment operation

PHP Code:

 int mysql_insert_id  ([ resource $link_identifier  ] )



Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query. 

bt i hav not used any auto increment in my DB?

So please suggest the other way for reading the last row of table

[lnunesbr]

the best way is defining an auto increment field...

by the way, you can do something like this

PHP Code:

   //insert a record in data base
$qry = mysql_query("insert into table ");

//now we get the last id inserted in db, be sure to be exactly after the insert query
$qry_get_number = mysql_query("select max(number) from table");
list($last_id) = mysql_fetch_array($qry_get_number);

//defining $MY_ID variable
$MY_ID="const"."/".$month."/".$year."/".$class_of_asset."/". $last_id;