if customer's state = alabama, show them a message on the next page

[Guest]

i'm sure this is ridiculously simple, but i cannot figure it out.

 

 

once a user gets past the "create_account.php" page, can i add a filter to see if their state is alabama or georgia, and if it is, display a phrase at the top of the next page?

[dave111]

Add this where you want the message to display:

 

<?php
$query = mysql_query("SELECT entry_state FROM address_book WHERE address_book_id = '".$_SESSION['customer_default_address_id'].'" AND customers_id = '".$_SESSION['customer_id']."'");
$result = mysql_fetch_array($query);

// Check in lower case to avoid case differences
if(strtolower($result['entry_state']) == 'alabama' || strtolower($result['entry_state']) == 'al'){
echo 'Hey Your From Alabama!!';
}

?>

[Guest]

$customer_zone_id is registered in the session - you can get the state from this

 

 

Sonia

[crash3903]

.