Processing a web form / loop etc.
| From: | PHP) | Date: | Tue, 30 May 2006 21:37:04 +0000 |
| Subject: | Processing a web form / loop etc. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-41950@lists.php.net to get a copy of this message | ||
I have a web form that accepts up to 3 suggested categories. In the
form they are part of I have named these variables
$suggested_category_1
$suggested_category_2
$suggested_category_3
I have come up with this simple code to store the suggestion in a table:
if ( $suggested_category_1 <> "" ) {
#the user could leave the suggestion blank because what is already
provided is sufficient
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "INSERT INTO table_name VALUES ( '$variable' ,
'$reference_number', '$suggested_category_1')";
mysql_query($query);
mysql_close();
}
Is there any way to create a loop to check all three instead of me
repeating this code twice more changing $suggested_category_1 to _2 and
_3 ?
Ron