Hey, thanks Carlos. It's actually your code from a couple posts above, I get (Error on line 27, unexpected ']'). I didn't set up the cron job, just running it from the server until bugs fixed. Here's mine, only parts I changed were my details for sql database. My server has php 5.1.6 if that matters, and I have little (read: very little) knowledge of php which I'm sure certainly matters! I appreciate your help, thanks a ton.

php
##This file is to be run via cron job once every 1 minutes
##It takes the AC generated XML file and stores the status
##and values to a SQL database.  
##
## * * * * * /usr/bin/lynx -source http://URLofScript
##
#Opens the database connection
mysql_connect('localhost', 'climates_logan', 'xxx') or die(odbc_error());
mysql_select_db("climates_reeftank");
#Clears the current status table and prepares it for new values
mysql_query("TRUNCATE TABLE tank");
#Opens and stores the xml file into a string
$xml = "";
$f = fopen( 'http://www.rowelab.com/AquaController/climatestudios.xml', 'r' );
while( $data = fread( $f, 4096 ) ) { $xml .= $data; }
fclose( $f );
#Parse items from XML
preg_match_all( "/\<item\>(.*?)\<\/item\>/s", 
$xml, $itemblocks );
foreach( $itemblocksΏ] as $block )
{
preg_match_all( "/\<title\>(.*?)\<\/title\>/", $block, $title );
preg_match_all( "/\<description\>(.*?)\<\/description\>/", $block, $description );
#Stores items in SQL database
mysql_query("INSERT INTO tank (`ID`, `Title`, `Description`, `PubDate`) VALUES ('', '".$titleΏ]Ύ]."', '".$descriptionΏ]Ύ]."', NOW())" [Wink] ;
#A screen print of what was stored
echo( $titleΏ]Ύ]." - ".$descriptionΏ]Ύ]."<br/>\n" );
}
?>

Give this file a try.

I made some changes and made it easier to edit as well.  You will have to open the file and make the necessary changes.

Here is the file. 

xml2sql.zip

HTH,

Carlos

Hi, thanks guys. Yeah, I put a '#' in front of the line that clears the table each time and set up a cron job at every 10 min. So far, fantastic. It's storing in my table every 10 minutes. Found a great tutorial on JPgraph online, so thanks to all that and your help, so far so good. Once I'm able to graph, I'm going to borrow a killawatt and see about measuring all that jazz. but, one step at a time. I'm still playing around though , because i do want to at least have a little understanding of the php involved.  i don't want you to do all my work for me carlos lol

Have you seen this?

http://ioc.unesco.org/Oceanteacher/oceanteacher2/01_GlobOcToday/02_CollDta/02_OcDtaFunda/02_OcMeasUnits/SWequationofstatecalculator.htm

Just so we are clear. The formula for what you are asking is pretty complex. Attached below is the formula that I found. Lot to consider when making that calc.

Okay, I modified one of them to work with with pressure=0..

http://rowelab.com/fish/sal.html

http://rowelab.com/fish/sal2.html

(first one is for degrees F, second is for degrees C)

I ended up refering to a chart for the calculations.  Converting conductivity to salinity is a one step calculation.  From that point based on temp and salinity I have it go to the chart for the specific gravity.  Not as accurate as I want it to be, but I guess it will have to do.  Thanks everyone.