// Write the data to the
database
$query = "INSERT INTO staff (name, lastname, username, password, position,
department, birthmonth, birthday, birthyear,
location, phone, email, street, city, state, country,
zip, tags, photo)
VALUES ('$name', '$lastname', '$username', '$password', '$position',
'$department', '$birthmonth', '$birthday', '$birthyear', '$location',
'$phone', '$email', '$street', '$city', '$state', '$country',
'$zip', '$tags', '$photo')";
mysql_query($query);
var_dump($query);
echo '<p>' . $name . ' has been added to the Employee Directory.</p>';
if (!$query) {
die('Invalid query: ' . mysql_error());
}
Can someone tell me why the above code produced:
string(332) "INSERT INTO staff (name, lastname, username, password, position, department, birthmonth, birthday, birthyear, location, phone, email, street, city, state, country, zip, tags, photo) VALUES ('Craig', 'Hooghiem', 'sdf', 'sdf', 'sdf', 'sdf', '01', '01', 'sdf', 'sdf', '', 'sdf', 'sdf', 'sd', 'sdf', 'sdf', 'sd', 'sdg', 'leftround.gif')"
Craig has been added to the Employee Directory.
But does not actually add anything into the
database table "staff" ?
I must be missing something obvious here.
