Re: from database to links

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux