I have put together this script to read a row of data from SQL Server,
perform a calculation and write back the results. the read and
calculation are working but it doesn't write the data to SQL
Server...what am I doing wrong here?
<?
$host="---.---.---.---";
$DB="database";
$user="sa";
$pass="";
$connect = mssql_connect($host,$user,$pass) or die ($host." not
accessible.");
if ($DB) mssql_select_db($DB)or die('USE '.$DB.' failed!');
$query = "SELECT * FROM zipcodes where city = 'ADAMSVILLE'";
$result = mssql_query($query);
$numRows = mssql_num_rows($result);
echo "<table
border=1><tr><td>City</td><td>State</td><td>Zip</td><td>Longitude</td><td>Latitude</td><td>Longitude
Radians</td><td>Latitude
Radians</td></tr>";
for($i=0; $i<$numRows; $i++){
echo "<tr>";
$row = mssql_fetch_array($result);
$latitude = $row['latitude'];
$longitude = $row['longitude'];
$longitude = $longitude * -1;
echo
"<td>$row[city]</td><td>$row[state]</td><td>$row[zipcode]</td><td>$longitude</td><td>$latitude</td>";
$pi = 3.1415926;
$latitude_radians = ($pi/180.0) * $latitude;
$longitude_radians = ($pi/180.0) * $longitude;
echo "<td>$longitude_radians</td><td>$latitude_radians</td>";
$writeQuery = "INSERT INTO
zipcodes(longitude,latitude_radians,longitude_radians)
VALUES('$longitude','$latitude_radians','$longitude_radians')";
$writeResult = mssql_query($writeQuery);
echo "</tr>";
}
?>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
