I have a php page that registered members (Approved) can use to add to a pet list for a game. It was working fine, now all of the sudden it is stopping after a certain amount of rows. I have found that when I added it show the id's it stops at id 124, the total count of the rows in the database are 486.
Here is my code:
require_once ('../includes/mysql_connect.php');
if(!isset($mode))
{
$mode = 'list'; // set the default mode to list known pets
}
?>
switch ($mode)
{
case 'list':
$q = "select * from hunter_pets order by hpet_id ASC ";
$rs = mysql_query($q);
<table width=94% align=center class=tableOutline cellspacing=0 border=0 cellpadding=0>
<tr>
<td class=chartheader valign=top align=center>ID</td>
<td class=chartheader valign=top align=center>Speed</td>
<td class=chartheader valign=top align=center>Name</td>
<td class=chartheader valign=top align=center>Rare</td>
<td class=chartheader valign=top align=center>Type</td>
<td class=chartheader valign=top align=center>Level</td>
<td class=chartheader valign=top align=center>Location</td>
<td class=chartheader valign=top align=center>Commands</td></tr>
while ($row = mysql_fetch_array($rs))
{
extract ($row);
// Display records into table rows.
echo "<tr>";
echo "<td class=chartContent>$hpet_id</td>";
echo "<td class=chartContent><strong>$attack_speed</strong></td>";
echo "<td class=chartContent>$pet_name</td>";
if ($row['pet_spawn'] == 'Y') {
echo "<td class=chartContent> Y </td>";
} else {
echo "<td class=chartContent>---</td>";
}
echo "<td class=chartContent>$pet_type</td>";
echo "<td valign=top class=chartContent>" . $row['pet_minlevel'] . "";
if ($row['pet_maxlevel']) {
echo " - " . $row['pet_maxlevel'] ."</td>";
} else {
echo "</td>";
}
echo "<td class=chartContent>$pet_location</td>";
echo "<td align=right class=chartContent><a href=\"$PHP_SELF?mode=edit&hpet_id=$hpet_id\">Edit</a> | <a href=\"$PHP_SELF?mode=delete&hpet_id=$hpet_id\">Delete</a></td>";
echo "</tr>";
}
</table>
break;
case 'add':
// Display Adding Form.
I also have modes on this page to add, edit and delete from the list. If more is needed I can post it as well
