[Resolved] sumped - can't get data into db

[jacksonpt]

Any idea why this wouldn't put data in my DB? I've been staring at this all afternoon, so I'm probably just missing something stupid. The confirmation message at the bottom is displayed, so I know this section of code is being run. When I do a select all from the registrations, I get an empty set returned.

  $db = mysql_connect("localhost", "root");
  mysql_select_db("visitdays",$db);
  $result = mysql_query("INSERT INTO registrations (
                                     Title, 
                                     FirstName, 
                                     LastName,                                      

                                     Email, 
                                     Street, 
                                     City, 
                                     State, 
                                     Zip, 
                                     Semester, 
                                     Status, 
                                     Date, 
                                     NumPeople, 
                                     SchoolSession)
                        VALUES (
                                     '$Title', 
                                     '$FirstName', 
                                     '$LastName', 
                                     '$Email', 
                                     '$Street',
                                     '$City',
                                     '$State',
                                     '$Zip', 
                                     '$Semester', 
                                     '$Status', 
                                     '$Date', 
                                     '$NumPeople',
                                     '$SchoolSession')
                                     ");

  echo "Thank you! Your information has been received.\n<br>We look forward to seeing you on ";
  printf ($Date);
  echo ".";

[stfuji]

You might want to wrap you query result in an if statement to see if it executed correctly:

//     Database Params
$dbhost = "localhost";
$dbname = "visitdays";
$dbuser = "root";
$dbpsswd = "";


//   SQL Query
$sql = "INSERT INTO registrations (
                                     Title, 
                                     FirstName, 
                                     LastName,                                      

                                     Email, 
                                     Street, 
                                     City, 
                                     State, 
                                     Zip, 
                                     Semester, 
                                     Status, 
                                     Date, 
                                     NumPeople, 
                                     SchoolSession)
                        VALUES (
                                     '$Title', 
                                     '$FirstName', 
                                     '$LastName', 
                                     '$Email', 
                                     '$Street',
                                     '$City',
                                     '$State',
                                     '$Zip', 
                                     '$Semester', 
                                     '$Status', 
                                     '$Date', 
                                     '$NumPeople',
                                     '$SchoolSession')
                                     ";

//  Preform the connection and die on error
if(!$dbconn = mysql_connect($dbhost, $dbuser, $dbpsswd)){
     die("No connection...");
}

//  Select Active Database and die on error
if(!$dbselect = mysql_select_db($dbname, $dbconn)){
     die("Unable to select appropriate db");
}

//  Query Active Database and die on error
if(!$result = mysql_query($sql)){
     die("Unable to preform query");
}

//  Preformed all db task successfully Print Done Message
echo "Thank you! Your information has been received.\n<br>We look forward to seeing you on ";
  printf ($Date);
  echo ".";

This might help you discover where your problem is

-Geoffrey

[jacksonpt]

The code is wrapped in an if statement - that's how I know for sure the code is being run. I put in the error checks, and got the "unable to perform query" error. What should that be telling me? Is it a syntax problem in the SQL, or something different?

BTW, thanks for the error handling code - that will come in very handy in the future.

[stfuji]

If you are getting an error at the query level you most likely have an SQL syntax error...

Try printing the $sql in the error message:

//  Query Active Database and die on error 
if(!$result = mysql_query($sql)){ 
     die("Unable to preform query<br>" . $sql); 
} 

The cause of your error could be many things. The first thing that jumps out at me might be the date.

Everything you are passing into the query is in quotes which means it is text or character.

Mysql will reject information if it is not the right kind.

IE a date has to be a valid date format

1/2/2004 (no quotes if I remember right)

So check to make sure you are passing in the right kind of data or the database will reject it.

I normally filter the problem by passing in one piece of data at a time to see what is causing the error:

$sql = "INSERT INTO registrations (title) VALUES ('$title')";

//  Query Active Database and die on error 
if(!$result = mysql_query($sql)){ 
     die("Unable to preform query<br>".sql); 
} 

$sql = "UPDATE registrations SET (lastname = '$lastname') WHERE title = '$title'";

//  Query Active Database and die on error 
if(!$result = mysql_query($sql)){ 
     die("Unable to preform query<br>".sql); 
}

and so on. This is a pain in the rear to do, but will eventually lead you to your sql query error.

Best Luck,
Geoffrey