Anchoring the Action URL of a Form

[ArizonaJohn]

Hello,

 

I am using a function that leads users to a file called "comments2.php":

 

<form  action="http://www...com/.../comments/comments2.php" method="post">

 

On comments2.php, data passed over from the form is inserted into MySQL:

 

$query = sprintf("INSERT INTO comment VALUES (NULL, %d, %d, '%s', NULL)", $uid, $subid, $comment);

mysql_query($query) or die(mysql_error());

 

Then, later in comments2.php, I am using a query that loops through entries meeting certain criteria. The loop contains a row with the following information:

 

echo '<td rowspan="3" class="commentname1" id="comment-' . $row["commentid"] . '">'.stripslashes($row["comment"]).'</td>';

 

For the function above, I would like the URL to be anchored by the highest value of "commentid" for

id="comment-' . $row["commentid"] . '"

 

How can this be done?

 

Thanks in advance,

 

John

[premiso]

SELECT MAX(commentid) FROM comment LIMIT 1

 

If that is what you are asking for, that should get the highest commentid value.