php/mysql media site help

$page = $_GET['page'];
$number = 20 * $page; //number of items you want times page
$number2 = 20 * ($page - 1); //this gives us the number to start from

$list = mysql_query("SELECT * FROM myTable LIMIT '$number2', '$number'");

etc...

$host = ""; //your database host
$user = ""; // your database user name
$pass = ""; // your database password
$db = ""; // your database name

$filename = ""; // name of this file
$option = array (10, 25, 50, 100, 200);
$default = 100; // default number of records per page
$action = $_SERVER['PHP_SELF']; // if this doesn't work, enter the filename
$query = "Select * FROM foo order by id DESC"; // database query. Enter your query here
// end config---------------------------------
$opt_cnt = count ($option);
$go = $_GET['go'];
// paranoid
if ($go == "") {
$go = $default;
}
elseif (!in_array ($go, $option)) {
$go = $default;
}
elseif (!is_numeric ($go)) {
$go = $default;
}
$nol = $go;
$limit = "0, $nol";
$count = 1;
$connection = mysql_connect ($host, $user, $pass) or die ("Unable to connect");
mysql_select_db ($db) or die ("Unable to select database $db");
// control query------------------------------
/* this query checks how many records you have in your table.
I created this query so we could be able to check if user is
trying to append number larger than the number of records
to the query string.*/
$off_sql = mysql_query ("$query") or die ("Error in query: $off_sql".mysql_error());
$off_pag = ceil (mysql_num_rows($off_sql) / $nol);
//--------------------------------------------
echo "<form name=\"form1\" id=\"form1\" method=\"get\" action=\"$action\">\r\n";
echo "<select name=\"go\" id=\"go\">\r\n";
for ($i = 0; $i <= $opt_cnt; $i ++) {
if ($option[$i] == $go) {
echo "<option value=\"".$option[$i]."\" selected=\"selected\">".$option[$i]."</option>\r\n";
} else {
echo "<option value=\"".$option[$i]."\">".$option[$i]."</option>\r\n";
}
}
echo "</select>\r\n";
echo "<input type=\"submit\" name=\"Submit\" id=\"Submit\" value=\"Go\" />\r\n";
echo '<br />';
echo '<br />';
$off = $_GET['offset'];
//paranoid
if (get_magic_quotes_gpc() == 0) {
$off = addslashes ($off);
}
if (!is_numeric ($off)) {
$off = 1;
}
// this checks if user is trying to put something stupid in query string
if ($off > $off_pag) {
$off = 1;
}
if ($off == "1") {
$limit = "0, $nol";
}
elseif ($off <> "") {
for ($i = 0; $i <= ($off - 1) * $nol; $i ++) {
$limit = "$i, $nol";
$count = $i + 1;
}
}
echo "<br />";
echo "\r\n";
for ($i = 1; $i <= $off_pag; $i ++) {
if ($i == $off) {
echo "<span class=\"offsetActive\">$i</span> \r\n";
} else {
echo "<span class=\"offset\"><a href=\"$filename?offset=$i&go=$go\">$i</a></span> \r\n";
}
}
echo "<br />\r\n";
echo '<br />';
if ($off <> 1) {
$prev = $off - 1;
echo "< <a href=\"$filename?offset=$prev&go=$go\">prev</a>   || \r\n";
}
echo "Page $off of $off_pag \r\n";
if ($off < $off_pag) {
$next = $off + 1;
echo "||   <a href=\"$filename?offset=$next&go=$go\">next</a> > \r\n";
}