multiple selections

[pixelsoul]

I have list menu in a form where a user can pick more then one selection but for some reason when I submit it, it only keeps one of the values. Is there a special syntax that I have to use for this to work? the selections are sizes so I made the values S, M, L, XL, 2XL, and so on. All of them have commas after the character incase they pick more then one so they do not look all ran together.

[chyan]

you must using array to submit multiple variables

<select name="size[]" multiple style="font-family: arial; font-size: 10pt size="5">
<option value="s">S</option>
<option value="m">M</option>
<option value="l">L</option>
<option value="xl">XL</option>
<option value="2xl">2XL</option>
</select>

[pixelsoul]

the way I have it is like this right now...

<select name="sizes" size="5" multiple id="sizes">
                <?php
do {  

?>
                <option value="<?php echo $row_sizes['size']?>">
<?php echo $row_sizes['sizename']?></option>
                <?php
} while ($row_sizes = mysql_fetch_assoc($sizes));
  $rows = mysql_num_rows($sizes);
  if($rows > 0) {
      mysql_data_seek($sizes, 0);
	  $row_sizes = mysql_fetch_assoc($sizes);
  }
?>
</select>

I have all of the sizes in a table in sql and I was not sure if that would be the best way to do that. Would it be easier to just do it statically and not get that data from sql?

I am a real noob and have spent a tone of time on this dang project. I probably should have not taken on this project untill I knew more about all of this but it is too late now.

Thanks for the help.

[chyan]

no problem if you want to get the data from your mysql
just add "[]" after the select name

<select name="sizes[]" size="5" multiple id="sizes"> 
                <?php 
do {   

?> 
                <option value="<?php echo $row_sizes['size']?>"> 
<?php echo $row_sizes['sizename']?></option> 
                <?php 
} while ($row_sizes = mysql_fetch_assoc($sizes)); 
  $rows = mysql_num_rows($sizes); 
  if($rows > 0) { 
      mysql_data_seek($sizes, 0); 
      $row_sizes = mysql_fetch_assoc($sizes); 
  } 
?> 
</select> 

after you submit your from you will get output like
sizes[0]='S' sizes[1]='XL' etc

[pixelsoul]

I tried it but when I looked at the info from sql it just said Array

did I miss something?

may be I should just make it manually. The only reason I put the sizes in sql db is incase I ever had to add some kind of advanced search that they could specify the size for what they were looking for.

what do you think?

[chyan]

no, you didnt miss anything

to check that it work correctly
try to echo the variable 'sizes[]' in your destination script
like this ie:

<?
echo $sizes[0]; 
echo $sizes[1];
echo $sizes[2];
echo $sizes[3];
?>
[code=php]

if variable above has a value it will be echoed otherwise just result null value