[Tim]

Hello,

I have a Licence and Extractor.
How to display not Newest Comments, but Random 5 comments at sidebar of my website?

At extractor, I have changed this:


public function newestComments()
{
$html = '';

$comments = mysqli_query($this->getLink(), "SELECT `id` FROM `" . CMTX_DB_PREFIX . "comments` WHERE `is_approved` = '1' ORDER BY `date_added` DESC LIMIT 8");


to:

public function randomComments()
{
$html = '';

$comments = mysqli_query($this->getLink(), "SELECT `id` FROM `" . CMTX_DB_PREFIX . "comments` WHERE `is_approved` = '1' ORDER BY `date_added` DESC LIMIT 5");


However, I stiil got problems:
Fatal error: Cannot redeclare extractor:: substr() in /home/var/...domain/ets/
Fatal error: Cannot redeclare extractor:: shortenComment() in /home


At example file I have changed:

<?php $cmtx_folder = '/main/'; require_once $_SERVER['DOCUMENT_ROOT'] . '/main/extractor.php'; $extractor = new extractor($cmtx_folder); if ($extractor->isConnected()) {echo $extractor->randomComments();}?>

Please help Steven!

[Steven]

According to the error you've duplicated the substr() and shortenComment() methods. In other words you have two substr() methods and two shortenComment() methods in the file. There should only be one of each method, so just remove the duplicates.

Then in your randomComments() method, you would just need to change:

Code:

ORDER BY `date_added` DESC

to

Code:

ORDER BY RAND()

[Tim]

Thank you much, for help!