Random резултати

[Vladislaw]

Здравейте, имам следния код:

<?php
     if (isset($_GET['pageno'])) {
            $pageno = $_GET['pageno'];
        } else {
            $pageno = 1;
        }
        $no_of_records_per_page = 6;
        $offset = ($pageno-1) * $no_of_records_per_page;


        $total_pages_sql = "SELECT COUNT(*) FROM tblposts";
        $result = mysqli_query($con,$total_pages_sql);
        $total_rows = mysqli_fetch_array($result)[0];
        $total_pages = ceil($total_rows / $no_of_records_per_page);


$query=mysqli_query($con,"select tblposts.id as pid,tblposts.PostTitle as posttitle,tblposts.VideoTime as vtime,tblposts.PostImage,tblcategory.CategoryName as category,tblcategory.id as cid,tblsubcategory.Subcategory as subcategory,tblposts.PostDetails as postdetails,tblposts.PostingDate as postingdate,tblposts.PostUrl as url from tblposts left join tblcategory on tblcategory.id=tblposts.CategoryId left join  tblsubcategory on  tblsubcategory.SubCategoryId=tblposts.SubCategoryId where tblposts.Is_Active=1 order by tblposts.id desc  LIMIT $offset, $no_of_records_per_page");
while ($row=mysqli_fetch_array($query)) {
?>

как може да се направи да изкарва Random постове, а не последно добавени?
Благодаря!

Предполагам, че е от този код:
Is_Active=1 order by tblposts.id desc

 

[uphero]

Първо си форматирай заявката

SELECT    tblposts.id        AS pid,
          tblposts.posttitle AS posttitle,
          tblposts.videotime AS vtime,
          tblposts.postimage,
          tblcategory.categoryname   AS category,
          tblcategory.id             AS cid,
          tblsubcategory.subcategory AS subcategory,
          tblposts.postdetails       AS postdetails,
          tblposts.postingdate       AS postingdate,
          tblposts.posturl           AS url
FROM      tblposts
LEFT JOIN tblcategory
ON        tblcategory.id=tblposts.categoryid
LEFT JOIN tblsubcategory
ON        tblsubcategory.subcategoryid=tblposts.subcategoryid
WHERE     tblposts.is_active=1
ORDER BY  tblposts.id DESC limit

после виж за RAND()