Create Account Feature, missing State field

[rose1212]

Hi,

How can I add the state field to my Create Account located at: http://www.roseysmall.com/catalog/create_account.php I don't know where to find this and I'm afraid to mess it up if I touch it (like a few other things I've broken).

Thank you, yet again, for your help.

Rose

[ozcsys]

Originally Posted by rose1212

Hi,

How can I add the state field to my Create Account located at: http://www.roseysmall.com/catalog/create_account.php I don't know where to find this and I'm afraid to mess it up if I touch it (like a few other things I've broken).

Thank you, yet again, for your help.

Rose

I just did this a couple of weeks ago and while I do not remember exactly what I changed I am pretty sure it was this part of the code:


if (ACCOUNT_STATE == 'true') {
$zone_id = 0;
$check_query = tep_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "'");
$check = tep_db_fetch_array($check_query);
$entry_state_has_zones = ($check['total'] > 0);
if ($entry_state_has_zones == true) {
$zone_query = tep_db_query("select distinct zone_id from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' and (zone_name like '" . tep_db_input($state) . "%' or zone_code like '%" . tep_db_input($state) . "%')");
if (tep_db_num_rows($zone_query) == 1) {
$zone = tep_db_fetch_array($zone_query);
$zone_id = $zone['zone_id'];
} else {
$error = true;

to this:

if (ACCOUNT_STATE == 'true') {
$zone_id = 0;
$check_query = tep_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = '223" . (int)$country . "'");
$check = tep_db_fetch_array($check_query);
$entry_state_has_zones = ($check['total'] > 0);
if ($entry_state_has_zones == true) {
$zone_query = tep_db_query("select distinct zone_id from " . TABLE_ZONES . " where zone_country_id = '223" . (int)$country . "' and (zone_name like '" . tep_db_input($state) . "%' or zone_code like '%" . tep_db_input($state) . "%')");
if (tep_db_num_rows($zone_query) == 1) {
$zone = tep_db_fetch_array($zone_query);
$zone_id = $zone['zone_id'];
} else {
$error = true;



You can also find a good thread on the topic at:

http://forums.oscommerce.com/index.php?showtopic=53879

Hope this helps

Richard