Checkout Dynamic drop down list not working

I am customizing my cart. Basically what is happening is that this cart is in a support section of my site for specific people to use. The checkout form is populated automatically from the session variables created at login. All the text entry fields work fine but when i comes to creating a drop down list connected to the information already in the database it will not recognize the current value which in this case is province = BC.

Any ideas?

Here is the code for the drop down box ...

<select name="state_province" id="state_province" title="<?php echo $row_rsUSERNAME['DealerProv']; ?>">
<option value="" <?php if (!(strcmp("", $row_rsUSERNAME['DealerProv']))) {echo "selected=\"selected\"";} ?>>Chose a Province</option>
<?php
do {
?>
<option value="<?php echo $row_rsPROVINCE['ProvAbbrev']?>"<?php if (!(strcmp($row_rsPROVINCE['ProvAbbrev'], $row_rsUSERNAME['DealerProv']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rsPROVINCE['ProvName']?></option>
<?php
} while ($row_rsPROVINCE = mysql_fetch_assoc($rsPROVINCE));
$rows = mysql_num_rows($rsPROVINCE);
if($rows > 0) {
mysql_data_seek($rsPROVINCE, 0);
$row_rsPROVINCE = mysql_fetch_assoc($rsPROVINCE);
}
?>
</select>

I know the information is being passed to the page from tests done. I have also attached the checkout page as it sits now.

Thank you for your help.

Further to the above I tested the dynamic drop down in IE and Firefox on my computer and it didn't work. yet on anothe rcomputer in teh office it works fine. I would say it is a setting on my browser but the dynamic menues in the insert and update pages work fine.

to help troubleshoot, add the following code to the page just before the closing </body> tag:

<?php

echo("SQL :".$query_rsUSERNAME."<br />TotalRows ".$totalRows_rsUSERNAME."<br />");

echo("<pre>");

var_dump($_SESSION);

echo("</pre>");

?>

this will give us some information about the recordset to help troubleshoot why it is not working.



also, change the code for the option:

<option value="<?php echo $row_rsPROVINCE['ProvAbbrev']?>"<?php if (!(strcmp($row_rsPROVINCE['ProvAbbrev'], $row_rsUSERNAME['DealerProv']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rsPROVINCE['ProvName']?></option>

to:

<option value="<?php echo $row_rsPROVINCE['ProvAbbrev']?>"<?php if (!(strcmp($row_rsPROVINCE['ProvAbbrev'], $row_rsUSERNAME['DealerProv']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rsPROVINCE['ProvName']?>||User:<?php echo $row_rsUSERNAME['DealerProv']?>||Abbr:<?php echo $row_rsPROVINCE['ProvAbbrev']?></option>

this will show the rsUSERNAME['DealerProv'] value and rsPROVINCE['ProvAbbrev'] value in the select list next to the providence name

So I added the code you had indicated. In the drop down and all the options are there as you have expected: ex. British Columbia ||User:BC |Abbr:BC

On the right side of the page this code shows up. (note I changed my password so that is it not posted online.)

SQL :SELECT * FROM entry WHERE Password = 'Changed so my password is not noted online' AND Name = 'ron'
TotalRows 1

array(9) {
["user_name"]=>
string(3) "ron"
["pass_word"]=>
string(8) "Changed so my password is not noted online"
["MM_Username"]=>
string(3) "ron"
["MM_UserGroup"]=>
string(0) ""
["DealerNumber"]=>
string(5) "11860"
["passwordnew"]=>
string(8) "toyocana"
["WADbSearch1_Results"]=>
string(29) " AND ((ItemCatID LIKE '%2%'))"
["ToyoeCart_Items"]=>
string(157) "8|WAECART|BFEXAS|WAECART|Extensa AS|WAECART|BFEXAS.jpg|WAECART|0|WAECART|1|WAECART|0|WAECART|100|WAECART|Extensa AS |WAECART|0|WAECART|0|WAECART|1 BFEXAS (8)"
["WAEC_ContinueRedirect"]=>
string(32) "/support/POP/Detail.php?ItemID=8"
}

Now I know the Province Abreviation is transfering because I can drop :
<?php echo $row_rsUSERNAME['DealerProv']; ?>
anywhere on teh page and it shows up. For some reason on my browsers the drop down does not see it.

Further to this I have vied the site on two other computers now and it works fine on them. This does mean that the error could show up on other computers but why would it work on those computers and not on mine where the file is created? We are all using IE8 with the exception of my computer also having Firefox.

the results you have posted here, are those from a computer where this list is or is not working correctly?

I need to see the results from a computer where you are experiencing the problem.


the recordset that returns the logged in users province relies on session variables. It may be that the computer where you are having the problem has cookies turned off, or is refusing to set the cookie for your domain.

Try clearing all cookies and double check that the browser has cookies enabled.

No this is from the computer where the dynamic drop down is NOT working.

did you read and try the rest of my reply?

the recordset that returns the logged in users province relies on session variables. It may be that the computer where you are having the problem has cookies turned off, or is refusing to set the cookie for your domain.

Try clearing all cookies and double check that the browser has cookies enabled.

Sorry I should have been a little clearer; Yes, I did clear cookies and check if the browser accepts cookies. The entire support site works with cookies and hasn't had issues before and as mentioned the dynamic menus on the same computer and browser. I even tried lowering the security setting to low to allow all cookies etc. with no positive results. I tried deleting the current drop down and inserting a new one. As far as I can tell there should be no problem with cookies.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Any idea when I will get a call on this?

I will try calling tomorrow regarding this issue.