search form with pagination Help

[masonprice]

i need some help.....im using a basic form with pagination, but it does not seem to be working for some reason it displays the username i search for the first time but when i click on the next button i get no more results even though i have like 30 more results left in the database ........... any help would be appriciated thanks in advance

Here is the code i am using

<?php include ('connect.php'); ?>
<?phpecho"<h3>Please enter your search Username</h3>
<form action='search.php?find' method='post'>
<input name='username' size='40'  maxlength='32'/>
<input type='submit' value='Submit' />
</form>";?>
<hr width="800">
<?php
if (isset($_GET["find"]))
{	
$username =  ($_POST["username"]);

$per_page =5;

$start = @$_GET['start'];
$record_count = mysql_num_rows(mysql_query("SELECT * FROM register WHERE username LIKE '%$username%' ORDER BY username"));

$max_pages = $record_count / $per_page; 

if(!$start)  

$start = 0;

$query = mysql_query("SELECT * FROM register WHERE username LIKE '%$username%'ORDER BY username LIMIT $start, $per_page ");	
$exist = mysql_num_rows($query); 	
if($exist=='0')	
{		
echo "No match found";	
}
else 	
{		
echo "Your matches for: <b>$username</b><br><br>";
while($currow = mysql_fetch_array($query))		
{
$username = ($currow['username']);   

echo"</td>  </tr></table>";?>
<?php echo"<a href='../mysite/$username'>$username</a><br>" ;			}
}
?>
<?php
$prev = $start - $per_page;
$next = $start + $per_page;
echo"<br>";
if(!($start<=0))
echo "<a href='{$_SERVER['PHP_SELF']}?start=$prev'>Prev</a>&nbsp;"
;$i=1;
for($x=0;$x<$record_count;$x=$x+$per_page)
{
if($start!=$x)
echo "<a href='{$_SERVER['PHP_SELF']}?start= $x'>$i</a> "; 
else
echo "<a href='{$_SERVER['PHP_SELF']}?start= $x'>$i</a> ";
$i++;
}
if(!($start>=$record_count-$per_page))
echo "<a href='{$_SERVER['PHP_SELF']}?start=$next'>Next</a>";
echo"&nbsp;$next";echo"<br><br>";
}
?>
</div>
</body>
</html>
<?php include ('footer.php'); ?>

[dalecosp]

I wonder --- if you did a little "clean up", would the issues be easier to find?

For example, I see opening (<?php) and closing tags interspersed throughout. Unnecessary.

I don't see that you indented code blocks. Obviously, PHP could care less, but for humans like us, it's a Good Thing(tm).

So are comments, for that matter.