plzz help me

[Broken Angel1987]

PHP danna kenek help karanna mata

mama PHP walin Database create kala but table 1ka hedenne nene ai e me mage code 1ka.Database 1ka hedenawa table 1ka hedenne ne


<?php

$con=mysql_connect("localhost","root","");
if(!$con)
{
die('colud not connect to data base there are erroe'.mysql_error());
}

if(mysql_query("Create DATABASE staff3",$con))
{
echo "database is created";
}

else
{
echo "Error Creating Database:".mysql_error();
}

mysql_select_db("staff3",$con);
$sql="CREATE TABLE Members
(
StaffNo varchar NOT NULL,
PRIMARY KER(staffNo),
FirstName varchar(15),
LastName varchar(15),
Position varchar(10),
Sex varchar(5),
DOB varcar(20),
Salary int
)";

mysql_query($sql,$con);



mysql_query("INSERT INTO Members(StaffNo,FirstName,LastName,Position,Sex,DOB,Salary)
VALUES('SM21','Amal','Nilesh','Manager','M','1-Oct-42','40000')");


mysql_close($con);
?>

 

[ashavithanage]

Help pl..
bump

 

[Broken Angel1987]

aiiyoo kauruth danna kenek neda

 

[Malinga]

<?php

$con=mysql_connect("localhost","root","");
if(!$con)
{
die('colud not connect to data base there are error'.mysql_error());
}

if(mysql_query("Create DATABASE staff3",$con))
{
echo "database is created";
}

else
{
echo "Error Creating Database:".mysql_error();
}

mysql_select_db("staff3",$con);
$sql="CREATE TABLE Members
(
StaffNo varchar(4) NOT NULL,
PRIMARY KEY(StaffNo),
FirstName varchar(15),
LastName varchar(15),
Position varchar(10),
Sex varchar(5),
DOB varchar(20),
Salary int
)";

mysql_query($sql,$con);



mysql_query("INSERT INTO Members(StaffNo, FirstName, LastName, Position, Sex, DOB, Salary)
VALUES('SM21','Amal','Nilesh','Manager','M','1-Oct-42','40000')");


mysql_close($con);
?>

 

[Broken Angel1987]

Thank you very much frnd