"; // $db = mysql_connect('208.56.42.193', 'movespot', 'movespot'); mysql_select_db('movingspot_com',$db); $result = mysql_query("SELECT CityName, State FROM 1290LargestCities where Population > 100000 order by Population DESC",$db); // $State=""; while($myrow2 = mysql_fetch_array($result)) { // $CityPart=str_replace(" ","_",$myrow2[0]); $CityPart=urlencode($myrow2[0]); $StatePart=urlencode($myrow2[1]); $cityurl = "http://www.movingspot.com/FreeMovingQuotes.html?City=" . $CityPart . "&State=" . $StatePart; echo "$myrow2[0], $myrow2[1] - "; } ?>
"; mysql_select_db('movingspot_com',$db); $result = mysql_query("SELECT CityName, State FROM 1290LargestCities where Population > 100000 order by Population DESC",$db); // $State=""; while($myrow2 = mysql_fetch_array($result)) { //$CityPart=str_replace(" ","+",$myrow2[0]); $CityPart=urlencode($myrow2[0]); $StatePart=urlencode($myrow2[1]); $cityurl = "http://www.movespot.com/CitiesQuoteInfo.html?City=" . $CityPart . "&State=" . $StatePart; echo "$myrow2[0], $myrow2[1] - "; } ?>