how to find a free slot in mysql? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: how to find a free slot in mysql? (/showthread.php?tid=245759)

---

how to find a free slot in mysql? - Donya - 01.04.2011

topic explains it all, i want to select a id not used by a column

say i have

Banid:

1
2
3
5
6
8

what am i looking for? a 4 or a 7, i want it to select either of them, then it will select another one after. then if no slots are free, it will select 9

---