Limit results of table output by using ?limit=10

[Chendyboi]

I am trying to limit my table results to 10 when my url is /table.php?limit=10

 

the code that i am using is as follows:

 

    if(!isset($_GET['limit']) && $_GET['limit'] == '10') {
    $fetch = mysql_query("SELECT * FROM (table name) LIMIT 0, 10")or
    die(mysql_error());
    }

 

Could someone help me on where i am going wrong.

[Jessica]

Your code says:

If the limit is not set, and the limit is equal to 10 (a condition that can never happen),

then fetch ten rows.

 

Your code SHOULD SAY:

if the limit is set

cast the limit to an integer, then fetch that many rows.

[Chendyboi]

How would i go about doing that?

 

Could you put it into code context or a link to a site that explains it?

[davidannis]

What Jessica said is do something like this:

//Note: removed ! in the line below
    if(isset($_GET['limit'])) {
   $num_rows=intval($_GET['limit'] ) ; //cast to an integer - makes it work for any number of rows
    $fetch = mysql_query("SELECT * FROM (table name) LIMIT 0, $num_rows")or
    die(mysql_error());
    }

also needed to remove the test for if limit was 10

Edited June 3, 2013 by davidannis

[Chendyboi]

Freak Dr. this is still not working

[mikosiko]

Post the code that you have and explain clearly what means "still not working"

[davidannis]

mikosiko is right. You need to post code. Without seeing any code my best guesses are that you need an actual table name where you have (table name) in your select, you don't have a valid connection to the database, or you are not retrieving and displaying the results after the mysql_query.