Form data to sql database

[wileee]

Hi,

I'm trying to setup a web form that will put data into a sql database. I had everything working with a simple test database (first name, last name, phone number). But once I added "address" and "city" to the process, the data collected in the database simply shows "Array(address)" or "Array(city)" and not the actual data I typed into the form. (The other fields work normally).

Any help would be appreciated.

Here is my code:

<?php
 
$EntryDate= date('Y-m-d H:i:s');
 
$con = mysql_connect("localhost", "login", "password");
if (!$con)
    {
    die('Could not connect: ' . mysql_error());
    }
 
mysql_selectdb("database_name", $con);
 
$sql="INSERT INTO data (`EntryDate`, `FirstName`, `LastName`, `Institution`, `Address`, `City`)
VALUES
('$EntryDate', '$_POST[fname]', '$_POST[lname]', '$_POST[inst]', '$_POST(address)', '$_POST(city)' )";
 
if (!mysql_query($sql,$con))
    {
    die('Error: ' . mysql_error());
    }
echo "Thank you.";
 
mysql_close($con);
 
?>

[ak1dnar]

('$EntryDate', '$_POST[fname]', '$_POST[lname]', '$_POST[inst]', '$_POST[address]', '$_POST[city]' )";
 

Mind the Brackets. It should be square ones. not the parenthesis.

[wileee]

Guess I was in a hurry to get things working.

Thank you very much.

[ak1dnar]

Guess I was in a hurry to get things working.

Thank you very much.

Glad to hear that.Good luck with your projects. If you ever need anything post back to the Forum.