How to print more than one results in a page??
I want to print 10 results per page and show next button if it have more than 10 results..
In the next button it will show another 10 results..
How to code it..??
And please explain the code if you can...
It will my skills to generate my code..

I have a table and three fields..
id, name and info..
name is the one from witch i want to show results..
because it repeats in the data.. It repeats so many times..

Edited by kirtan_thakkar: n/a

8 Years
Discussion Span
Last Post by rajarajan2017
$query = "SELECT * FROM symbols";

// execute query 
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); 

// see if any rows were returned 
if (mysql_num_rows($result) > 0) { 
    // yes 
    // print them one after another 
    echo "<table cellpadding=10 border=1>"; 
    while($row = mysql_fetch_row($result)) { 
        echo "<tr>"; 
        echo "<td>".$row[0]."</td>"; 
        echo "<td>" . $row[1]."</td>"; 
        echo "<td>".$row[2]."</td>"; 
        echo "</tr>"; 
    echo "</table>"; 
else { 
    // no 
    // print status message 
    echo "No rows found!"; 

This is the logic to show all records, split up to 10 by implementing the logic

Edited by rajarajan2017: n/a


I know how to put 10 results but have to print the next button for the next 10 results..


in the 11th row what to link to show the next results..

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.