About BlitzPlus and MySQL

Blitz3D Forums/Blitz3D Beginners Area/About BlitzPlus and MySQL

Oh, sorry, I made a mistake, go back to

"so this would be the blitz call", I just correct it...

Make shure to read eversthing I said here. Most of it is important.

Ok, here are some more basic MySQL Queries:

DELETE FROM
    gamewin
WHERE
    player_name='jfk';


This would delete all entries where the player nick was "jfk". Of course you can also use other criteria after WHERE.

The next Query is used to edit something in a Table:
UPDATE
    gamewin
SET
    player_score = '0',
    player_kills = '0'
WHERE
    player_name = 'jfk';


This would set my score and frags to Zero which would be pretty mean! ;)

Make shure to use the correct Commas and Semicolons.