VERY URGENT

Anon

Hi ! I am developing an application using PHP and Mysql . I am having few problem so i m stuck at this point.

1 - I pick the rows from the DB to update them. I display these rows in a form. This form also contains a Select List with the option to select multiple options. How can I get a value in the list highlighted automatically based on the rows retrieved from the database. Please remember that I am using this select list as an array in the form . so i need to highlight the multiple options as well.
<select name=offerType[] multiple size=3>
2: I want to have some basic user validation for my form data so that it shud check that user entered some data into the mandatory fields & they should not be left blank.

3: I want to check if user selected a value 'Other' in the select list then a text box should be enabled after this..otherwise if user does't select 'Other' from the select list , the text boy should be disabled.

I shall really appreciate your quick reply as i really need these solutions

thanks

Hammad

ingooellers

Hello,
1) hmm. (?)
2) Javascript with clientside validation ? Useful for most cases. Checkout www.javascript.com it's a good resource. Possibly it can solve your problems.
3) -> Javascript:
After onClick-event of the checkbox an
onEnter-Event on the text field puts the cursor via focus-next or so to another field.
Its the same as graying out a field.

Just my 5 E-cents 🙂
regards
Ingo

Anon

One of the possible ways.

Define an array $check[]. As you retrieve the values from the MySQL database,

list($option) = mysql_fetch_row($result) or something
put $check[$option] = 'selected'.
In the list put
$temp = $check[$option];
echo("<option $temp>$option</option>\n");

So effectively for all values that were in the database, a selected will come.

As for the others part, I am still a bit unclear. Do you want the text box to appear/not appear when data is edited or are you talking of the text sent on the form submission

As regards verifying whether fields are filled or not, just check if the particular field has been filled or not.

For the form fields you can do something like

If some field is not filled, include the form again in your script. So the same form will be shown with all the other info filled and a message that some fields are not filled.

If you are still uncertain about this, email me.

Nilesh