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
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
