.mysql_insert_id();

[dropfaith]

Okay So what im trying to do inserts a record into database then i need to pull the id field back out and display it in the form of a link like below i know how to pull the id field of the inserted row but it wont display in the link like below any ideas?

 

its for a business index where they enter the fileds for the business  then it proceeds to a form to add the hours of the business

 

<a href=addhours.php?Id=8>

[Lamez]

oh this is simple

 

<?php
$id = $_POST['id'];
$query = "INSERT INTO `table_name` (id) VALUES ('$id')";
mysql_query($query);

$r = mysql_query("SELECT * FROM `table_name`");

$row = mysql_fetch_array($r);
id = $row['id'];
echo '<a href=addhours.php?Id='.$id.'>ID: '.$id.'</a>'; // 1 results

while ($row = mysql_fetch_array($r)){
id = $row['id'];
echo '<a href=addhours.php?Id='.$id.'>ID: '.$id.'</a><br>'; // ALL results
}


?>

[JasonLewis]

Just use the mysql_insert_id() like you have in your topic title.

 

echo "<a href='addhours.php?id=" . mysql_insert_id() . "'>" . mysql_insert_id() . "</a>";

[Fadion]

Adding to ProjectFear's post, in the manual it is stated:

 

Note: Because mysql_insert_id() acts on the last performed query, be sure to call mysql_insert_id() immediately after the query that generates the value.

 

Meaning that you must call it before making any other queries after the insert one.