Input Form Problem

harris97

i've small problem with php and mysql and need some help to all of you guys.
Let say i have several input type like this:

$i=0;
while ($i != 5) :
<input type="text" name="question<%=$i">
$i++;
endwhile;
SubmitButtonHere

i'd like to insert all input field (questoin1, question2..etc) to MySql database. but the problem is how to insert filled data only into database and blank/null data will not be inserted. this is my logic :
if (question$i == "") { don't insert to db }
else { insert all filled data to database }

i don't know how to build that query?
any help would be appreciated. Thanks Alot

Anon

Although everyone has their own coding practices, this should clean you up a bit and give you just what you need.

For building form entries:

for($i = 0; $i < 5; $i++)
{
  echo "<input type=\"text\" name=\"question$i\">";
}

For updates:

for($i = 0; $i < 5; $i++)
{
  if(strlen($HTTP_POST_VARS["question$i"]) > 0)
  {
    // update your database
  }
}

G'luck,

Jack