arrays---Submit

tjbarr

Two questions about the following code. First Array problems.
I fill a select box from the database, but only the reg_name is showing up in the box. Am I storing or calling these wrong? Also how do I get the second cbostate listbox to come up from the choice selected on the first box? Is submit the wrong option?

FORM METHOD="LINK" ACTION="1.php">
<b>
<h2>Economic Indicators</h2>
</b>

<p align="left">Please select the regional unit of your interest: <br>
<select name="cboregion[$reg_id, $reg_name]" size="6" multiple class="listbox">
<?php

/
Create your SQL statement
/

$sql="SELECT reg_id, reg_name from tbl_regions;";
$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, "reg_id")."> ".pg_result($result_set, $j, "reg_name")."</option>";
}

?>
</select>

     <?  $reg_ch=$_GET['cboregion'];  ?>

<? if(isset($_POST['reg_ch'])==2) { ?>
<p align="left">Please select the States of your interest: <br>
<select name="cbostate" size="auto" multiple class="listbox">
<?php

/
Create your SQL statement
/

$sql="SELECT fip_code, fip_name from tbl_fip_codes WHERE area_id =2;";
$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, "fip_code")."> ".pg_result($result_set, $j, "fip_name")."</option>";
} }

?>
</select>

herve

Hi,

well this line :

echo "<option value=".pg_result($result_set, $j, "reg_id")."> ".pg_result($result_set, $j,
"reg_name")."</option>";

basically, it means that the list is composed of
"reg_name" value, so I have a list of region's
name ; and that I send back a numerical id
"reg_id" to the script.

1 Washington
2 New York

I have Washington & New York in my list
and when I choose, it send back "1" or "2"
to the script.

That's what your line is supposed to do.

Is that correct for you ?

For your second question, you need to output
different things depending where you are
in your web site.

Basically :

if ($PLACE == "FirstPlace")
{
print data for first "page"
which is an HTML form
and you set a hidden arg, like this :

<INPUT TYPE="HIDDEN" NAME="PLACE" VALUE="SecondPlace">

which mean where do you want to go after

this script is completed, here at the second page
}
else if ($PLACE =="SecondPlace")
{
print data for the second "page"
those data depending of value(s)
transmitted by the first page
}

Hervé.