this is probably not the right way to do this but this is what i have.
i am displaying all the results in the mysql db on this page.
//run a loop to show all results
$i=0;
while ($i < $num) {
$id = mysql_result($results,$i,"id");
$name = mysql_result($results,$i,"name");
$position = mysql_result($results,$i,"position");
$tagline = mysql_result($results,$i,"tagline");
$bio = mysql_result($results,$i,"bio");
$photo = mysql_result($results,$i,"photo");
//now display the form
?>
<link href="styles.css" rel="stylesheet" type="text/css" />
<div align="center">
<table width="350" border="0" cellpadding="5" cellspacing="0" class="outlinebox">
<tr>
<td width="110" align="left" valign="top"><img src="../headshots/<? echo $photo;?>" width="110" height="168" /></td>
<td width="220" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><p><? echo $name;?></p></td>
</tr>
<tr>
<td><img src="nav/images/spacer.gif" width="5" height="5" /></td>
</tr>
<tr>
<td><p><? echo $position; ?></p></td>
</tr>
<tr>
<td><img src="nav/images/spacer.gif" width="5" height="5" /></td>
</tr>
<tr>
<td><p><? echo $tagline; ?>... [<a href="javascript:void(0);" onclick="window.open('../../inc/credits-full.php?id=<? echo $id;?>','flyout','scrollbars=yes,toolbar=no,menubar=no,resizable=no,locationbar=no,hotkeys=no,status=no,width=425,height=400,top=0,left=0');">more</a>] </p></td>
</tr>
</table></td>
</tr>
</table>
</div>
<br /> <? //this will repeat the table until all rows are displayed.
$i++;
}
the problem i am having is here
<td><p><? echo $tagline; ?>... [<a href="javascript:void(0);"
onclick="window.open('../../inc/credits-full.php?id=<? echo $id;?>',
'flyout','scrollbars=yes,toolbar=no,menubar=no,resizable=no,locationbar=no,hotkeys=no,status=no,width=425,height=400,top=0,left=0');">more</a>] </p></td>
when i reference this with the credits-full.php?id=1. I still show all the records in the db.
I have tried taking out the loop code, but then all i ever get is the first entry in the database.
what i want this to do is when they click on the url it pulls up the entry in the database based on the id number inserted into the url.
can anyone help??
thanks in advance.
