[franches]

PHP Code:

<p><select class=select size="120" name="VwRc" style="width: 780; height: 250; FONT-FAMILY: Lucida Console, Courier New; FONT-SIZE: x-small;" LANGUAGE="javascript" onchange="return VwRc_onchange()">

<?    while ($rsTable=mysql_fetch_array($rs))



echo "<option>".AppendSpace($rsTable["ActId"],8), AppendSpace($rsTable["ActDate"],12)  ?>

</option>

</select>

this is my code. the data displays on my select box properly. as you will notice i am putting the data from 2 fields in my table in a row of my select box. i have in my form 2 textbox (ID, Date) to check if the data selected from the select box is being displayed. however, if I select something there is no data being displayed in my 2 textbox. I think the option should have a value such as echo "<option value=(this is where my problem starts)>".AppendSpace...

i really don't know what to do anymore. pls help me.



I also tried but nothing is displayed in my selectbox:

PHP Code:

<option value="<? echo $rsTable['ActId'];?>,<? echo $rsTable['ActDate'];?>">&nbsp;&nbsp;<?echo AppendSpace($rsTable["ActId"],8)?>&nbsp;<? echo AppendSpace($rsTable["ActDate"],12)?>

what should be my code then?

hope someone here could help me.

[moronovich]

hello franches,
your way:

PHP Code:

<option value="<? echo $rsTable['ActId'];?>,<? echo $rsTable['ActDate'];?>">&nbsp;&nbsp;<?echo AppendSpace($rsTable["ActId"],8)?>&nbsp;<? echo AppendSpace($rsTable["ActDate"],12)?>

is not common since you use double identifiers for single option. since the option derives from the same row, you can just set the value into the ActId and then check it using your "VwRc_onchange()"

[franches]

i have attached my file. hope you have the time to examine it. i have difficulty on how to explain it but i know if you'll be able to see my code you'll know what's my problem.

FilterView.php contains only parts of the code related to my problem. My problem now with my code is the data being displayed inside my select box is only the 1st data of the month. Currently there are five data in my database and only 1 data is displayed which is 2 2004-11-02. second, when i select that data in my pass.ActId box, the data displayed is 2 2004-11-02 which is supposedly it will display 2 and in my pass.ActDate the data displayed is 11 only which should be 2004-11-02. hope you understand my problem.
thank you very much. i am hoping for your response.

[moronovich]

hello franches,
did you mean this one?

PHP Code:

//File Filter.php

<?    while ($rsTable=mysql_fetch_array($rs))



 $val = AppendSpace($rsTable['ActId'],8) . '' . AppendSpace($rsTable['ActDate'],12);

   echo '<option value="'. $val .'">'. $val . '</option>';

?>

it should be

PHP Code:

<?    while ($rsTable=mysql_fetch_array($rs)) {



 $val = AppendSpace($rsTable['ActId'],8) . '' . AppendSpace($rsTable['ActDate'],12);

   echo '<option value="'. $val .'">'. $val . '</option>';

  }

?>

and

PHP Code:

//File FilterOnLoad2.php

<?    while ($rsTable=mysql_fetch_array($rs))



 $val = AppendSpace($rsTable['ActId'],8) . '' . AppendSpace($rsTable['ActDate'],12);

   echo '<option value="'. $val .'">'. $val . '</option>';

?>

should be

PHP Code:

<?    while ($rsTable=mysql_fetch_array($rs)) {



 $val = AppendSpace($rsTable['ActId'],8) . '' . AppendSpace($rsTable['ActDate'],12);

   echo '<option value="'. $val .'">'. $val . '</option>';

}

?>

regards,

[franches]

thanks all data are now displaying but if I select something all the data are being displayed at my pass.ActId box and xxx is being displayed at pass.ActDate. so I noticed that

i forgot something in

PHP Code:

//File FilterOnLoad2.php 

<?    while ($rsTable=mysql_fetch_array($rs)) 

{

$val = AppendSpace($rsTable['ActId'],8) . '' . AppendSpace($rsTable['ActDate'],12); 

   echo '<option value="'. $val .'">'. $val . '</option>'; }

?>

there should be ',' comma in between the appendspace

PHP Code:

//File FilterOnLoad2.php 

<?    while ($rsTable=mysql_fetch_array($rs)) 

{

$val = AppendSpace($rsTable['ActId'],8) . ' , ' . AppendSpace($rsTable['ActDate'],12); 

   echo '<option value="'. $val .'">'. $val . '</option>'; }

?>

with this code it's now working and if I select something only the 2 which is the ActId is displayed in my pass.ActId and 2004-11-02 is displayed in my pass.ActDate. HOWEVER, in my select box the comma is also being displayed which is not nice to look at. in my select box this is what you will see. what will I do with the comma? i really need your help.

PHP Code:

4         ,2004-11-06

3         ,2004-11-02

2         ,2004-11-01 

[moronovich]

you can simply rewrite it as:

PHP Code:

//File FilterOnLoad2.php 

<?    while ($rsTable=mysql_fetch_array($rs)) 

{ 

$val = AppendSpace($rsTable['ActId'],8) . ' , ' . AppendSpace($rsTable['ActDate'],12); 

   echo '<option value="'. $val .'">'. $rsTable['ACtDate']. '</option>'; } 

?>

regards,

edit:
$rsTable['ACtDate'] is a typo, so you should write $rsTable['ActDate'] instead

[franches]

PHP Code:

//File FilterOnLoad2.php 

<?    while ($rsTable=mysql_fetch_array($rs)) 

{ 

$val = AppendSpace($rsTable['ActId'],8) . ' , ' . AppendSpace($rsTable['ActDate'],12); 

   echo '<option value="'. $val .'">'. $rsTable['ACtDate']. '</option>'; } 

?>

doing this code would only dispaly on my select box the dates but I still need to display the ActId and some other data such as PrjCode, ActCode and MapNumber since these are data inputed by the user. That's my problem right now and stuck with it. Hoping for your response again. Thanks.