I've written a small registration script that registers members. When I look at the list from the database, I see that a numbers have been skipped in the primary id field... It displays something like:
1
2
3
5
6
7
13
14
I don't understand. Did I loose a few registrations or something?
No, there is no other script that can delete that because there's no code at all in the first place on my server to do that. And as per SQL Injection, I'm not aware of it
No they are not allowed to...and as far as the test accounts are concerned, I tested only on my local server and even if I tested it on the real server, I did it and then dropped the table.
It's either the result of glitchy code or SQL injection (which also implies glitchy code). Where you create user accounts, do you affect the primary key at all in the query?
Well, I usually don't touch my primary key at all... I just used it as an id because it is unique. I just keep inserting new registrations into the key. Even now, a few hours back, it skipped a number.. Could it be some problem from the host side?
.. I don't see that making sense. Somewhere, something weird is happening. If you have a central database class, start logging all of the queries that you make.
I'm a newbie so I don't go into the depths of programming yet I don't have a central database class... I'll explain the process...
Someone registers... Their entry is entered into the database and at the same time, another query is run which uses a separate library called IPBSDK, Invisions SDK for registering members. But that query is such that the registration is independent of whether that query was run or not...
... That's not something I could help debug from here. You'll really need to have some way of tracing your queries to find out which query is causing the problem.
Yeah there are some log files but then they all contain errors related to my Invision board and not my script... And yeah, there's an auto_increment for that column...