Code: Select all
$_POST['item_id_1'] = '9889AA';
$_POST['item_name_1'] = 'steaks';
$i = 1;
$clean['message_id'] = 1234;
$clean['item_name_' . $i] = escape_data($_POST['item_name_' . $i]);
$clean['item_id_' . $i] = escape_data($_POST['item_id_' . $i]);
$query = "INSERT INTO ins_system (message_id, item_name, item_id) VALUES ({$clean['message_id']}, '{$clean['item_name_".$i."']}', {$clean['item_id_".$i."']})";Code: Select all
echo $query;INSERT INTO ins_system (message_id, item_name, item_id) VALUES (5, '', )
Any help is greatly appreciated.