Dont know... maybe the result statement would help (select from)
Ummmm.... your code:
<?while($row=mysql_fetch_array($result))
{
?>
<tr>
<? $personcode=$row["personcode"];?>
<td><a href="newscript.php?personcode=<?echo $personcode;?>><?echo $personcode;?></a></td>
<td><?echo $row["firstname"];?></td>
<td><?echo $row["lastname"];?></td>
<td><?echo $row["location"];?></td>
<td><?echo $row["phonenumber"];?></td>
<td><?echo $row["jacknumber"];?></td>
<td><?echo $row["division"];?></td>
</tr>
<?}
maybe use:
<?
while($row=mysql_fetch_array($result))
{
?>
<tr>
<td><a href="newscript.php?personcode=<?=$row[personcode];?>><?=$row[personcode];?></a></td>
<td><?=$row[firstname];?></td>
<td><?=$row[lastname];?></td>
<td><?=$row[location];?></td>
<td><?=$row[phonenumber];?></td>
<td><?=$row[jacknumber];?></td>
<td><?=$row[division];?></td>
</tr>
<?
}
?>
There is no good reason to switch... just personal preference... i hate posting without some sort of tip or code... sorry couldnt help... but if you supply the whole select statement...