[[SETVAR_TOPIC [[U_TO_SP [[$TOPIC]]]]]]
Hotel.Online Classifieds:
[[$TOPIC]]
[[HOTEL_CONNECT]]
[[SETVAR_ADS ""]]
[[# find USA records first]]
[[SQL_QUERY select subject,city,state,country,ident,date from ads where topic='[[$TOPIC]]' and visible='A' and country like 'US%' order by country,state,city,subject]]
[[SQL_LOOP]]
[[SETVAR_ADS "[[$ADS]] [[SQL_FIELD_4]]"]]
[[SETVAR_subject[[SQL_FIELD_4]] [[SQL_FIELD_0]]]]
[[SETVAR_city[[SQL_FIELD_4]] [[SQL_FIELD_1]]]]
[[SETVAR_state[[SQL_FIELD_4]] [[SQL_FIELD_2]]]]
[[SETVAR_country[[SQL_FIELD_4]] [[SQL_FIELD_3]]]]
[[SETVAR_date[[SQL_FIELD_4]] [[SQL_FIELD_5]]]]
[[SQL_END_LOOP]]
[[# now find all other countries]]
[[SQL_QUERY select subject,city,state,country,ident,date from ads where topic='[[$TOPIC]]' and visible='A' and country NOT like 'US%' order by country,state,city,subject]]
[[SQL_LOOP]]
[[SETVAR_ADS "[[$ADS]] [[SQL_FIELD_4]]"]]
[[SETVAR_subject[[SQL_FIELD_4]] [[SQL_FIELD_0]]]]
[[SETVAR_city[[SQL_FIELD_4]] [[SQL_FIELD_1]]]]
[[SETVAR_state[[SQL_FIELD_4]] [[SQL_FIELD_2]]]]
[[SETVAR_country[[SQL_FIELD_4]] [[SQL_FIELD_3]]]]
[[SETVAR_date[[SQL_FIELD_4]] [[SQL_FIELD_5]]]]
[[SQL_END_LOOP]]
[[IF_BLANK [[$ADS]]]]
No ads under this topic.
[[ELSE]]
Click on a subject line to see the full text of the ad.
[[# loop through all retrieved ads]]
[[FOR_EACH X [[$ADS]]]]
[[$country[[$X]]]], [[$state[[$X]]]], [[$city[[$X]]]] -
[[SETARG_adnr [[$X]]]]
[[$subject[[$X]]]] ([[$date[[$X]]]])
[[CLEARARGS]]
[[END_FOR_EACH]]
[[ENDIF]]
[[# possible upgrade: check WANDERID here against DB entry]]
[[SETARG_TOPIC [[SP_TO_U [[$TOPIC]]]]]]
[[CLEARARGS]]
[[NAVIBAR]]