[SOLVED] Please help i cant find the error

[DrTrans]

<?php


$fname = $_GET['fname'];
$lname = $_GET['lname'];
$slname = $_GET['slname'];
$submit = $_GET['submit'];
$title  = $_GET['title'];
$region = $_GET['region'];
$key = $_GET['key'];
$skey = $_GET['skey'];
$date = date("F j, Y, g:i a");

     
if($title){
 echo "$title";
 $connect = mysql_connect("localhost","damgears_evil","damgears");
     mysql_select_db("damgears_evil");
     $queryb = mysql_query("INSERT INTO titles VALUES ('','$fname','$lname','$key','$slname','$skey','$date','$title','$region'");
   } else 
   echo"Problem.. Check Database";
?>

I dont understand why its not inserting the line in the database.

[cags]

Most like a query failure... to find out what it might be...

 

mysql_query("INSERT INTO titles VALUES ('','$fname','$lname','$key','$slname','$skey','$date','$title','$region'") or trigger_error(mysql_error, E_USER_ERROR);

[mrMarcus]

you're not telling the query where to insert those values.  insert into `titles` ??? no field names to follow .. you need to indicate field names.

 

and just stating "i can't find the error" with a hidden blurb about what the issue is, is not the best way to get people's help.

[cags]

you're not telling the query where to insert those values.  insert into `titles` ??? no field names to follow .. you need to indicate field names.

 

Field names aren't a requirement, it should work without them. Having said that the most like problem assume the OP doesn't have the wrong column cound or one of the values isn't string is that it doesn't like sending '' to an auto increment field. Some versions of MySQL allow it, some don't.

 

and just stating "i can't find the error" with a hidden blurb about what the issue is, is not the best way to get people's help.

 

Couldn't agree more.