Need a more efficient query than this

[php]
$1=mysql_real_escape_string($_POST[‘1’]);
$2=mysql_real_escape_string($_POST[‘2’]);
$3=mysql_real_escape_string($_POST[‘3’]);
$4=mysql_real_escape_string($_POST[‘4’]);
$5=mysql_real_escape_string($_POST[‘5’]);
$6=mysql_real_escape_string($_POST[‘6’]);
$7=mysql_real_escape_string($_POST[‘7’]);
$8=mysql_real_escape_string($_POST[‘8’]);
$9=mysql_real_escape_string($_POST[‘9’]);
$10=mysql_real_escape_string($_POST[‘10’]);
$11=mysql_real_escape_string($_POST[‘11’]);
$12=mysql_real_escape_string($_POST[‘12’]);
$13=mysql_real_escape_string($_POST[‘13’]);
$14=mysql_real_escape_string($_POST[‘14’]);
$15=mysql_real_escape_string($_POST[‘15’]);
$16=mysql_real_escape_string($_POST[‘16’]);
$17=mysql_real_escape_string($_POST[‘17’]);
$18=mysql_real_escape_string($_POST[‘18’]);
$19=mysql_real_escape_string($_POST[‘19’]);
$20=mysql_real_escape_string($_POST[‘20’]);
$21=mysql_real_escape_string($_POST[‘21’]);
$22=mysql_real_escape_string($_POST[‘22’]);
$23=mysql_real_escape_string($_POST[‘23’]);
$24=mysql_real_escape_string($_POST[‘24’]);
$25=mysql_real_escape_string($_POST[‘25’]);
$26=mysql_real_escape_string($_POST[‘26’]);
$27=mysql_real_escape_string($_POST[‘27’]);
$28=mysql_real_escape_string($_POST[‘28’]);
$29=mysql_real_escape_string($_POST[‘29’]);
$30=mysql_real_escape_string($_POST[‘30’]);
$31=mysql_real_escape_string($_POST[‘31’]);
$32=mysql_real_escape_string($_POST[‘32’]);
$33=mysql_real_escape_string($_POST[‘33’]);
$34=mysql_real_escape_string($_POST[‘34’]);
$35=mysql_real_escape_string($_POST[‘35’]);
$36=mysql_real_escape_string($_POST[‘36’]);
$37=mysql_real_escape_string($_POST[‘37’]);
$38=mysql_real_escape_string($_POST[‘38’]);
$39=mysql_real_escape_string($_POST[‘39’]);
$40=mysql_real_escape_string($_POST[‘40’]);
$41=mysql_real_escape_string($_POST[‘41’]);
$42=mysql_real_escape_string($_POST[‘42’]);
$43=mysql_real_escape_string($_POST[‘43’]);
$44=mysql_real_escape_string($_POST[‘44’]);
$45=mysql_real_escape_string($_POST[‘45’]);

INSERT INTO home.form (id, name, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45) VALUES (NULL, ‘plintu’, ‘$1’, ‘$2’, ‘$3’, ‘$4’, ‘$5’, ‘$6’, ‘$7’, ‘$8’, ‘$9’, ‘$10’, ‘$11’, ‘$12’, ‘$13’, ‘$14’, ‘$15’, ‘$16’, ‘$17’, ‘$18’, ‘$19’, ‘$20’, ‘$21’, ‘$22’, ‘$23’, ‘$24’, ‘$25’, ‘$26’, ‘$27’, ‘$28’, ‘$29’, ‘$30’, ‘$31’, ‘$32’, ‘$33’, ‘$34’, ‘$35’, ‘$36’, ‘$37’, ‘$38’, ‘$39’, ‘$40’, ‘$41’, ‘$42’, ‘$43’, ‘$44’, ‘$45’);[/php]
I am certain there is a way to do it like with a foreach statement but I suck at efficiency :smiley:

[php]$i = 1;
for ($i=1; $i<=45; $i++) {
$i=mysql_real_escape_string($_POST[$i]);
}
INSERT INTO home.form (id, name, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45) VALUES (NULL, ‘plintu’, ‘$1’, ‘$2’, ‘$3’, ‘$4’, ‘$5’, ‘$6’, ‘$7’, ‘$8’, ‘$9’, ‘$10’, ‘$11’, ‘$12’, ‘$13’, ‘$14’, ‘$15’, ‘$16’, ‘$17’, ‘$18’, ‘$19’, ‘$20’, ‘$21’, ‘$22’, ‘$23’, ‘$24’, ‘$25’, ‘$26’, ‘$27’, ‘$28’, ‘$29’, ‘$30’, ‘$31’, ‘$32’, ‘$33’, ‘$34’, ‘$35’, ‘$36’, ‘$37’, ‘$38’, ‘$39’, ‘$40’, ‘$41’, ‘$42’, ‘$43’, ‘$44’, ‘$45’);[/php]

Thank you! I can write just about anything in php but I am not to good with efficiency, you are awesome! as soon as I figure out how to give you a +1 on the karma I will!!! :smiley:

Sponsor our Newsletter | Privacy Policy | Terms of Service