How to put more than one entry into a field?

pp4sale

Is it possible to have more than one entry into a field? For example at the moment users can select a category using the code below. I want to allow them to select several categories and for these all to be entered into the field. Is this possible or will i have to set up separate fields for each category?


	$result=MySQLQuery("select * from links_cat where id !=0 order by name",$QueryError_Email,$QueryError_Browser);
	while($row=mysql_fetch_array($result))
	{
		$cat_id=$row["id"];
		$cat_name=$row["name"];
		echo "<option value=\"$cat_id\"> $cat_name</option>";
	}

Thanks!!

bradgrafelman

Are you saying you want them to be able to POST the form with more than one category selected?

If so, add multiple="true" to your SELECT entity and add '[]' to the end of its name, e.g.

<select name="cat[]" multiple="true">

Then, in your processing script, you'd loop through their choices:

foreach($_POST['cat'] as $cat) {

pp4sale

Thanks, that's exactly what I'm trying to do. However, it still only puts in one value in?

select name="cat_id"[] multiple="true">
<option value="">Select a Category</option>
<?php
		$result=MySQLQuery("select * from links_cat where id !=0 order by name",$QueryError_Email,$QueryError_Browser);
		while($row=mysql_fetch_array($result))
		{
			$cat_id=$row["id"];
			$cat_name=$row["name"];
			echo "<option value=\"$cat_id\"> $cat_name</option>";
		}
?>

<?php
	}
	else if($ax=="insert")
	{
		$country=$_POST["country"];
		$county=$_POST["county"];
		foreach($_POST['cat_id'] as $cat_id); 
		if($admin_approved=="no")
		{$approved="no";
		}
		else
		{$approved="yes";
		}
$result=MySQLQuery("insert into links country,county,cat_id) values ('$country','$county','$cat_id')",$QueryError_Email,$QueryError_Browser);

Joseph07

foreach isn't used it this way. I suggest you to look at php.net for more references on how you can use foreach.

You did not get the variables from foreach and yet you wanted to insert to the database. It would not work for sure.

foyer

yeah, what is this $admin_approved variable?

pp4sale

Would it be easier to set it up so that each variable has it's own field in the database?

bradgrafelman

name="cat_id"[]

That's not what I suggested (nor is that valid HTML syntax); the '[]' should be a part of the name.