generating sequential numbers

[konaandcooper]

I am going to want a programmer to add sequential numbers to identify unique transactions on a software I am having modified. I s this a difficult thing to accomplish?

Forgive my ignorance.

[grandpa]

It shouldn't be difficult at all. With MySQL you can create a field in a table, I usually call this recid, defined as an integer with the auto_increment attribute set. So, one definition might look like this example:

$sql = "CREATE TABLE my_table (
recid int(11) NOT NULL auto_increment,
PRIMARY KEY (recid)
) TYPE=MyISAM;";

[konaandcooper]

Thanks a lot