Anchoring the Action URL of a Form

PHP
1

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

2

If you have understood what you are asking, it is like when posting comments in wordpress comment form it will redirect to that comment directly. If this is the case, you need to redirect the page after successful entry to the mysql database. To get the last inserted comment id, if you have id field auto_increment you can use mysql_insert_id() function:


$query = sprintf("INSERT INTO comment VALUES (NULL, &#37;d, %d, '%s', NULL)", $uid, $subid, $comment);
mysql_query($query) or die(mysql_error());
$lastcommentid = mysql_insert_id();
header("Location: comment2.php#comment-$lastcommentid");
exit();

Hope i understood what you are looking for. If not, sorry for misunderstanding :wink: