Goodday everyone in the house. kindly assist me. i need help on how to link a sign up form on my website to a table in my database using the PHP codes. so that user will be able to choose a username and a password by themselves. I have been able to create a connection between the website and the database, but i couldn't go beyond that. thanks

Let's see what you've done so far so that we can help you complete it.

paste your code to see how we will be of help

What if he only created database nd tables without having any idea of the insert.php codes?

I think what he needs to paste here is the table contents and the form code then we could create you the insert.php that validates, checks logins, sessions etc.

@startech and @afam4real. i actually created the database from phpmyadmin and the website from dreamwaver8 and i av been able to connect to mysql server using this code
<?php
$username = "AZENAS";
$password = "";
$hostname = "localhost";

//connection to the database
$dbhandle = mysql_connect($locahost, $AZENAS, $dbpass)
or die("Unable to connect to MySQL";
echo "Connected to MySQL<br>";
?>

but i couldnt go beyond that.

the database name is "forum" and the table name is "member"

@startech and @afam4real. i actually created the database from phpmyadmin and the website from dreamwaver8 and i av been able to connect to mysql server using this code
<?php
$username = "AZENAS";
$password = "";
$hostname = "localhost";

//connection to the database
$dbhandle = mysql_connect($locahost, $AZENAS, $dbpass)
or die("Unable to connect to MySQL";
echo "Connected to MySQL<br>";
?>

but i couldnt go beyond that.

the database name is "forum" and the table name is "member"
it contains fields like Display name:, E-mail, password, password retype, gender, and phone number

what i want to achive is link dis form to the database so that when user registers, there information is automatically stored in the database and they can login from the log in page. just like facebook and yahoo.

since you av created the table in d database with the fields. You wil go to dreamweava n create a page kaled register.php dere you wil need to build d page wit php codes if you know php or rather i wil advice u go n download videos on how to build a registration page dere u wil b taught how to code it if only u undastand dos codes 4rm line 1 to d ending.Goodluck on ur way 2 programing

Ok, it seems u re through with the html aspect of it already... Now its time for u to do some programming... Like someone suggested use google, get some video tutorials, there u will learn how to write the register.php nd the insert.php codes.. U may want to give it to an expact to do this for you cos u dont want to write un-safe codes to aviod hackers.

you are making mistakes from your first query..

Correct one is:

<?php
$username = "AZENAS";
$password = "";
$hostname = "localhost";

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)

//if connection is or isn't successful
if(!$dbhandle){
die( "Unable to connect to MySQL - ".mysql_error() ) ;
}else{
echo "Connected to MySQL";
}
?>