I'm currently working on a school project where I need to create a helpdesk website. I have a users table with an auto-incremented ID for each user, but I also want to add a client number that would also auto-increment. I'm using phpMyAdmin with MariaDB. I've looked into some AI suggestions already, but I'd really prefer insights from someone with real-world experience.
3 Answers
I was thinking of the same thing! Using the auto-generated ID for queries keeps it simple. But I get that a unique client number could enhance the user experience too. Maybe just have the client number for identification and keep the ID for backend operations?
Why not just use the table's auto-incremented ID as the client number, but format it to a 10-digit number? That could make things easier.
Are you treating clients and users as separate entities? It sounds like they could be, and that might simplify things for you.
Related Questions
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically