[__]

Quote:

Originally Posted by [HLF]Southclaw Thanks for the quick response! Sorry I didn't explain well, basically I just want to add a record when a player registers with basic information such as the player name and IP. And also a Primary Key as the player's ID, so this can act as a 'registered players count' also. So when the player registers, what do I format the query as and what keyword do I use? Edit: Think I figured it out! "INSERT INTO" should create a new row?

Yes. If you use the editor to create your database structure (your fields, etc.), then you can create an 'ID' field and set that as the auto-incrementing primary key. Every time you use "INSERT INTO" for that table, it will add your new row and it will set the ID to +1 from the previous row's ID field.

You can then use a SELECT query to get the highest ID to retrieve the count by the method you want:

Код:

SELECT ID from players ORDER BY ID DESC LIMIT 1

Something like the code above should work.

Alternatively, you could just use the num_rows function which calculates how many rows there are in the table. If you rely on the "ID" field, deleted accounts won't be considered and will still add to the count.

For that, you can use something like this for your query:

Код:

SELECT COUNT(*) FROM players

with this function. You don't want to use * to select everything, since you're just selecting a count of how many users there are, selecting * selects everything in your table and would frankly be a waste of memory.