Hi, I am working on a Inventory management system. No I would like to have a custom bill no, which will be changed on each month, i.e. the first bill of March, 2011 will have a no like "Mar/2011/01", the next will be "Mar/2011/02" and so on, until it is March, 2011. On April 2011 it will start again from one, as "Apr/2011/01"..... and so on. I am using Mysql & PHP for the project. How to achieve this???
anirban1087
0
Junior Poster in Training
Recommended Answers
Jump to PostIf you have a timestamp column in your table, then you can do the following, just before your insert (or as part of your insert query, or as an insert trigger):
SELECT CONCAT( DATE_FORMAT(NOW(), '%b/%Y/'), ( SELECT 1 + COUNT(*) FROM bills WHERE YEAR(`timestamp`) = YEAR(NOW()) AND …
All 3 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
smantscheff
265
Veteran Poster
anirban1087
0
Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.