table with links

[mephitis]

I'm querying a database to create an html table containing some values in a db-table. Then one column of that table is a link which will open a new page so I can edit that record in the db table.

Here's a snippet of the PHP code I'm trying to use. It works fine if I don't try and pass anything back on the link. But if I don't, how will the receiving PHP program know which record to query (which link I clicked on)?

It gets a parse error in the row with the <a href... What I want for the html code is: <a href=history-update.php?id=23&date_history=2354>

while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['id'];
echo "</td><td>";
echo "<a href=history-update.php?id=$row['id']&date_history=$row['date_history']";
echo $row['date_history'];
echo "</a></td><td>";
echo $row['abstract_history'];
echo "</td><td>";
echo $row['text_history'];
echo "</td></tr>";

I know it's got to be something trival, but I can't see the problem.

[rsmith]

Well you are trying to access named keys. For that you need to do:

while($row = mysql_fetch_assoc($result)){
//code goes here
}