i created a insert php code which successfully submit to database but i was lost at some point because what i really wanted was a php code that will print on the next page after submission to db
<?php
include ("config.php");
//Connect to server and select databse.
mysql_connect ("$host", "$username", "$password") or die("cannot connect to server");
mysql_select_db("$db_name") or die("cannot select DB");
$ p= $_POST['firstname'];
$ b= $_POST['lastname'];
$ a= $_POST['location'];
$ user= $_POST['username'];
$ d= $_POST['dt'];
$ am=$_POST['state'];
$ p=$_POST['password'];
$ f=$_POST['sex'];
$sql="INSERT INTO $tbl_name(firstname,lastname,location,username,dt,state,password,sex)
VALUES('$_POST[firstname]','$_POST[lastname]','$_POST[location]','$_POST[username]','$_POST[dt]','$_POST[state]','$_POST[password]','$_POST[sex]')";
$result=mysql_query($sql);
header ("location:account-tr.php");
?>
config.php
<?php
$host="localhost"; // Host name
$username="*****"; // Mysql username
$password="*****"; // Mysql password
$db_name="****"; // Database name
$tbl_name="registration"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
?>