Hi All,
I am having a problem with fields refreshing in mysql and php. I have some fields that I don’t want to change unless I change them. They are drop down selections. The fields are dupes band and mode. The rest of them need to blank after writing automaticaly.
Here is the code:
[php]
<?php $dupe = " "; $band = " "; $mode = " "; $zone =" "; $sect =" "; $region =" "; $grid =" "; $utc =" "; $mycall =" "; $contest =" "; $logname =" "; $CM =" "; $tn =" "; $catop = " "; $cata = " "; $pow = " "; $xmit = " "; $cscore = " "; $club =" "; $email =" "; $name =" "; $add1 =" "; $add2 =" "; $city =" "; $state =" "; $zip =" "; $country =" "; $op1 =" "; $op2 =" "; $op3 =" "; $op4 =" "; $op5 =" "; $op6 =" "; $op7 =" "; $op8 =" "; $op9 =" "; $co = " "; $cb =" "; $class =" "; $rsts =" "; $rstr =" "; $logrstsnd = " "; $logrstrcv = " "; $logsect = " "; $logclass = " "; $logzone = " "; $logregion = " "; $loggrid = " "; $logdate = " "; $logtime = " "; $logfrequ = " "; $soap1 = " "; $soap2 = " "; $status = " "; $time = time(); $con = mysql_connect("localhost","contest","logger"); mysql_select_db("my_setup", $con); $result = mysql_query("SELECT * FROM myinfo") or die(mysql_error()); $row = mysql_fetch_object( $result ); $logname = $row->logname; mysql_close($con); $con = mysql_connect("localhost","contest","logger"); $sql=mysql_query("CREATE DATABASE IF NOT EXISTS $logname",$con); mysql_select_db($logname, $con) or die(mysql_error()); $csq=mysql_query("CREATE TABLE IF NOT EXISTS fldday(station varchar(10),band varchar(5),mode varchar(5),class varchar(10),section varchar(10))") or die(mysql_error()); mysql_query($csq,$con); if($_GET['action'] == "log") { extract($_POST); $check = mysql_query("SELECT station FROM log1 WHERE station = '{$station}' AND mode = '{$mode}' AND band = '{$band}';"); $status=(mysql_num_rows($check)); echo $dupe; if (mysql_num_rows($check) == 0 ) { $sta = strtoupper($station); $uclass = strtoupper($class); $usection = strtoupper($section); mysql_query("INSERT INTO `log1` (station, band, mode, class, section) VALUES('$sta', '$band', '$mode', '$uclass', '$usection')") or die(mysql_error()); $status = "OK"; } else{ $status = "DUPE NOT RECORDED"; } } mysql_close($con); ?> KA3PMW log entry<h1><center>KA3PMW Field Day Logger V 3.0 <br />
<div id="time_wrapper"></div></h1>
<br /><br /><br />
<div align="left">
<Label> Dupes:
<select name="dupe" id="dupe">
<option value="1">Do Not Allow</option>
<option value="2">Warn Only</option>
<option value="3">Warn and Allow</option>
</select>
</Label>
<Label> Hog Call:
<select name="hc" id="hc">
<option value="1">ON</option>
<option value="0">OFF</option>
</select>
</label>
<label> Band:
<select name="band" id="band">
<option value="All">All</option>
<option value="160">160M</option>
<option value="80">80M</option>
<option value="40">40M</option>
<option value="20">20M</option>
<option value="15">15M</option>
<option value="10">10M</option>
<option value="50">6M</option>
<option value="144">2M</option>
<option value="222">220</option>
<option value="432">440</option>
<option value="880">880</option>
<option value="1.2">1.2G</option>
<option value="2.3">2.3G</option>
<option value="3.4">3.4G</option>
<option value="5.7">5.7G</option>
<option value="10G">10G</option>
<option value="24">24G</option>
<option value="47">47G</option>
<option value="75">75G</option>
<option value="119">119G</option>
<option value="142">142G</option>
<option value="241">241G</option>
<option value="300">300G</option>
<option value="Light">Light</option>
</select>
</label>
<label> Mode:
<select name="mode" id="mode">
<option value="CW">CW</option>
<option value="SSB">SSB</option>
<option value="RTTY">RTTY</option>
<option value="Mixed">Mixed</option>
</select>
</label>
Station:
Class:
Section:
<?php echo $status; ?>
RST Sent:
RST Received:
Frequency:
Exchange Sent:
[/php]