[Firebug-cvs] firebug/web db_create.php,1.10,1.11 db_table_select.php,1.2,1.3
Brought to you by:
doolin
From: <che...@us...> - 2003-12-19 01:06:06
|
Update of /cvsroot/firebug/firebug/web In directory sc8-pr-cvs1:/tmp/cvs-serv25485 Modified Files: db_create.php db_table_select.php Log Message: change on the php Index: db_create.php =================================================================== RCS file: /cvsroot/firebug/firebug/web/db_create.php,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** db_create.php 30 Nov 2003 00:21:59 -0000 1.10 --- db_create.php 19 Dec 2003 01:06:02 -0000 1.11 *************** *** 38,45 **** mysql_query($statement) or die("Error: ".mysql_error()." in creating location atable"); ! $statement = "CREATE TABLE current (mote_id INTEGER, time TIMESTAMP, hours INTEGER, minutes INTEGER, dec_sec INTEGER, Lat_deg INTEGER, Lat_dec_min INTEGER, Long_deg INTEGER, Long_dec_min INTEGER, NSEWind INTEGER, temp FLOAT, cnt INTEGER)"; mysql_query($statement) or die("Error: ".mysql_error()." in creating current atable"); ! $statement = "CREATE TABLE cumulative (mote_id INTEGER, time TIMESTAMP, hours INTEGER, minutes INTEGER, dec_sec INTEGER, Lat_deg INTEGER, Lat_dec_min INTEGER, Long_deg INTEGER, Long_dec_min INTEGER, NSEWind INTEGER, temp FLOAT, cnt INTEGER)"; mysql_query($statement) or die("Error: ".mysql_error()." in creating cumulative atable"); --- 38,45 ---- mysql_query($statement) or die("Error: ".mysql_error()." in creating location atable"); ! $statement = "CREATE TABLE current (mote_id INTEGER, time TIMESTAMP, temp FLOAT, cnt INTEGER, hours INTEGER, minutes INTEGER, dec_sec INTEGER, Lat_deg INTEGER, Lat_dec_min INTEGER, Long_deg INTEGER, Long_dec_min INTEGER, NSEWind INTEGER)"; mysql_query($statement) or die("Error: ".mysql_error()." in creating current atable"); ! $statement = "CREATE TABLE cumulative (mote_id INTEGER, time TIMESTAMP, temp FLOAT, cnt INTEGER, hours INTEGER, minutes INTEGER, dec_sec INTEGER, Lat_deg INTEGER, Lat_dec_min INTEGER, Long_deg INTEGER, Long_dec_min INTEGER, NSEWind INTEGER)"; mysql_query($statement) or die("Error: ".mysql_error()." in creating cumulative atable"); Index: db_table_select.php =================================================================== RCS file: /cvsroot/firebug/firebug/web/db_table_select.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** db_table_select.php 30 Nov 2003 00:22:00 -0000 1.2 --- db_table_select.php 19 Dec 2003 01:06:02 -0000 1.3 *************** *** 60,65 **** <td>NSEWind</td> <td>Temp</td> - <td>Rel. Hum.</td> - <td>Baro. Pres.</td> <td>Cnt </td> </tr> --- 60,63 ---- *************** *** 118,130 **** $temp = "%"; } - - if ($rel_hum == "") { - $rel_hum = "%"; - } - - if ($baro_pres == "") { - $baro_pres = "%"; - } - $result = mysql_query("select * from $tblname --- 116,119 ---- |