Re: from database to links

Richard Lynch wrote:

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. How did you get this in your link?

topics.php?topic_id=$topic_id I cant figure.