PHP Columns and Rows with Pagination -
i use responsive grid framework html sites , need incorporate fetching results database populate rows/columns.
im looking 4 columns x 3 rows setting data horizontally.
<div class="row"> <div class="three columns">$row=>result</div> <div class="three columns">$row=>result</div> <div class="three columns">$row=>result</div> <div class="three columns">$row=>result</div> </div> <div class="row"> <div class="three columns">$row=>result</div> <div class="three columns">$row=>result</div> <div class="three columns">$row=>result</div> <div class="three columns">$row=>result</div> </div> <div class="row"> <div class="three columns">$row=>result</div> <div class="three columns">$row=>result</div> <div class="three columns">$row=>result</div> <div class="three columns">$row=>result</div> </div>
any clue how set counter? pagination?
<?php $n_qry = "select count(*) cnt table_name"; $n_res = mysql_query($n_qry) or die(mysql_error()); $n_row = mysql_fetch_object($n_res); $total_cnt = $n_row->cnt;?> <ul><?php for($i=1;$i<=$total_cnt;$i=i+5) { ?> <li><a href="about.html?page=<?=$i;?>"><?=$i;?></a></li> | <? } ?> </ul> if(isset($_request['page']) && $_request['page']!='') { $iqry="select * table_name id =".$id." limit ".($_request['page']).",($_request['page']+5)"; } else { $iqry="select * inner_page page_id =".$page_id." limit 0,5"; } $fiqry = mysql_query($iqry) or die(mysql_error()); $rowi = mysql_fetch_object($fiqry); echo stripslashes($rowi->field_name);
i used pagination site hope it'll work you. :)
Comments
Post a Comment