Unable to edit or delete mysql row data

Unable to edit or delete mysql row data - 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)
+--- Thread: Unable to edit or delete mysql row data (/showthread.php?tid=545789)

Unable to edit or delete mysql row data - FunnyBear - 10.11.2014

Hey,

I'm using phpmyadmin on XAMPP to save data for my server. When there is an account in the database it will show it, but I can't edit it. So I can't change the admin level/score/money etc.

Is there a way I can edit it without making a new account everytime?

Thanks

Re: Unable to edit or delete mysql row data - HazardouS - 10.11.2014

Use an UPDATE query, for example:

Код:

UPDATE players SET admin=2 WHERE name=<player's name>

Re: Unable to edit or delete mysql row data - FunnyBear - 10.11.2014

Doesn't work! Any other ideas? Also someone said something about indexes are causing the problem. Whats that's and how do I fix it?

Re: Unable to edit or delete mysql row data - Runn3R - 11.11.2014

You need to have PRIMARY and UNIQUE keys.