Ok so i am writing a quick little web app to keep track of our ips we have for our server network. When i click the button to request a new ip i want it to find the next free ip in the list. Now i have not created any tables yet.
1. Not sure how ot right that query
2. Not sure of what my table structure should be like.
The data i would like to collect would be the following1 What is the ip for This would be dropdwon list example Server,Switch,router
2. device name - User input
and so on
I guess what i need help on is writing a query on how to find the next aviable ip. Now if let say i decomision a server that ip beccomes aviable again it should find that in the list as a next aviable ip.
View Complete Post