SQLite minor help - Printable Version

SQLite minor help - 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: SQLite minor help (/showthread.php?tid=609962)

SQLite minor help - xTURBOx - 18.06.2016

I new to SQLite (SQL) started learning 3-4 days ago.
anyways, my question how to retrieve all the player's names from a specific IP
For example
i have this in the database
http://prntscr.com/bhvwe9

and i want to retrieve all the names of the players from the ip "127.0.0.1"

thanks in advance
regards,
turbo

Re: SQLite minor help - ToiletDuck - 18.06.2016

Код:

 SELECT `PlayerName` FROM `Users` WHERE `Player IP` = '127.0.0.1'

Код:

 SELECT `column1` FROM `tablename` WHERE `column2` = 'field'

correct me if im wrong

Re: SQLite minor help - GTLS - 18.06.2016

I am sorry i dont know much about Sqlite but normal query would be like

PHP код:



SELECT 'Username' from Users WHERE IP = '127.0.0.1'

PS: ToiletDuck faster then me xD