linking to data called from a database not working

[shadiadi]

mmm I have spent hours just to get this half working.
In this script i call news headlines that are stored in my database and they then echo to show the last 9 articles. It works to that point i am trying to link to each individual headline that whe clicked should sed the data to news,php ad show the full headlie ad article. At the momet whe i click on any of the linked headlies it goes to news.php but only shows the last displayed news article i the headlie list and not the one i selected?? Ay help would be appreciated.

<p>

<table cellspacing="0" cellpadding="2" border="0">
<form name="news" method="post" action="news.php">

<?
$sql = "SELECT * FROM tblnewsdetails order by intnewsID desc limit 9";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
$tradeaid = $row["intnewsID"];
$accountid = $row["intAccountID"];
$stitle = $row["newsshTit"];
$mtitle = $row["newsTit"];
$nmain = $row["newsMn"];
$updated = $row["dtAddedOn"];
?>

<?
echo '<tr><td width="90% align=left"><a onclick="submit();">'. $stitle. '</a></td></tr>';
}
?>

<input name="mtitle" type="hidden" id="mtitle" value="<?=$mtitle?>">
<input name="nmain" type="hidden" id="nmain" value="<?=$nmain?>">
</table>
</form>
</p>

😕 😕

[leatherback]

Hi shadiadi,

Welcome to the forums. In the future, please post in newbies, untill you are more comfortable with PhP. It will help you get more elaborate responses.

The easiest way to do this is by passing the identifier value (intnewsID) through the link, instead of using some javascript to process a hidden form:

echo "<a href=\"news.php?itemdid=".$tradeaid."\">".$stitle."</a>";

Also, you do not need to get the variables from the $row[] array: You can just use those values directly:

echo "<a href=\"news.php?itemdid=".$row['intAccountID']."\">".$row['newsshTit']."</a>";

For some more explanation on passing variables by the url, visit the coding examples (link bvelow)