Displaying Random Comments

Viewing 2 replies - 1 through 2 (of 2 total)
  • essaysnark

    (@essaysnark)

    13 years ago

    @mikeweeks I know your question is really old but we hacked a solution to this. In wp-customer-reviews.php, on line 420, replace part of the FROM line like so:

    ORDER BY date_time DESC $limit

    to

    ORDER BY RAND(UNIX_TIMESTAMP(NOW())) $limit

    There’s backticks in the original bit around date_time. Ditch those, none needed in the replacement (keep the first part of the line with FROM obviously – I couldn’t copy in the whole thing here due to the backticks).

    essaysnark

    (@essaysnark)

    13 years ago

    Doh. Just realized that you were posting a SOLUTION not a question. Wish I’d found yours earlier!!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Displaying Random Comments’ is closed to new replies.