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

• What is the most adequate database technology for Google Sheets?Hello everybody! Adrian from Romania. Thanks for reading this. We use Google Sheets to keep track
• MySQL CONCAT, HAVING and JOINhi can this be use all together? here is my query: SELECT CONCAT(fullname," ",address1," ",city,"
• Unable to start PhpMyAdmin via XAMPPI'm in the midst of creating a social network and I'm at the key, most crucial, part of it all. A d
• Error While Connect MySQL DAtabaseHi guys i want to ask you about connect mysql database from different hosting servers using php. an
• insert foreign keys with triggerHello. I got the following tables : CREATE TABLE A ( id_a INT AUTO_INCREMENT PRIMARY KEY, name_a V
• Selecting Current Date Datahi, im not sure if this is a simple question but it makes me wonder. i have a field on my database