Re: from database to links
| From: | Richard Lynch | Date: | Wed, 24 Aug 2005 06:20:08 +0000 |
| Subject: | Re: from database to links | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-221228@lists.php.net to get a copy of this message | ||
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