dynamic list box

lukeurtnowski

ok, im trying to make a select box (list box) so that its size is dynamic (depending on the amount or records of a given field (medivas), so I can make multiple selections from it. This is what I have soo far..

<?php
	echo "<SELECT NAME=poc SIZE=".$records.">";
?>

and this would be my query to get $records..
select DISTINCT COUNT(medivas) as records from company;
What is wrong with either?
Thanks😕

bradgrafelman

Err... the size attribute of the SELECT element has nothing to do with number of options to have... it only specifies width (from left to right). If you leave it out, the width will be auto-adjusted.

lukeurtnowski

Oh reaally? What do you recommend I use in my form to create a dynamic list which allows multiple selections (list box). Then what would you use in your query in order to grab that dynamic list? (in order to COUNT() the number of fields returned.
SELECT COUNT(medivas) from ...

bradgrafelman

Dont use count() at all. Just start echoing the '<option>' tags...

    echo "<SELECT NAME='poc'>";

$query = 'SELECT medivas as records, column2 as alias2, etc as so_on FROM comany';
$exec = mysql_query($query) or die(mysql_error());

while($result = mysql_fetch_assoc($exec) {

   echo '<option value="'.$result['aliasName'].'">'.$result['records']."</option\n";

}

and so on. You'll have to modify the query/alias names to fit whatever data you're pulling, but that's the basic idea.

lukeurtnowski

thanks a lot

lukeurtnowski

ok, that worked. But i'm trying to make the list box so that it does not have a pull down area on the right so that I can make more than 1 selection from the list

thorpe

echo "<select name='poc' multiple>";

notice no capitols? they will not validate.

lukeurtnowski

OK, now that I expanded the list box (or you did) I can still only make one selection at a time, is there a way to allow for multiple selections?
Thanks, heres my code

echo "<select name='poc' multiple>";
	while($result2 = mysql_fetch_assoc($query2)) { 
	printf('<option value="'.$result2['medivas'].'">'.$result2['medivas'] . '</option>'); 
			}
	echo "</SELECT>";

bradgrafelman

EDIT: Easiest way would be to give it a size so you can see all of the options, like so:

  echo "<select name='poc' size='" . mysql_num_rows($query2) . "' multiple>";

EDIT2: Might want to make your ending SELECT entity lowercase for validation purposes.

lukeurtnowski

ok, that worked!
But is there a way to make more than one selection at a time without using the ctrl or shift button?

bradgrafelman

Click and drag? Other than that, I don't believe so. If you're looking for an easy way to select multiple entries, perhaps you should use checkboxes?