CODEWITHSUNDEEP
phpmysql
John
John

Reputation: 4944

Appending Comment Number Anchors to Comments

I am using a PHP file called comments.php that has a query that enters values into a mySQL table called "comment." As the query does this, it auto-generates a field called "commentid", which is set to auto_increment in MySQL. The file also contains a loop what echoes out all comments for a given submission.

It all works fine and dandy, but I want to simultaneously pull this "commentid" and turn it into a hashtag / anchor that when appended to the end of the URL makes that comment at the top of the user's browser.

Someone said on another question that in order to do this one thing I should do is create an anchor on the row where the comment is being printed out. How can I do this?

Thanks in advance,

John

The query that inserts comments into the MySQL table "comment":

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

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

The fields in the table "comment":

commentid loginid submissionid comment datecommented

The row in a loop where the comments are echoed out:

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

Upvotes: 0

Views: 82

Answers (2)

simonhamp
simonhamp

Reputation: 3339

If you're concerned with standards, use ID as this is more portable code and make sure you start the value of id with a letter, not a number:

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

Upvotes: 2

Gabriel
Gabriel

Reputation: 18780

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

Upvotes: 0

Related Questions