Blank Text Box

[bjblackmore]

Hello,
How would I go about adding information in a text if a user puts text in it, but not having it entered if the textbox is blank. I have tried..
if($textbox1){
$sql = "INSERT INTO table(user_id,value1) VALUES '$user_id','$value1')";
$result=mysql_query($sql);
return true;
} else {
return false;
}

This just errors. I have 5 text box, some people will enter 1 of them, some 2, some all etc.
Many Thanks
Ben

[gushy]

Try:

if ($textbox != "") {
// insert you data.
}

-- Nick Gushlow.

[bjblackmore]

OK, i'll give it a try, I have tried the following, but for some reason, it only ever adds 1 record, not 2 can you see why?

function update_table($value1,$option1,$value2,$option2) {
$user_id = mysql_insert_id();
if ($value1) {
$sql1="INSERT INTO table(user_id,value,option) ".
"VALUES ('$user_id','$value1','$option1')";
$result=db_query($sql1);
return true;
} else {
return false;
}
if ($value2) {
$sql2="INSERT INTO table(user_id,value,option) ".
"VALUES ('$user_id','$value2','$option2')";
$result=db_query($sql2);
return true;
} else {
return false;
}
}

Eventually I want to have 5 or 6 values to add!
Cheers
Ben

[gushy]

Not too sure to be honest.

However if you are doing it for a fixed number of boxes I would do something like this:

Name all the boxes in your HTML page value[] (adding [] will automatically stick the values in an array when passed to PHP).

Then in you php file:

for ($i=0;$i==6;$i++) {
if ($value[$i] != "") {
$sql = "INERT INTO table ....";
$result = mysql_query($sql);
if (!$result) {
echo "Error inserting value: ".$i;
exit;
}
}
}

It's not my policy to hand out big chunks of code but you've caught me on a good day. 🙂
Hope it helps.

-- Nick Gushlow.