'.PHP_EOL; $sql = "SELECT * FROM wisedeal_mls_data_condo_active LIMIT $offset, $drowsPerPage"; if($result = mysqli_query($link, $sql)){ if(mysqli_num_rows($result) > 0){ while($row = mysqli_fetch_array($result)){ $MLS = $row['ml_num']; $Addr = $row['addr']; $Addr = preg_replace("/[\s_]/", "-", $Addr); $Addr = preg_replace("/\&/", "~n~", $Addr); $Municipality = $row['municipality']; $Municipality = preg_replace("/[\s_]/", "-", $Municipality); $Community = $row['community']; $Community = preg_replace("/[\s_]/", "-", $Community); //$prettyURL = 'http://www.rentbee.ca'.GetPrettyURLByMLS($MLS); //$prettyURL = preg_replace('|\'|', '~q~', $prettyURL); //$prettyURL = preg_replace('|\&|', 'and', $prettyURL); $prettyURL = 'http://www.rentbee.ca/new/'.$MLS.'_'.$Addr.'_'.$Municipality.'_'.$Community; echo "".$prettyURL."".$dat."daily1".PHP_EOL; } } } //wisedeal_mls_data_condo_active //wisedeal_mls_data_free_active echo ""; ?>