SA-MP Forums Archive
How to scan through the MySQL database for a specific variable? - 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: How to scan through the MySQL database for a specific variable? (/showthread.php?tid=477157)



How to scan through the MySQL database for a specific variable? - Brandon_More - 22.11.2013

As the title says..

Example:

If I wanted to scan through the MySQL for like a list of all Admins.. offline & Online.

How would I be able to make such a command?

Yeah, I am pretty new to Pawno.


Re: How to scan through the MySQL database for a specific variable? - Patrick - 22.11.2013

Quote:
Originally Posted by Brandon_More
Посмотреть сообщение
As the title says..

Example:

If I wanted to scan through the MySQL for like a list of all Admins.. offline & Online.

How would I be able to make such a command?

Yeah, I am pretty new to Pawno.
Tell us what MySQL version you are using.


Re: How to scan through the MySQL database for a specific variable? - Brandon_More - 22.11.2013

BlueG r6


Re: How to scan through the MySQL database for a specific variable? - Konstantinos - 22.11.2013

An example:
pawn Код:
"SELECT username, admin FROM users WHERE admin > 0"
It selects the name and the admin level from those whose admin level is greater than 0.