A few things:
Please wrap your php code in [ php ] [ /php ] tags. It makes the code much easier to read.
This line does nothing:
$eu = ($start - 0);
This is what's giving you the SQL syntax error
$query = mysql_query("select * from `pitchers04` LIMIT $eu, $limit " );
$result=mysql_query($query);
Should be this:
$query = "select * from `pitchers04` LIMIT $eu, $limit ";
$result=mysql_query($query);
Here's how I'd do it:
if(!isset($page)) { // variable is set to zero for the first page
$page = 0;
}
$perpage = 25; // how many results to display per page
$start = $perpage * $page;
$limit = "LIMIT $start, $perpage";
// first, find out how many we have and how many pages that will be
$numberquery = "SELECT * FROM pitchers03";
$numberresult = mysql_query($numberquery);
$pages = ceil(mysql_num_rows($numberresult) / $perpage);
// now our main query, limited to a single page
$query = "select * FROM pitchers03 ORDER BY something $limit";
$result = mysql_query($query);
// now build a little dropdown form for our page selection
?>
<form method=post action="">
Page: <select name="page" onchange="this.form.submit()">
<?
for ($j=0; $j<$pages; $j++) {
$x = $j+1;
echo "<option value=\"$j\"";
if ($j == $page) echo " SELECTED";
echo ">$x</option>\n";
}
?>
</select> of <? echo $pages ?>
</form>
<table align='center' border=1>
<?
// display our table row header (not shown)
// now iterate through our results
while ($row = mysql_fetch_assoc($result)) {
// display a row (not shown)
}
// and close our table
?>
</table>
