What is wrong with my code? Help needed

ssun

I have 3 tables in my database, aal i'm trying to do is display all the info in one table & when i select one of the rows, it has to display that rows(that persons) info from the other table.
This is my code

<?$result= mysql_query("select* from personalinventory") or
die(mysql_error());?>
<?while($row=mysql_fetch_array($result))
{
?>
<tr>
<td><a href="<?$row["personalinventorydisplay.php?topic=personcode"]?>">
<?echo $personcode;?></a></td>
<?//echo "<a href='personalinventorydisplay.php?personcode='$personcode''>".$personcode."</a>";
?><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>
<?}
echo "<br>\n";?>
</table>

I'm trying to hyperlink the first column of each row, so that in the personalinventorydisplay, i can dynamically display each person's
corresponding data.(The above code is producing all the columns in the table , except the hyperlinked column). Also how do i do the dynamic link??
Can someone please help me out here?

sarahk

I would imagine you would have the link reading like

<?php $personcode = $row["personcode"];?>
<td><a href="personalinventorydisplay.php?topic=<? echo $personcode;?><? echo $personcode;?></a></td>

When you are playing around with this view the source of the output code and copy into your html editor (eg golive, dreamweaver) and check what's wrong and what you need to do to get it to work. Then look at getting the php to output the correct detail.

good luck

ssun

This code works great in including the hyperlink but it skipps alternate rows of the database(ie. if my database has 1-10 rows, the loop only displays, rows 2,4 ,6,8 &10), this i guess is because of this code within the while loop.
<? $personcode=$row["personcode"];?>

Any suggestions to avoid this?

tomhath

Are you sure there isn't another mysql_fetch in the code? That's the only thing that should make it skip rows.

ssun

Within the while loop, I added this code

<?php $personcode = $row["personcode"];?>
<td><a href="personalinventorydisplay.php?topic=<? echo $personcode;?><? echo $personcode;?></a></td>.

Before i could add this, All the rows of data used to display, just the personcode column for every row would be blank

Here is how the code looks now, there is no other mysql_fetch other than the mysql_fetch_array other than the one in the While loop.

<?$result= mysql_query("select* from personalinventory") or
die(mysql_error());?>
<? $a= is_array($results);
echo $a;?>
<?while($row=mysql_fetch_array($result))
{
?>
<tr>

<? $personcode=$row["personcode"];?>
<td><a href="personalinventorydisplay.php?topic=<? 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>
<?}