Reference Number

[fasmy98]

I'm having problem to generate the reference number for my application form.

I've read the last thread, post by SoulAssassin on easy reference number.But I still can't get it.

I would like to display the reference nyumber for each application (example : T0001,T0002...)

I do understand the function of this

mysql_query("INSERT INTO mee (product) values ('kossu')");
printf("Last inserted record has id J%04d\n", mysql_insert_id());

But how this number will be insert into DB?when the user finished the form?

$refNumber = sprintf('%s-%08d', date('Ymd'), mysql_insert_id());

how this $refNumber will be insert into the DB?

Some one please help....

[Tezread]

When creating your database structure common practice is to create an id field which has an auto_increment property e.g.

CREATE TABLE table (
table_id int(11) NOT NULL auto_increment,
title varchar(50) default NULL,
name varchar(50) default NULL,
username varchar(50) default NULL,
PHPSESSID varchar(50) default NULL,
address1 varchar(50) default NULL,
address2 varchar(50) default NULL,
last_entered timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (table_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

you can then echo the id no. as you wished