Code: Select all
<?
$sql = "SELECT `State` FROM `citystatecountry` WHERE `Country` = 'USA' ORDER BY `State` ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)){
echo $row['State'].'<br />';
}
?>Moderator: General Moderators
Code: Select all
<?
$sql = "SELECT `State` FROM `citystatecountry` WHERE `Country` = 'USA' ORDER BY `State` ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)){
echo $row['State'].'<br />';
}
?>Code: Select all
SELECT DISTINCT `State` FROM `citystatecountry` WHERE `Country` = 'USA' ORDER BY `State` ASC