On Tue, August 23, 2005 3:52 pm, George B wrote: > You know on forums when you make a topic right away it makes like a > new > link to your topic. How do you do that in PHP? <?php //Untested code: if (isset($_POST['new_topic'])){ $new_topic = $_POST['new_topic']; $new_topic = mysql_escape_string($new_topic); $query = "insert into topics (topic) values ('$new_topic')"; $insert = mysql_query($query) or die (mysql_error()); $topic_id = mysql_insert_id(); echo "<a href=\"topics.php?topic_id=$topic_id\">$_POST[new_topic]</a>"; } ?> http://php.net/mysql_insert_id is probably the piece of the puzzle you were missing. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php