mysql query problem

Hello,

I'm getting a syntax error in this query line.

SELECT `title`, `link`, `image` FROM `advertisements` WHERE `live` = \'yes\' RAND()<(SELECT ((1/COUNT(*))*10) FROM `advertisements`) ORDER BY RAND() LIMIT 4;

Code (markup):

The syntax error is 'You have a syntax error new RAND.'

Not sure if there should be an AND in there, or something else. It's selected 4 random rows.

Thanks,
Jeremy.

from Databases http://ift.tt/20PMWvF
via IFTTT

Share :

Tweet

✚

Related Post