order_info.php minor html problems

[jonnyl]

Sorry if these are dumb questions, coudln't find specific answers..

I have only one country in my list>>Canada.

When someone choses it from order_info.php it clears the email address...anyway around that? That doesn't happen in create account.

Also, if they click back on 'Please Select', not that they would, they get this error:

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by zone_name' at line 1

select zone_name from zones where zone_country_id = order by zone_name

[TEP STOP]

I'm assuming cause there isn't a zone named 'Please Select'.

So...
How can i fix this?

These things aren't happening on create account pages.

Thanks

[jpf]

First of all I would check the PHP files to make sure any editing done/FTPed up - did not muck up the file.

Next - HOW did you get to have Canada only (from MAX's Admin or using a back end tool)? Restore atlease US and try again. AND/OR check your "default" language and country in ENGLISH.PHP files and in the MAX's admin panel.

Is is not because of "Please Select". But a lack of a matching country.

Backup is your friend - restore a full copy and then do your editing - when you find an error - ether compare to prior backup copy - or do a restore and then carefully redo your editing untill you isloate your bug.

[jonnyl]

well i don't think it's an ascii/binary FTP upload problem.. i deleted all the other countries cause i currently cannot ship to anywhere other than canada legally and wanted to forcibly block other countries from going in on orders...
so i manually deleted the other countries.

The create account page with the same situation backend country wise is working nominally, but not sure why it's doing it on the checkou without account page...

is there a way for me to block the rolling back onto "please select" from calling a jump menu action?

i can't add another country for the reason i mentioned above.

also do you know by chance how to block the email entry from resetting to blank like all the other fields do when they select the country from the dropdown menu which is generally after they've entered that info..it's working properly like the other isse on the create account page but not on the checkout without account page.

Your help is appreciated.