Dropdown Menus 'selected="selected"'

[nhawk]

There is something you should know..

After you parse through the data returned by getCountries once, you can't parse the same query results a second time. The pointers are already set to the end of the data after the first while { } loop and the pointer either needs to be reset or the data stored in an array for future use during the first parse.

[Iain M]

Thanks Kevin

PHP Code:

$countryOptions = ''; 


after the render worked.

Thank you nhawk for that explanation =]

[nhawk]

Originally Posted by kh99

But you're getting a list of services, each with a list of countries, so it has to be doing both loops, right? It seems like it's just the test for the selected one that isn't working.

Oh, I think I know - you have to repeat the 'countries' query each time. Try putting

PHP Code:

$db->data_seek($getCountries, 0); 


right after the 'editservicebit' template render.

LOL, it's too early. KH99 already caught that here

I need.... more.... coffee

[kh99]

Originally Posted by nhawk

LOL, it's too early. KH99 already caught that here

I need.... more.... coffee

Yeah, but I'm slightly embarrassed that I didn't notice that right off. To be honest I didn't even know that you could get the results of two queries at the same time like that.

[Marco64Th]

A static list like the countries should really just go into the datastore as a serialized array. Just 1 time read them from the datastore (using the standard vB functions) into the $vbulletin object and you're done.

[Iain M]

I will look into using the datastore. Thank you Marco.