SA-MP Forums Archive
What's wrong with this query? - 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: What's wrong with this query? (/showthread.php?tid=389919)


What's wrong with this query? - ReneG - 04.11.2012

Код:
SELECT IP, Reason, UnbanTimestamp WHERE `Name` = 'Test' OR `IP` = '5.45.252.237' LIMIT 1


Re: What's wrong with this query? - Scenario - 04.11.2012

Maybe try "SELECT IP, Reason, AND UnbanTimestamp WHERE `Name` = 'Test' OR `IP` = '5.45.252.237' LIMIT 1"

Re: What's wrong with this query? - Bakr - 04.11.2012

FROM?

Re: What's wrong with this query? - mkr - 04.11.2012

Quote:
Originally Posted by Bakr
Посмотреть сообщение
FROM?
Yeah.

Quote:

SELECT IP, Reason, UnbanTimestamp FROM tableName WHERE `Name` = 'Test' OR `IP` = '5.45.252.237' LIMIT 1;
Obviously change "tableName" to whatever the name of your table is.