Re: array issues

try html code <input type="text" name="q[]" size="100"> <input type="text" name="a[]" size="100"> php code $values = "'','$interviewed','$interviewer'," for ($i=0; $i<10; $i++) { $qtemp .= "'".q[$i]."',"; $atemp .= "'".a[$i]."',"; } $fields = "id,interviewed,interviewer,q1,q2,q3,q4,q5,q6,q7,q8,q9,q10,a1,a2,a3,a4,a5,a6 ,a7,a8,a9,a10,interview_date"; $query = "INSERT INTO interviews ($fields) VALUES ($values $qtemp $atemp NOW())"; There is probably a better way, but I didnt have any sleep last night and it's probably showing up in my code :) Of course if there is a variable amount of questions and answers they can submit then you would do it a bit differently. The for statement would have something like $i<count($q) for the second arguement and you could dynamically create the $fields variable. Rick > I believe that there is a better way to do what I am trying to > do here. I have an online form to enter interviews into a MySQL db > > right now it is like this > > <input type="text" name="q1" size="100"> > <input type="text" name="a1" size="100"> > > <input type="text" name="q2" size="100"> > <input type="text" name="a2" size="100"> > > etc... each going to their own spot in the table. > > with this > $query = "insert into > interviews(id,interviewed,interviewer,q1,a1,q2,a2,q3,a3,q4,a4,q5,a5,q6,a6,q7 > ,a7,q8,a8,q9,a9,q10,a10,interview_date) > > values('','$interviewed','interviewer','$q1','$a1','$q2','$a2','$q3','$a3',' > > $q4','$a4','$q5','$a5','$q6','$a6','$q7','$a7','$q8','$a8','$q9','$a9','$q10 > ','$a10',NOW())"; > > > I think it would be easier if I could put them into arrays > like this > <input type="text" name="q[]" size="100"> > > I'm just not sure how to go about the insert statement then the retrieval > and formatting for the web. > > any thoughts or advise is appreciated. > > Jerry Lake > Interface Engineering Technician > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >