or download this
$ins = "INSERT INTO `items` (`category`, `itemid`, `price`, `descripti
+on`, `longdescription`, `size`, `o1n`, `o1o`, `o2n`, `o2o`, `o3n`, `o
+3o`, `c1n`, `c1v`, `c2n`, `c2v`, `c3n`, `c3v`, `small`, `large`)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
+?, ?)";
$sth = $dbh->prepare("$ins") or die $dbh->errstr;
$sth->execute(param('cat'),param('itemid'),param('price'),param('des')
+,param('longdes'),param('size'),param('o1n'),param('o1o'),param('o2n'
+),param('o2o'),param('o3n'),param('o3o'),param('c1n'),param('c1v'),pa
+ram('c2n'),param('c2v'),param('c3n'),param('c3v'),param('small'),para
+m('large')) or die $dbh->errstr;