Record added, but no data

[direwolf]

I am having a problem inserting data into a MySQL database. I created a form and am passing the variables to a script to add the records. The $result returns good and a row is added to the table, however the fields are empty. Here is the script code:

<?php
$dconn = mysql_connect("localhost", "user", "pass")
or die ("Could not connect.");

mysql_select_db("addressbook", $dconn) or die ("Could not select the database!");

$sql = "INSERT INTO contact_info (id,fname,lname,suffix,address1,address2,city,state,zip,email,homephone,cellphone,workphone,birthday,picture) VALUES ('$id','$fname','$lname','$suffix','$address1','$address2','$city','$state','$zip','$email','$homephone','$cellphone','$workphone','$birthday', '$picture')";

$result = mysql_query($sql, $dconn) or Die("Could not add record.");

?>

Any help would be greatly appreciated.

[Nate]

How is the data being passed to your script? POST or GET? Maybe your PHP setup requires you to specify variables by $_POST['myvariable'] rather than $myvariable.

[direwolf]

That did it! Thanks!