Need PHP MYSQL help

i am using a form which post the data to MYSQL database form example if i have three inputs

a. First Name
b. Last Name
c. Age

I want to script my code in a way when some1 enter the info twice it may appear as below:

First Name Last Name queries
————————————

xyz abc 2
————————————-

But my form is showing the following output

First Name Last Name queries
————————————

xyz abc 0

xyz abc 0
————————————-

[COLOR=”Red”]can some body help?[/COLOR]

The file<insert.php> which is used to post form data to MYSQL database is:

[QUOTE]

<?php
$con = mysql_connect(“localhost”,”myuser,”mypass”);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}mysql_select_db(“mydatabase”, $con);$sql=”INSERT INTO person (id, FirstName, LastName, Age)
VALUES
(”,’$_POST[firstname]’,’$_POST[lastname]’,’$_POST[age]’)”;if (!mysql_query($sql,$con))
{
die(‘Error: ‘ . mysql_error());
}
echo “1 record added”;mysql_close($con)
?>

[/QUOTE]

The file to show output on php page is:

[QUOTE]

<?php
// … the previous code
$con = mysql_connect(“localhost”,”myuser”,”mypass”);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}

mysql_select_db(“mydatabase”, $con);

$result = mysql_query(“SELECT * FROM person”);

echo “<table border=’1′>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>”;while($row = mysql_fetch_array($result))
{
echo “<tr>”;
echo “<td>” . $row[‘FirstName’] . “</td>”;
echo “<td>” . $row[‘LastName’] . “</td>”;
echo “<td>” . $row[‘age’] . “</td>”;
echo “<td>” . $row[‘id’] . “</td>”;
echo “</tr>”;
}
// creating previous and next link
// plus the link to go straight to
// the first and last page

if ($pageNum > 1)
{
$page = $pageNum – 1;
$prev = ” <a href=”$self?page=$page”>[Prev]</a> “;

$first = ” <a href=”$self?page=1″>[First Page]</a> “;
}
else
{
$prev = ‘&nbsp;’; // we’re on page one, don’t print previous link
$first = ‘&nbsp;’; // nor the first page link
}

if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = ” <a href=”$self?page=$page”>[Next]</a> “;

$last = ” <a href=”$self?page=$maxPage”>[Last Page]</a> “;
}
else
{
$next = ‘&nbsp;’; // we’re on the last page, don’t print next link
$last = ‘&nbsp;’; // nor the last page link
}

// print the navigation link
echo $first . $prev . $nav . $next . $last;

// and close the database connection
echo “</table>”;mysql_close($con);
?>

[/QUOTE]

Also in #PHP _↴