Pls help...mind blank.
Posted: Thu Jul 16, 2009 9:12 am
Hey everyone, i'm having trouble inserting into the DB.
This is for a game engine...
Can anyone see whats wrong?...I know this is something simple...lol
This is the DB table...
Thanks in advance
This is for a game engine...
Code: Select all
$insert = sprintf("INSERT INTO heist (crime_type, amount_joined , crimeName , maxmemmbers , minmoney , maxmoney , staff , userid) VALUES (Rob A Local Bank, 1,%s, 10, 1000, 5000 , 2 , %s)", mysql_real_escape_string(htmlentities($_POST['crimeName'])) , $userid);
mysql_query($insert);Code: Select all
`crime_id` int(11) NOT NULL auto_increment,
`crime_type` varchar(255) NOT NULL default '0',
`amount_joined` int(11) NOT NULL default '0',
`crimeName` varchar(255) NOT NULL default 'Defualt',
`maxmembers` int(11) NOT NULL default '10',
`minmoney` int(11) NOT NULL default '0',
`maxmoney` int(11) NOT NULL default '0',
`staff` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL,
KEY `crime_id` (`crime_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;Thanks in advance