Export State Data - HELP!

[rusty1001]

HI

 

Help !

 

 

Can anyone help??

 

 

All I want to is export the state field as it is entered by the cutomers..I had issues with maing a drop down list, issues with that

if I set use and they spell the name wrong it defaults to the first state....

 

the field in mysql is a.entry_ state..... for example a.entry_city is fine, why cannot I just do the state as the same I know there is z.zone_name etc which I assume converts the postcode to that name state but if I set it no state in the registration then it does not export that data even though the postcode is there.... customers who entered a state previously does export even though it may be wrong....does this not get the data from the postcode???

 

anyway I need to just export what the customer entered ...that will solve not having to add addons

 

for example if the state is NSW and they spell is N SW or new soth wales it will default the first code ie ACT ..if I could just draw the state from the postcode without them entering a state that also be great..

 

any ideas

 

but use entry_state like entry_city in the mysql query just does not work ???

 

:) help!

 

thanks

 

R

[rusty1001]

HI

 

Help !

Can anyone help??

All I want to is export the state field as it is entered by the cutomers..I had issues with maing a drop down list, issues with that

if I set use and they spell the name wrong it defaults to the first state....

 

the field in mysql is a.entry_ state..... for example a.entry_city is fine, why cannot I just do the state as the same I know there is z.zone_name etc which I assume converts the postcode to that name state but if I set it no state in the registration then it does not export that data even though the postcode is there.... customers who entered a state previously does export even though it may be wrong....does this not get the data from the postcode???

 

anyway I need to just export what the customer entered ...that will solve not having to add addons

 

for example if the state is NSW and they spell is N SW or new soth wales it will default the first code ie ACT ..if I could just draw the state from the postcode without them entering a state that also be great..

 

any ideas

 

but use entry_state like entry_city in the mysql query just does not work ???

 

:) help!

 

thanks

 

R

 

 

I have sort of solved this in another way... I did some tests

 

If a customer enters the wrong state name it creates a drop down list for the states/countries that are in the db with zone codes,

 

the only problem is that if there are two errors and they dont see the drop down box it will be wrong,

 

and if they change the country it does not refresh, how can I make it refresh,,??

 

thanks