Add/Display Database Data

[Dysan]

Hi, I have the following code, that stores form data into a MySQL database.

How do I provide a link on this page, that navigates to a page called "card.php", and displays the appropriate id for that person?

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
  die(mysql_error());
}

mysql_select_db("db", $con);

$sql="INSERT INTO users (id, name, account)
VALUES ('$_POST[id]','$_POST[name]','$_POST[account]')";

if (!mysql_query($sql,$con))
{
  die(mysql_error());
}
echo $_POST[name]."'s Account Created Successfully!";

mysql_close($con)
?>

[roscor]

session_start();
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
  die(mysql_error());
}

mysql_select_db("db", $con);



$id=mysql_real_escape_string($_POST['id']);
$name=mysql_real_escape_string($_POST['name']);
$account = mysql_real_escape_string($_POST['account']);

$sql="INSERT INTO users (id, name, account)
VALUES ('$id','$name','$account')";

if (!mysql_query($sql,$con))
{
  die(mysql_error());
}
else
 {
//set session
$_SESSION['reg_name']=$name;
$_SESSION['reg_id']=$id;
$_SESSION['reg_account']=$account;

//then on card.php call the session id, ensure session_start() is at the start of your code
header("Location: card.php");
}

mysql_close($con)