[RESOLVED] How to select all on a listbox if none are set

[tjbarr]

I have a listbox on page one.
<select name="cbo_display[]" size="6" multiple class="listbox">
<?php

/
Create your SQL statement
/

$sql="SELECT col_name, col_title from tbl_column ORDER by col_title;";
$result_set = pg_Exec ($conn, $sql);
$rows = pg_NumRows($result_set);

if ((!$result_set) || ($rows < 1)) {
//No connection or no rows returned, so print an error
echo "<H1>ERROR - no rows returned</H1><P>";
exit; //exit the script
}

for ($j=0; $j < $rows; $j++) {
echo "<option value=".pg_result($result_set, $j, "col_name")."> ".pg_result($result_set, $j, "col_title")."</option>";
}

?>
</select> </td>
On page 2 I check to see if it isset

if(isset($POST['cbo_display']))
{
$display_ch=$POST['cbo_display'];
$count_ch=count($_POST['cbo_display']);
$strSelectSet='Yes';
}

If nothing is picked on page one how can I send over all the values of the listbox?
I want to select all if nothing is picked.

[kburger]

If nothing is selected, then $_POST['cbo_display'] will be empty on page 2. Nothing you can do about that. But there may be a couple of solutions:

1. if $_POST['cbo_display'] is empty on page 2, page 2 can run the same query to get the values that page 1 ran to generate the options.

2. You can have some hidden fields on page 1 that also contain the list box values. You can ignore them on page 2 unless $_POST['cbo_display'] is empty.

3. There may be a javascript solution that would select them all if the user didn't select anything. But this would have to assume that javascript is enabled - probably not a very safe assumption. Run that validation onSubmit().

[tjbarr]

Thanks