INSERT from a form question

Posted: Wed Sep 13, 2006 9:43 am

I got my form and table already. For my form action I wanted to use a string instead of a file (ie insert.php).

Code:

$addcat = $db->sql_query("INSERT INTO ".$prefix."_league_cats (cid, ctitle) VALUES ('$ctitle')");


$ctitle = 'name';

$addcat is my form action and name is my field. Did I go wrong somewhere?

Posted: Wed Sep 13, 2006 10:20 am

oh nevermind,

Code:

$addcat = $db->sql_query("INSERT INTO ".$prefix."_league_cats (cid,ctitle) VALUES ('cid','$ctitle')");

I found the problem through trial and error.

registered · Posted: Thu Sep 14, 2006 5:50 am

floppydrivez, are you sure that is your working line of code? Is the 'cid' property on the database defined as autoincrement? If so, I would just use '' instead of 'cid', or I believe you can even use NULL. The real problem is that you had a mismatch of number of properties to values in your original line of code. Those need to match.

Posted: Thu Sep 14, 2006 5:57 am

Yes you are correct. It should look a little more like this. It was causing some problems with my auto_increment though.

This is a similiar snipplet, just using null for gid and it seems to be the correct way to format if auto_increment is used for an id.

Code:

$addgame = $db->sql_query("INSERT INTO ".$prefix."_league_games VALUES ('null', '$gtitle','$version','$abrev')");

Thanks

Posted: Thu Sep 14, 2006 6:30 am

Yep.... looks good!

:clap: