Script doesn't write to database...
| From: | R.S. Herhuth | Date: | Tue, 09 Jul 2002 13:55:53 +0000 |
| Subject: | Script doesn't write to database... | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-14636@lists.php.net to get a copy of this message | ||
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>";
}
?>