How can i make php do this?

[markster]

im making a jokes website and one of the pages is jokes.pho?cat=4 which will display all jokes with the category set as 4. the code so far is:

PHP Code:

<?php
require_once("mysql_connect.php");
$query = "SELECT * FROM jokes WHERE cat=$cat ORDER BY id DESC";
$result = mysql_query($query);
## CODE THAT DISPLAYS THE RESULTS IN A TABLE ##
?>

what im trying to make is a system that counts how many jokes in that category, and displays links that will be like:

view: 1-20, 21-40, 41-60

but it will need to auto figure out how many links it will need to produce and link them to a page like:

jokes.php?cat=4&selection=1,20

please help!

[markster]

nevermind, i think ive fixed it

[sde]

heh missed your second post and had a hack at it anyway.

here's code that would print your group links (un-tested so it may or may not work first time)

PHP Code:

<?
// get the count for a specific group
$result = mysql_query("select count(*) from jokes where cat=1");
$count = mysql_result($result,0,0);

// find the number of groups by dividing the
// result my 10 and rounding it down
$number_of_groups = floor($count/10);

// use this variable to incremenet the
// starting index. (add 10 each iteration)
$starting_group_number = 1;

// loop through groups of 10s
for ($i=1;$i<=$number_of_groups;$i++) {
  // print the link
  echo '<a href="jokes.php?star='.$starting_group_number.'">$starting_group_number . "-" . ($starting_group_number+10) . "</a>&nbsp; &nbsp;\n';
  
  // add 10 to the starting group number
  $starting_group_number += 10;
}
?>

and here is how you would handle the links

PHP Code:

<?
// clean input by stripping non-numeric characters
if (!$_GET['start') {
  $start = 1;
} else {
    $start = preg_replace("[^0-9]","",$_GET['start'];
}

// now query with the start number and get the next 10 results
$result = mysql_query("select * from jokes where cat=1 limit start, 10");

// print results with the query above
?>

[markster]

I dunno if it works, but thanks soooooo much!

[markster]

Thanks sooo much! I've sorted out your mistakes, edited it down into one script, and updated it to include 15 results per page. I've posted it below incase another user might find it useful.

PHP Code:

<?php
    require_once("mysql_connect.php");
    $result = mysql_query("SELECT count(*) FROM jokes WHERE cat=$cat");
    $count = mysql_result($result,0,0);
    $number_of_groups = ceil($count/15);
    $starting_group_number = 1;
    for ($i=1;$i<=$number_of_groups;$i++) {
      $second_num = $starting_group_number+14;
      echo("<a href=\"jokes.php?star=$starting_group_number&cat=$cat\">$starting_group_number - $second_num</a>&nbsp; &nbsp;\n");
      $starting_group_number += 15;
    }    
    echo("<br><br>");
    if (!$_GET['start']) {
      $start = 1;
    } else {
      $start = $_GET['start'];
    }
    $begnum = $start - 1;
    $query2 = "SELECT id, title, author FROM jokes WHERE cat=$cat LIMIT $begnum, 15";
    $result2 = mysql_query($query2);
    echo("<table width=\"80%\" border=\"0px\">\n");
    echo("<tr><td width=\"80%\"><b>Title<b></td><td width=\"20%\"><b>Written By</b></td></tr>");
    while ($row = mysql_fetch_array($result2, MYSQL_ASSOC)) {
        $id = $row['id'];
        $title = $row['title'];
        $author = $row['author'];
        echo("<tr><td><a href=\"joke.php?id=$id\">$title</a></td><td><a href=\"user.php?user=$author\">$author</a></td></tr>");
    }
    echo("</table>");
    ?>

[toe_cutter]

Great job, I love it when people post their solutions instead of just saying I got it to work.

-Toe