MySQL before how to draw on any article 50 of the 1000 pieces of information-CodePudding

This was the empire CMS, I want to obtain a certain section of the latest article 50 of 1000 messages, is randomly call problem, this is a random question,
I have here he smart tags call as an example, this is called the current column information, sort of, according to hits the onclick that suppose I also press hits to sort, before any article 50 of the 1000 article, that how to write my code, thank you
[e: loop={" select * from phome_ecms_news where every '". $GLOBALS [navclassid]. "' order by onclick desc limit 5 ", 6,24,0}]

<?=$BQR [' title ']?>

[/e: loop]

CodePudding user response:

First randomly 50 positive integers less than 1000,
And then take corresponding data as a serial number,
Such a simple question, don't ask

CodePudding user response:

The SELECT FLOOR (RAND () * 1000);

It is said that this is a mysql method to obtain positive integer less than 1000 inside

CodePudding user response:

The order by UUID ()

CodePudding user response:

Take the latest data of article 1000 of the first, and then from the inside before 50, sorting is based on UUID ()

CodePudding user response:

The ORDER BY the rand () LIMIT of 10