PHP and MYSQL dat selection question

<?php 
$hostname="localhost";
$username="xxx";
$password="xxx";
$dbname="moodybeedb";
$usertable="retailers";
$yourfield = "region";  
mysql_connect($hostname,$username, $password) or die ("CANNOT CONNET TO DATABASE");
mysql_select_db($dbname);   
echo "<form action=\"retailers_delete2.php\" method=\"post\"> 
<select name='Province'>"; 
$sql = "SELECT DISTINCT Province FROM retailers";
$result = mysql_query($sql)or die(mysql_error()); 
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$province = "{$row['Province']}";
echo "<option value='".$province."'>".$province."<br>";
} 
echo "</select><br><br><input type='submit' value='submit'> 
</form>";
?> 
<!-- the code below is the part that isn't working for me right now. I am trying to get it to display the data I want. After I accomplish that, I will want each piece of data displayed with a checkbox attached to it. The eventual plan for this secondary form is that when submitted anything checked will be deleted from the database --> 
<?php 

$hostname="localhost";
$username="xxx";
$password="xxx";
$dbname="moodybeedb";
$usertable="retailers";
$yourfield = "region"; 
$province = "Province"; 
echo "<form>"; 
if($_REQUEST['submit']) {
        
        mysql_connect($hostname,$username, $password) or die ("CANNOT CONNET TO DATABASE");
    mysql_select_db($dbname);  
        $query = "SELECT * from retailers where Province='" . $_REQUEST['Province']. "'";
    $result = mysql_query($query); 
    while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
        print "<pre>";
                print_r($row);
                print "</pre>";
    } 
    mysql_free_result($result);
}  

echo "<br><br><input type='submit' value='Submit'> 
</form>"; 
?> 

--
-- Database: `moodybeedb`
-- 
-- -------------------------------------------------------- 
--
-- Table structure for table `retailers`
-- 
CREATE TABLE `retailers` (
  `id` tinyint(5) NOT NULL auto_increment,
  `Province` varchar(500) NOT NULL,
  `region` varchar(500) NOT NULL,
  `store` varchar(500) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; 
--
-- Dumping data for table `retailers`
-- 
INSERT INTO `retailers` VALUES(1, 'BRITISH COLUMBIA', '100 MILE HOUSE', 'Hight Ground Natural Foods<br>104 Birch Avenue South<br>100 Mile House');
INSERT INTO `retailers` VALUES(2, 'BRITISH COLUMBIA', 'ABBOTSFORD', 'Campbells Gold Honey Farm<br>2595 Lefeuvre Road<br>Abbotsford<br>www.bchoney.com ');
INSERT INTO `retailers` VALUES(3, 'BRITISH COLUMBIA', 'BURNABY', 'Choices In The Park<br>6855 Station Hill Drive<br>Burnaby<br>www.choicesmarket.com/burnaby-park.htm');
INSERT INTO `retailers` VALUES(4, 'BRITISH COLUMBIA', 'BURNABY', 'Choices At The Crest<br>8683 10th Avenue<br>Burnaby<br>www.choicesmarket.com/burnaby-crest.htm ');
INSERT INTO `retailers` VALUES(5, 'BRITISH COLUMBIA', 'BURNABY', 'Natural Focus Foods<br>6536 Hastings Street<br>Burnaby ');
INSERT INTO `retailers` VALUES(6, 'ALBERTA', 'ATHABASCA', 'Bovens Jewelry & Giftware<br>4916A 50 ST<br>Athabasca ');