INNER JOIN paginated

Asked Mar 27 '15 at 08:55

Active Mar 27 '15 at 09:12

Viewed 178 times

I'm working on a simple program that displays the result of an inner join query in a paginated manner.

$get_all_query_he_for_sale = "SELECT * FROM ads INNER JOIN ads_details ON ads.ads_id = ads_details.ads_id WHERE category_id = '1'";
$get_all_query_he_for_sale_execute = mysql_query($get_all_query_he_for_sale);

<div class = "container">
<?php while($row = mysql_fetch_assoc($get_all_query_he_for_sale_execute)){ ?>
    <div class = "row">
        <div class = "col-md-6">
            <?php echo $row['company_name']; ?>
        </div>
    </div>
<?php } ?>
</div>

I need some help to construct it properly.

The output should be: result will display 10 records per page.

edited Mar 27 '15 at 09:12

Beri

11,470
4
35
57

asked Mar 27 '15 at 08:55

Sam Teng Wong

2,379
5
34
56

is there a question here? – Pete Mar 27 '15 at 08:55
@Pete yes sir, I'm trying to make a paginated result in a inner join query. – Sam Teng Wong Mar 27 '15 at 08:56
Try adding LIMIT at the end of the query? – cakan Mar 27 '15 at 08:58
Your question still isn't clear. Are you asking how to use the `LIMIT` clause to select certain rows of the results? – Barmar Mar 27 '15 at 08:58
This may help http://stackoverflow.com/questions/20364349/pagination-using-mysql-limit-offset – Pete Mar 27 '15 at 08:59
@cakan what I want is a paginated... where I can show atleast 10 records per page. – Sam Teng Wong Mar 27 '15 at 09:00
In that case you must add LIMIT 0,30 for example at the end of your page and increase offset value (0) for each page. – cakan Mar 27 '15 at 09:03

INNER JOIN paginated

0 Answers0