[Resolved] Looking to echo the ID number from

badgoat

Hi!

I have this little script.. hi.php allows me to enter a name and age. welcome.php echoes back the data added. My question: How do I echo the ID # from the MySQL database? The goal would be to have another cell on the welcome.php table to identify the ID #.

Scripts are below, and thank you in advance!

hi.php:

<html>
<body>

<form action="welcome.php" method="POST">
Enter your name: <input type="text" name="name" />
Enter your age: <input type="text" name="age" />
<input type="submit" />
</form>

</body>
</html>

and welcome.php:

<?
include ("config.php");
$name=$HTTP_POST_VARS['name'];
$age=$HTTP_POST_VARS['age'];


$connection=mysql_connect($hostname, $username, $password)
or die("Could not establish connection");
mysql_select_db($database_name, $connection)
or die ("Could not select database");
$query="INSERT INTO `example` (name, age) VALUES ('".$name."', '".$age."')";

echo $query;
$result=mysql_query($query);
mysql_close($connection);
if (!$result)
   {die("<font color=\"red\"><b>Your information COULD NOT be entered into the database\.</font><br>");}

echo "
<TABLE BORDER>
<TR>
	<TD COLSPAN='2'>Our records indicate that you are</TD>
	</TR>
	<TR>
	<TD>Name</TD><TD>".$name. "</TD>
</TR>
<TR>
	<TD>Age</TD><TD>" .$age. "</TD>
</TR>
<TR>
  <TD COLSPAN='2'><a href='hi.php'>Do another!</a></TD>
</TABLE>";
?>

<html>
<body>
</body>
</html>

LordShryku

[man]mysql_insert_id[/man]

badgoat

While I appreciate that anyone would try to point me in the right direction, I must say that a simple link to the command doesn't work well in the 'Newbie' section of the board. Basically it's like saying "RTFM!" If I understood the PHP manual well enough to make heads or tails of the little examples they have after each command I'd be set.. But not in this case.. At least, I am not at that level yet, and I haven't found a 'PHP extreme noob' board yet.

I have tried :

<TD>ID</TD><TD>" .$id. "</TD>
<TD>ID</TD><TD>("Last inserted record has id %d\n", mysql_insert_id())</TD>
<TD>ID</TD><TD>mysql_insert_id()</TD>
<TD>ID</TD><TD>'mysql_insert_id()'</TD>
<TD>ID</TD><TD>"mysql_insert_id()"</TD>

and so far, no luck. The PHP manual isn't descriptive enough to help me out.

Could someone please explain in noob-speak?

TheDefender

In defense of LordShryku (not that he needs me to defend him), a link to the mysql_insert_id seemed like a reasonable thing to do given the fact that you had all of this other code out here... It's more than most noobs do here, so he probably figured you had some working knowledge to be able to work through the manual on a suggestion.

$result=mysql_query($query); 
$lastidinserted = mysql_insert_id();
echo $lastidinserted;

badgoat

Defender, thank you. I copied the code in, got an error. but at least with an error code, I get something to work with.

I changed one line of the code from:

$lastidinserted = mysql_insert_id($result);

To:

$lastidinserted = mysql_insert_id();

and now it works!

Thanks again

TheDefender

YW. Sorry, you didn't need the result set identifier in the mysql_insert_id(). I have corrected my original post to reflect it.
Be sure to mark this thread resolved using the "Mark Thread Resolved" link at the bottom.