PHP Coding Help

mattyt81

I have two html multi list boxes side by side, in the left box which has an ID of venueFrom I have the options (<option></option>).

The right box which has an ID of venue is blank.

I am using javascript to move selections from (venueFrom) to (venue) which works fine.

When I hit submit the selections get submitted to mysql table and are stored in the relevant field which is venue.

The problem I can't seem to fix is keeping the selected data in the (venue) multi list box after it has been submitted.

I have tried various bits of code they I have written and other people have suggested but it doesn't work.

I am currently at work so unable to paste all the code, but I think there should be enough information here.

The field in mysql table that (venue) is being stored in, is a text field, I don't think this should matter, but I am not a PHP expert.

Any help will be appreciated as its someonthing I should have sorted out myself by now, ut just can't crack it!

johanafm

mattyt81;10988843 wrote:
I am using javascript to move selections from (venueFrom) to (venue) which works fine.

Do you select the options in venue after they have been "moved" from the other select box? That is, do you set option.selected=true for all of them? And is there a reason for not letting the user select multiple options in the first select box, rather than move them from one box to the next?

mattyt81;10988843 wrote:
When I hit submit the selections get submitted to mysql table and are stored in the relevant field which is venue.

Do you really get this information stored?

mattyt81;10988843 wrote:
The problem I can't seem to fix is keeping the selected data in the (venue) multi list box after it has been submitted.

The reason I've asked the questions above is because I see no reason why you should not be able to pre-fill this select box if you do have the relevant data. After all, you were able to pre-fill the other select box.

mattyt81;10988843 wrote:
I have tried various bits of code they I have written and other people have suggested but it doesn't work.

Have you tried using the exact same code you use to pre-fill the first select box, except using data from another source, namely where you've stored this venue information.

mattyt81;10988843 wrote:
The field in mysql table that (venue) is being stored in, is a text field, I don't think this should matter, but I am not a PHP expert.

If you are storing it as a comma separated list, then it really does matter. But not because you aren't using the proper data type (which you aren't if you want to store integers), but because this means your db schema isn't normalized. You should put this information in another table, having the primary key from your present table as one field and a value field storing a (one single) value of the venues as the second field. The primary key for this table would be (other_table_id, venue_value), and it would have FOREIGN KEY (other_table_id) REFERENCES other_table(id).

dylanmhulderman

Use the $_SESSION variable to store data so that you can save it to the box...

<?php session_start(); ?>

At the beginning of every php page...