[Resolved] Cannot insert?

[james_cwy]

I have been trying to insert into the database but to no avail. Here is my code.
//insert into d/b
$db = mysql_connect("localhost", "root", "");

mysql_select_db("test",$db);

$sql1 = "INSERT INTO Templates
(Annotate,Create,Personality,Service1,Service2,Service3,TCP,UDP,Bind) VALUES ('$h1textz','$h1texta','$h1textb','$h1textc','$h1textd','$h1texte','$h1textf','$h1textg','$h1texth')";

$insertresult1 = mysql_query($sql1);

echo "Thank you! Information entered.\n";

I tried to insert the first field and it was OK but when I try to insert two fields or more, it just does not insert. Am I missing something here?

THanks

[sid]

without actually taking an all too close look at the query its much likely, that there are constraints in your table that wont let you insert certain things (unique? keys?)

maybe you could post your table structure?

also try this:

//insert into d/b 
$db = mysql_connect("localhost", "root", ""); 

mysql_select_db("test",$db); 

$sql1 = "INSERT INTO Templates 
(Annotate,Create,Personality,Service1,Service2,Ser
vice3,TCP,UDP,Bind) VALUES ('$h1textz','$h1texta','$h1textb','$h1textc','$h1t
extd','$h1texte','$h1textf','$h1textg','$h1texth')
"; 

$insertresult1 = mysql_query($sql1); 

/*NOTE THIS LINE!!! should give you extra info in case of an error*/
print mysql_error();

echo "Thank you! Information entered.\n"; 

[james_cwy]

After trying a few hours yesterday, it began to work. I do not know why but I think the computer went coo-coo.