Problem with results paging in the browser

[sansan]

Hi guys, please i need little help with how to divide my results that came out from the database on pages. I mean like:

First ... page1 page2 page3 ...... Last

Lets say that my query is something like:

$query=mysql_query(SELECT * FROM mydb LIMIT 0,10);

The best thing I thought of is to set a variable like:
$count=10

then I add the variable value to the start record value in the query or subtract it (depending on the user action with the submit buttons 'next' and 'previous').

This is my idea about this, but i didn't start to apply it yet, thinking that there must be something more easier and proficient.

Please, any thoughts??
Thanks in advance

[halojoy]

Hi.

couple of things before you start making the php code

1. question: why call ONE TABLE for mydb
   A database is a collection of many tables.
   It is good practice to use variable names that do not confuse.
   It may confuse you if you look at it 5 years from now.
   And confuse me right away now, as I do not know much of your stuff.
   If your TABLE deals with pages, then call it something like this.
   Same with columns, fields.
   We do not call the column for TIME name and not column for PASSWORD for houses

2. "SELECT * FROM tablename LIMIT 0,10"
   Even if you expect 10 result rows, at at least one point in time there are:

3. no rows

4. 1 rows

5. 5 rows
   So, in your script, do not assume 10 rows.

This have a better idea.
But still only some basic idea. It does not answer your question.
Just something to start with 🙂

<?php

//get 10 pages from table: 'mypages'
$sql     = "SELECT * FROM mypages LIMIT 0,10"; 

$result = mysql_query( $sql ); //execute and save result in $result

//examine and use the result
$num_pages = mysql_num_rows($result); //how many rows were found, normally 10

echo '<pre>'; // display trick for: print_r(  )
for($i=1; $i<=$num_pages; $i++){

// fetch each row, each 'page' data from the $result
$row = mysql_fetch_array($result);

print_r($row); // see all what is in each $row array

}

?>

[sansan]

Dear halojoy
Thank you for your reply
My code aims to bring articles from the database depending on the class (sport, politics, community...).
After inserting too many articles the list goes very long. So, i want to divide it to pages, 10 records per page for instance. (I think I've expressed this in a wrong way in my previous post)

My database contains the columns: id, class, address, text, view, date

The exact code i have is something like the following:

include 'config/config.php';//defines user, password and DB
include 'config/connection.php';//contains $connect and $dbselect. It estableshes connection and selects the database

if (!$connect || !$db_select){
	echo("<center>Sorry, Internal error has occured. We will fix it soon!</center>");
	exit;
}

$result_query=mysql_query("SELECT * FROM articles WHERE class='sport' and view='show' ORDER BY date DESC");

if (mysql_num_rows($result_query) == 0) {
    echo "<center>Sorry, there are no articles in this section yet.</center>";
    exit;
}

while($result=mysql_fetch_array($result_query)){
	echo ("<a href='showarticle.php?id=$result[id]'>$result[address]</a><br/>");
}
mysql_free_result($result_query);
?>

I'll start with the idea you've mentioned. I hope it will be helpful to me.
I appreciate any extra advices you could offer
Thanks alot.