Why does my SQL query fail?

I'm using this to retrieve information from a database, the query always brings errors

This is my query:

SELECT * FROM users ORDER BY RAND() LIMIT '10'

It alw开发者_运维技巧ays brings up errors on either the ORDER BY RAND() or the LIMIT '10'.

Any reason why this is happening? Also is there any solutions to this?

---

Limit should be integer? 10 instead '10'.

---

SELECT *
FROM affiliate
ORDER BY RAND()
LIMIT 10 

Note there are no quotes around 10

---

The LIMIT parameter is a number, not a string:

SELECT * FROM users ORDER BY RAND() LIMIT 10

Whitout the quotes.