Re: Script doesn't write to database...

does it show an error or warning ? use mssql_rows_affected() and find if any row was affected. try using mssql_get_last_message() and find if any message was sent by the server. Mathew At 09:17 AM 7/9/2002 -0500, you wrote:

Mathew, Thanks for your reply. I have another table in the same database that I'm writing to successfully, it just doesn't seem to want to write to this one table. I am totally frustrated with this script but I need to get it done. Thanks for any ideas you might have. Ron Mathew Joseph wrote: i have a feeling that your database doesnt commit by default. you may have to explicitly call commit from ur PHP scripts or set auto_commit in ur sql server. Ofcourse if other update statements of yours are working without an explicit commit then i cant find anything wrong with ur code. Mathew At 08:55 AM 7/9/2002 -0500, you wrote:

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>$long

itude</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

-- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php