I need for my game inventory function a mysql query which checks the next available free slot id.
I have item on slot 1, 2, 3 and 5.
Slot 4,6,7,8,9 ... are free..
Now I need query which would get the number 4.
SELECT * FROM inventory WHERE slot >= 1 AND slot <= 10;
But this doesnt really get the first available slot number.
Any expert knows how to do it?