What could be the problem with this php code?

C

chrysller

New member
<?php
$con=mysql_connect("192.168.170.15","51636","51636");
if (!$con)
{
die("Could not connect:" .mysql_error());
}

$dbname="db51636";
mysql_select_db($dbname,$con) or die (mysql_error());

$name=$_POST['fname'];
$id=$_POST['staff_id'];
$pay=$_POST['pay'];

$query= ("INSERT INTO staff (staff_id,fname,salary)
VALUES (".$name.",".$id.",".$pay.")");

if (!mysql_query($query,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";

mysql_close($con)

//$result =mysql_query($dbname,$query) or die (mysql_error());
//$staffname = mysql_result ($result,0,0);
//echo "You have Inserted Record:". $staffname;
?>
 
Back
Top