I want to show some mysql results in two different areas...

I thought I would do two queries, and show a certain few (1-5) or whatever on one area, and the rest on another, however I need them split even....

how can I do this?

I thought about doing something like......

if (is_float($counter/2)) $area = "area1"; 
else $area = "area2";

but I don't know. Could I somehow check the amount of rows in a table, split that in half, and show the first half in one area and the rest elsewhere?

7 Years
Discussion Span
Last Post by zein1212

If you want to count the number of records in the table, you can use mysql_num_rows.

$query = "select * from tablename";
$result = mysql_query($query);
echo mysql_num_rows($result)." records found...";

If you want the number of columns in a particular table,

$query = "show columns from tablename";
$result = mysql_query($query);
echo mysql_num_rows($result)." columns ...";

As in the above example, once you find out the total rows, you can split it into 2 (or put it in 2 separate arrays and use it wherever you want!).


How about this

    $connection = mysql_connect("localhost","root","");
    $page = 0;
        $page = $_GET['page'];
        $page = 1;

    $limit = 2;
    $offset = ($page - 1)*$limit;
    $result = mysql_query("select * from table_name limit $offset,$limit;");    
    $get_total = mysql_query("select count(*) as total from table_name ");
    $total_table_name = 0;
    while($h_total = mysql_fetch_array($get_total)){
        $total_table_name = $h_total['total'];
    $total_page = ceil($total_table_name/$limit);
<div >

        <?php while($data = mysql_fetch_array($result)){ ?>

           <h2><a href="index.php?page=<?php echo $data["table_row"]; ?>" style="text-decoration:none;">
           <?php echo $data["row_to_show"]; ?></a></h2>            

        <?php } ?>  

            <?php if($page > 1){ ?>
            <a href="<?php echo $_SERVER['PHP_SELF']; ?>?page=<?php echo ($page-1); ?>">&lt;&lt;&nbsp;&nbsp;Prev</a>
                }if($page < $total_page){

            <a href="<?php echo $_SERVER['PHP_SELF']; ?>?page=<?php echo ($page+1); ?>">Next&nbsp;&nbsp;&gt;&gt;</a>
            <?php } ?>

        <?php mysql_close($koneksi); ?>

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.