I'm going out on a limb here and wanna ask a mySQL question in the hopes that there is a mySQL guru among us that can help me out.
First off heres what I'm doing. I have a director project that loads a lot of information from a mySQL database that holds the spawn information for game. Basically all the monsters in the maps are stored in a mySQL database. The application I am creating with director is used to manipulate the spawn points. I have the information being gathered, spawns being placed correctly and basically most of the project is working or close to working. The problem I am having is adding entries to the database. The table that they need to be added to has a field called spawngroupID which is NOT set up as an auto_increment. It holds int(11) data type that matches the actual spawn point to a monster type in a separate table in the database. Sorry to ramble just trying to make it clear. Finally, heres the issue I am having. Since the spawngroupID field in the database I am inserting into is not an auto_increment field, I need to come up with a way for my php script or in the mySQL query to find and grab the first available/un-used number that's free in the database. Since the spawn points can be deleted and added with the application, I want those numbers to be recycled and used again, so it needs to find and grab the first available number from the spawngroupID field in the table. Hopefully someone can help me. If not though, does anyone know of any mySQL forums where one can openly ask questions for help and such? Thanks in advance. J [To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!]
