[eluser]alvaroeesti[/eluser]
Thank you very much for your posting. They are good ideas.
I have been working all day on it and have gotten far. I did not treat the sanitation issue but I will after what you write. With regards to
the second issue, I did that but it was very complex. I was thinking about posting the full solution but I can tell you how I went because I think there could be an easier way.
I first did a print_r to see the kind of array I was getting from the View and it was a multidimensional array. This multidimensional
array was unpredictable in size as people could chose one or several cities. Therefore I looked up a php function that can
make a recursion to tell the length of the columns of this bidimensional array.
Once I had the columns I knew how many loops I needed to do inside the body of the function. I would also use the expression
$city = $cities[ ][ ] to use the scalar variable and I would just put it in the where clause as usual.
So that worked out. I haven't still gotten busy with the session issue now that I have the multidimensional array but it should be
about the same. Will be working on it the next days..
If you are interested in seeing the full solution just send me a pm and I will post it as soon as I get it (or come close to get it)
regards and thank you