PHP database upload

Hi Again,

I was wondering if somebody could help me see why I am getting this problem. I have written the program below but when I run it only certain fields will update with the values entered. All other fields will update but the address.

Thanks for the help: -

the html code is: -

<form action="user.php" method="post">
    <table border="1">
            <td><input type="text" name="FullName" /></td>
            <td><input type="text" name"address"/></td>
            <td>Date of Joining</td>
            <td><input type="text" name="Date"/></td>
            <td>Telephone Number</td>
            <td><input type="text" name="tele"/></td>
            <td><input type="text" name="email"/></td>
            <td><input type="text" name="User"/></td>
            <td><input type="text" name="pass" /></td>
            <td colspan="4" style="text-align:center;"><input type="submit" value="Add Staff" /></td>

my user.php program is: -

//connect to the database
$con = mysql_connect("servername","username","password");
  if (!$con) //states that if connection can't be established run the error
  die('Could not connect:'.mysql_error());
//link to the database Klinic_ganga_stock_system
mysql_select_db("Klinic_ganga_stock_system", $con);
//add the details from adminpage.html add new staff the the table staff_record
$sql = "INSERT INTO staff_record (Name,Address,Date_of_joining,Telphone_number,Email,UserName,Password)
//run the query
if (!mysql_query($sql,$con)){//this states that if the query can not be run then it will print the error
  else {
	  print"Information added";
 //close the connection

thanks guys

Instead of name"address", try name=“address” :wink:

Also, be sure to escape your input fields (using something like [fphp]mysql_real_escape_string[/fphp]). That code can be exploited very easily to ruin your database. Event better, use [fphp]PDO[/fphp].

Thanks Guys, needed a fresh pair of eyes