Q:

Serial number in PHP

Please I am building a table in php that will list item from database, the amount listed depends on amount available. I want to number my s/n column serially using php.
eg.
s/n      Name       amount
1       Mathew     $12
2
3
4
etc

A:

Try MYSQL's auto increment. So the first user who registers gets SN 1 and second would get 2 etc
http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html

