to help troubleshoot, add the following code to the page just before the closing </body> tag:
php:
<?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:
php:
<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:
php:
<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
