Jump to content

writing an IF statement for a form (if certain option from option box is chosen)

jerryhughes101

By jerryhughes101
in PHP Coding Help

Recommended Posts

jerryhughes101 Newbie

jerryhughes101

Posted
Posted

What I'm trying to do at the moment (had some help on here over the weekend) is write an IF statement for when my database is being updated, if the default value is selected on one of the option boxes, DO NOT update that selected field in the database!

 

So at the moment my update statement is as follows;

 

if ($rows==1){

// Sanitize these post values! - ONLY IF YOU DONT TRUST USERS WITH CORRECT PASSWORDS!!!
$sql="UPDATE upcpicks SET fifaworldcup='".$_POST['fifaworldcup']."', usopengolf='".$_POST['golfusopen']."', wimbledon2010='".$_POST['wimbledontennis2010']."', tourdefrance='".$_POST['tourdefrance']."', championshipsoccer='".$_POST['championshipsoccer']."', premiershiprugby='".$_POST['premiershiprugby']."', lacrosse='".$_POST['lacrosse']."', heinekencup='".$_POST['heinekencup']."', magnersleague='".$_POST['magnersleague']."', premiershipsoccer='".$_POST['premiershipsoccer']."', leaguecupsoccer='".$_POST['leaguecupsoccer']."', facupsoccer='".$_POST['facupsoccer']."', championsleaguesoccer='".$_POST['championsleaguesoccer']."', serieasoccer='".$_POST['serieasoccer']."', bundesligasoccer='".$_POST['bundesligasoccer']."', laligasoccer='".$_POST['laligasoccer']."', usopentennis='".$_POST['usopentennis']."', collegefootball='".$_POST['collegefootball']."', superbowl='".$_POST['superbowl']."', rydercupgolf='".$_POST['rydercupgolf']."', stanleycup='".$_POST['stanleycup']."', australiaopentennis='".$_POST['australiaopentennis']."', superleague='".$_POST['superleague']."', sixnations='".$_POST['sixnations']."', wimbledontennis2011='".$_POST['wimbledontennis2011']."', rugbyworldcup='".$_POST['rugbyworldcup']."' WHERE user='".$_POST['person']."'";
$updateresult = mysql_query($sql) or die(mysql_error()); // actually execute the update query.

echo 'Picks Complete';
  }
  
  else {
echo 'Password Not Matched';
  }

 

 

Now for all my option boxes, the default value is set as the following

 

<option value="-">-</option>

 

What I'm looking to do is say if they select this default option, it means they don't want to update that field in the database so don't.

 

Does that make sense?

 

jerryhughes101 Newbie

jerryhughes101

Posted
  • Author
Posted

Would I have to make an IF statement for all the variables before they update the database, or could I just do like a global IF statement that would count for all of them

 

so like

 

if .$_POST['fifaworldcup'] = '-'

 

do not update 'fifaworldcup'

 

 

jerryhughes101 Newbie

jerryhughes101

Posted
  • Author
Posted

Do you want to stop the form from submitting if a default value is set?

 

Not really, what I've done is quite a lot of work into something which isn't the most practical, but I don't want to back and re-do it all!

 

Basically I've got a form which someone will continually use to make some predictions. The only time they use their username and password is when they send the form, thus meaning any predictions they've previously made would be erased or updated when they don't want to.

 

In a practical world, I would have them sign in before they reach the form so I could recall their values and populate the values into the select boxes straight away but alas I haven't!

 

This is my form at the moment,

<form method="post">

<p>Name <br /><br />
<select name="person">
  <option value="-">-</option>
  <option value="jerryhughes">Jerry Hughes</option>
  <option value="roblowe">Rob Lowe</option>
  <option value="mitchturner">Mitch Turner</option>
  <option value="simoneccleston">Simon Eccleston</option>
  <option value="neilwilmer">Neil Wilmer</option>
  <option value="andrewhawkings">Andrew Hawkings</option>
  <option value="tomjohnson">Tom Johnson</option>
  <option value="robsmith">Rob Smith</option>
  <option value="samfaulkner">Sam Faulkner</option>
  <option value="russhewitt">Russ Hewitt</option>
  <option value="andycrowe">Andy Crowe</option>
  <option value="benshaw">Ben Shaw</option>
  <option value="richhancock">Rich Hancock</option>
  <option value="chrisjefferson">Chris Jefferson</option>
  <option value="paulellis">Paul Ellis</option>
  <option value="jonwibberley">Jon Wibberley</option>
  <option value="markfoster">Mark Foster</option>
  <option value="benpeddie">Ben Peddie</option>
  <option value="adamhiggs">Adam Higgs</option>
  <option value="adammcclure">Adam McClure</option>
  <option value="mikegumbs">Mike Gumbs</option>
</select>
</p>

<p>Please enter your Password <br /><br />
<input name="password" type="text" /></p>

<p>Le mans 24 (Motor Racing) <br /><br />
<select name="lemans24">
<option value="TBA">TBA</option>

</select>

<p>FIFA World Cup (Football) <br /><br />
<select name="fifaworldcup">

<option value="-">-</option>
<option value="algeria">Algeria</option>
<option value="argentina">Argentina</option>
<option value="australia">Australia</option>
<option value="brazil">Brazil</option>
<option value="chile">Chile</option>
<option value="denmark">Denmark</option>
<option value="england">England</option>
<option value="france">France</option>
<option value="germany">Germany</option>
<option value="ghana">Ghana</option>
<option value="greece">Greece</option>
<option value="honduras">Honduras</option>
<option value="italy">Italy</option>
<option value="ivorycoast">Ivory Coast</option>
<option value="japan">Japan</option>
<option value="koreadpr">Korea DPR</option>
<option value="korearepublic">Korea Republic</option>
<option value="mexico">Mexico</option>
<option value="netherlands">Netherlands</option>
<option value="newzealand">New Zealand</option>
<option value="nigeria">Nigeria</option>
<option value="paraguay">Paraguay</option>
<option value="portugal">Portugal</option>
<option value="serbia">Serbia</option>
<option value="slovakia">Slovakia</option>
<option value="slovenia">Slovenia</option>
<option value="southafrica">South Africa</option>
<option value="spain">Spain</option>
<option value="switzerland">Switzerland</option>
<option value="uruguay">Uruguay</option>
<option value="usa">USA</option>

</select></p>

<p>US Open (Golf) <br /><br />
<select name="golfusopen" >

<option value="-">-</option>
<option value="stephenames">Ames, Stephen</option>
<option value="byeong-hunan">An, Byeong-Hun</option>
<option value="rickybarnes">Barnes, Ricky</option>
<option value="mattbettencourt">Bettencourt, Matt</option>
<option value="angelcabrera">Cabrera, Angel</option>
<option value="michaelcampbell">Campbell, Michael</option>
<option value="paulcasey">Casey, Paul</option>
<option value="stewartcink">Cink, Stewart</option>
<option value="timclark">Clark, Tim</option>
<option value="lukedonald">Donald, Luke</option>
<option value="jasondufner">Dufner, Jason</option>
<option value="davidduval">Duval, David</option>
<option value="simondyson">Dyson, Simon</option>
<option value="ernieels">Els, Ernie</option>
<option value="rossfisher">Fisher, Ross</option>
<option value="fredfunk">Funk, Fred</option>
<option value="jimfuryk">Furyk, Jim</option>
<option value="sergiogarcia">Garcia, Sergio</option>
<option value="briangay">Gay, Brian</option>
<option value="lucasglover">Glover, Lucas</option>
<option value="retiefgoosen">Goosen, Retief</option>
<option value="sorenhansen">Hansen, Soren</option>
<option value="padraigharrington">Harrington, Padraig</option>
<option value="yutaikeda">Ikeda, Yuta</option>
<option value="trevorimmelman">Immelman, Trevor</option>
<option value="ryoishikawa">Ishikawa, Ryo</option>
<option value="zachjonhson">Johnson, Zach</option>
<option value="dustinjohnson">Johnson, Dustin</option>
<option value="martinkaymer">Kaymer, Martin</option>
<option value="jerrykelly">Kelly, Jerry</option>
<option value="sorenkjeldsen">Kjeldsen, Soren</option>
<option value="mattkuchar">Kuchar, Matt</option>
<option value="marcleishman">Leishman, Marc</option>
<option value="justinleonard">Leonard, Justin</option>
<option value="huntermahan">Mahan, Hunter</option>
<option value="stevemarino">Marino, Steve</option>
<option value="benmartin">Martin, Ben</option>
<option value="rossmcgowan">McGowan, Ross</option>
<option value="rorymcilroy">McIlroy, Rory</option>
<option value="philmickelson">Mickelson, Phil</option>
<option value="francescomolinari">Molinari, Francesco</option>
<option value="ryanmoore">Moore, Ryan</option>
<option value="kevinna">Na, Kevin</option>
<option value="seanohair">O'Hair, Sean</option>
<option value="geoffogilvy">Ogilvy, Geoff</option>
<option value="kennyperry">Perry, Kenny</option>
<option value="ianpoulter">Poulter, Ian</option>
<option value="angeloque">Que, Angelo</option>
<option value="alvaroquiros">Quiros, Alvaro</option>
<option value="johnrollins">Rollins, John</option>
<option value="rorysabbatini">Sabbatini, Rory</option>
<option value="johnsenden">Senden, John</option>
<option value="michaelsim">Sim, Michael</option>
<option value="heathslocum">Slocum, Heath</option>
<option value="henrikstenson">Stenson, Henrik</option>
<option value="stevestricker">Stricker, Steve</option>
<option value="davidtoms">Toms, David</option>
<option value="scottverplank">Verplank, Scott</option>
<option value="nickwatney">Watney, Nick</option>
<option value="tomwatson">Watson, Tom </option>
<option value="mikeweir">Weir, Mike</option>
<option value="leewestwood">Westwood, Lee</option>
<option value="oliverwilson">Wilson, Oliver</option>
<option value="tigerwoods">Woods, Tiger</option>
<option value="YEyang">Yang, Y.E.</option>
</select>
</p>

<p>Wimbledon 2010 (Tennis) <br /><br />
<select name="wimbledontennis2010">
<option value="federer">Roger Federer</option>
<option value="nadal">Rafael Nadal</option>
<option value="murray">Andy Murray</option>
<option value="roddick">Andy Roddick</option>
<option value="delpotro">Juan Martin Del Potro</option>
<option value="djokovic">Novak Djokovic</option>
<option value="soderling">Robin Soderling</option>
<option value="tsonga">Jo-Wilfried Tsonga</option>
<option value="cilic">Marin Cilic</option>
<option value="davydenko">Nikolai Davydenko</option>
<option value="verdasco">Fernando Verdasco</option>
<option value="gasquet">Richard Gasquet</option>
<option value="haas">Tommy Haas</option>
<option value="karlovic">Ivo Karlovic</option>
<option value="gonzalez">Fernando Gonzalez</option>
<option value="monfils">Gael Monfils</option>
<option value="nalbandian">David Nalbandian</option>
<option value="berdych">Tomas Berdych</option>
<option value="hewitt">Lleyton Hewitt</option>
<option value="wawrinka">Stanislas Wawrinka</option>
<option value="simon">Gilles Simon</option>
<option value="fish">Mardy Fish</option>

</select></p>

<p>Tour De France (Cycling) <br /><br />
<select name="tourdefrance" />
  <option value="TBA">TBA</option>

</select>
</p>

<p>Coca Cola Championship (Soccer) <br /><br />
<select name="championshipsoccer">
  <option value="TBA">TBA</option>


</select></p>


<p>Guiness Premiership (Rugby) <br /><br />
<select name="premiershiprugby">
<option value="TBA">TBA</option>

</select></p>

<p>World Lacross Championships (Lacrosse) <br /><br />
<select name="lacrosse">
  <option value="TBA">TBA</option>

</select></p>

<p>Heineken Cup (Rugby Union) <br /><br />
<select name="heinekencup">
  <option value="TBA">TBA</option> 

</select></p>

<p>Magners League (Rugby Union) <br /><br />
<select name="magnersleague">
  <option value="TBA">TBA</option>

</select></p>

<p>Barclays Premiership (Soccer) <br /><br />
<select name="premiershipsoccer">
  <option value="TBA">TBA</option>

</select></p>

<p>League Cup (Soccer) <br /><br />
<select name="leaguecupsoccer">
  <option value="TBA">TBA</option>

</select></p>

<p>FA Cup (Soccer) <br /><br />
<select name="facupsoccer">
  <option value="TBA">TBA</option>

</select></p>

<p>Champions League (Soccer) <br /><br />
<select name="championsleaguesoccer">
  <option value="TBA">TBA</option>

</select></p>

<p>Serie A (Soccer) <br /><br />
<select name="serieasoccer">
<option value="TBA">TBA</option>
</select></p>

<p>Bundesliga (Soccer) <br /><br />
<select name="bundesligasoccer">
<option value="TBA">TBA</option>
</select></p>

<p>La Liga (Soccer) <br /><br />
<select name="laligasoccer">
<option value="TBA">TBA</option>
</select></p>

<p>US Open (Tennis) <br /><br />
<select name="usopentennis">
<option value="TBA">TBA</option>
</select></p>

<p>National Championshp Game (American Football) <br /><br />
<select name="collegefootball">
<option value="TBA">TBA</option>
</select></p>

<p>NFL Superbowl (American Football) <br /><br />
<select name="superbowl">
<option value="TBA">TBA</option>

</select></p>

<p>Ryder Cup (Golf) <br /><br />
<select name="rydercupgolf">
<option value="TBA">TBA</option>
</select></p>

<p>NHL Stanley Cup (Ice Hockey) <br /><br />
<select name="stanleycup">
<option value="TBA">TBA</option>
</select></p>

<p>Australia Open 2011 (Tennis) <br /><br />
<select name="australiaopentennis">
<option value="TBA">TBA</option>
</select></p>

<p>Super League 2011 (Rugby League) <br /><br />
<select name="superleague">
<option value="TBA">TBA</option>
</select></p>

<p>Six Nations (Rugby Union) <br /><br />
<select name="sixnations">
<option value="TBA">TBA</option>
</select></p>

<p>Wimbledon 2011 (Tennis) <br /><br />
<select name="wimbledontennis2011">
<option value="TBA">TBA</option>
</select></p>

<p>Rugby World Cup (Rugby Union) <br /><br />
<select name="rugbyworldcup">
<option value="TBA">TBA</option>
</select></p>

<input name="submit" type="submit" />

</form>

 

So say they've already picked who their world cup winner as England (yeah right!) I don't want them to have to put England in every time, in case they forget it and overwrite it by accident! SO next time they come along and choose Tiger Woods to win the US open, they leave world cup as the default - and then the world cup field in the dbase doesn't update but ones with a name value in do?

 

Is that even possible? :-/

jerryhughes101 Newbie

jerryhughes101

Posted
  • Author
Posted

whole page of code is as follows;

<?php
// Code At The Top plox
   
//MYSQL connection information
   $db_host = "localhost";
   $db_user = "jerryhug";   
   $db_password = "70exile101";
   $db_name = "jerryhug_upc";
   $path = $_SERVER['DOCUMENT_ROOT'];
      
   $connection = mysql_connect($db_host, $db_user, $db_password); 
   mysql_select_db($db_name, $connection);

//check if something has been posted
if (isset($_POST['password']) && isset($_POST['person'])){

  //get the username and password and protect against mysql Injection
  $user = mysql_real_escape_string($_POST['person']);
  $password = mysql_real_escape_string($_POST['password']); 
  

//run the query to see if a user and password match
$getname = "SELECT user FROM upcpicks WHERE user ='$user' AND password = '$password'";
$nameresult = mysql_query($getname, $connection) or die(mysql_error());
$rows = mysql_num_rows($nameresult);
$info = mysql_fetch_array( $nameresult );
$user_id = $info['user_id'];

//if there is a match then run the code to update the DB, otherwise the password does not match
if ($rows==1){


// Sanitize these post values! - ONLY IF YOU DONT TRUST USERS WITH CORRECT PASSWORDS!!!
$sql="UPDATE upcpicks SET fifaworldcup='".$_POST['fifaworldcup']."', usopengolf='".$_POST['golfusopen']."', wimbledon2010='".$_POST['wimbledontennis2010']."', tourdefrance='".$_POST['tourdefrance']."', championshipsoccer='".$_POST['championshipsoccer']."', premiershiprugby='".$_POST['premiershiprugby']."', lacrosse='".$_POST['lacrosse']."', heinekencup='".$_POST['heinekencup']."', magnersleague='".$_POST['magnersleague']."', premiershipsoccer='".$_POST['premiershipsoccer']."', leaguecupsoccer='".$_POST['leaguecupsoccer']."', facupsoccer='".$_POST['facupsoccer']."', championsleaguesoccer='".$_POST['championsleaguesoccer']."', serieasoccer='".$_POST['serieasoccer']."', bundesligasoccer='".$_POST['bundesligasoccer']."', laligasoccer='".$_POST['laligasoccer']."', usopentennis='".$_POST['usopentennis']."', collegefootball='".$_POST['collegefootball']."', superbowl='".$_POST['superbowl']."', rydercupgolf='".$_POST['rydercupgolf']."', stanleycup='".$_POST['stanleycup']."', australiaopentennis='".$_POST['australiaopentennis']."', superleague='".$_POST['superleague']."', sixnations='".$_POST['sixnations']."', wimbledontennis2011='".$_POST['wimbledontennis2011']."', rugbyworldcup='".$_POST['rugbyworldcup']."' WHERE user='".$_POST['person']."'";
$updateresult = mysql_query($sql) or die(mysql_error()); // actually execute the update query.

echo 'Picks Complete';
  }
  
  else {
echo 'Password Not Matched';
  }
}
// Keep form, just seperate it
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="css/layout.css"/>
<title>jerryhughes.co.uk</title>
</head>
<body>
<div id="container">
<div id="topheader"></div>
<div id="mainheader">
<div id="insidemainheader">
<img src="images/jerryhughesheader.jpg" class="jerryhughestext" />
</div>
</div>
<div id="bottomheader"> </div>
<div id="maincontent">
<div id="topbarmaincontent">
you are: home >> upc >> make my picks
</div>
<div id="navbarmaincontent">
<ul>
<li><a href="index.html">home</a> </li>
<li><a href="portfolio.html">portfolio</a> </li>
<li><a href="cv.html">cv</a> </li>
<li><a href="about.html">about</a> </li>
<li><a href="contact.php">contact me</a> </li>

</ul>
</div>
<div id="innerpagesrightbox">
<h1>upc</h1>
<h2>make my picks</h2>

<form method="post">

<p>Name <br /><br />
<select name="person">
  <option value="-">-</option>
  <option value="jerryhughes">Jerry Hughes</option>
  <option value="roblowe">Rob Lowe</option>
  <option value="mitchturner">Mitch Turner</option>
  <option value="simoneccleston">Simon Eccleston</option>
  <option value="neilwilmer">Neil Wilmer</option>
  <option value="andrewhawkings">Andrew Hawkings</option>
  <option value="tomjohnson">Tom Johnson</option>
  <option value="robsmith">Rob Smith</option>
  <option value="samfaulkner">Sam Faulkner</option>
  <option value="russhewitt">Russ Hewitt</option>
  <option value="andycrowe">Andy Crowe</option>
  <option value="benshaw">Ben Shaw</option>
  <option value="richhancock">Rich Hancock</option>
  <option value="chrisjefferson">Chris Jefferson</option>
  <option value="paulellis">Paul Ellis</option>
  <option value="jonwibberley">Jon Wibberley</option>
  <option value="markfoster">Mark Foster</option>
  <option value="benpeddie">Ben Peddie</option>
  <option value="adamhiggs">Adam Higgs</option>
  <option value="adammcclure">Adam McClure</option>
  <option value="mikegumbs">Mike Gumbs</option>
</select>
</p>

<p>Please enter your Password <br /><br />
<input name="password" type="text" /></p>

<p>Le mans 24 (Motor Racing) <br /><br />
<select name="lemans24">
<option value="TBA">TBA</option>

</select>

<p>FIFA World Cup (Football) <br /><br />
<select name="fifaworldcup">

<option value="-">-</option>
<option value="algeria">Algeria</option>
<option value="argentina">Argentina</option>
<option value="australia">Australia</option>
<option value="brazil">Brazil</option>
<option value="chile">Chile</option>
<option value="denmark">Denmark</option>
<option value="england">England</option>
<option value="france">France</option>
<option value="germany">Germany</option>
<option value="ghana">Ghana</option>
<option value="greece">Greece</option>
<option value="honduras">Honduras</option>
<option value="italy">Italy</option>
<option value="ivorycoast">Ivory Coast</option>
<option value="japan">Japan</option>
<option value="koreadpr">Korea DPR</option>
<option value="korearepublic">Korea Republic</option>
<option value="mexico">Mexico</option>
<option value="netherlands">Netherlands</option>
<option value="newzealand">New Zealand</option>
<option value="nigeria">Nigeria</option>
<option value="paraguay">Paraguay</option>
<option value="portugal">Portugal</option>
<option value="serbia">Serbia</option>
<option value="slovakia">Slovakia</option>
<option value="slovenia">Slovenia</option>
<option value="southafrica">South Africa</option>
<option value="spain">Spain</option>
<option value="switzerland">Switzerland</option>
<option value="uruguay">Uruguay</option>
<option value="usa">USA</option>

</select></p>

<p>US Open (Golf) <br /><br />
<select name="golfusopen" >

<option value="-">-</option>
<option value="stephenames">Ames, Stephen</option>
<option value="byeong-hunan">An, Byeong-Hun</option>
<option value="rickybarnes">Barnes, Ricky</option>
<option value="mattbettencourt">Bettencourt, Matt</option>
<option value="angelcabrera">Cabrera, Angel</option>
<option value="michaelcampbell">Campbell, Michael</option>
<option value="paulcasey">Casey, Paul</option>
<option value="stewartcink">Cink, Stewart</option>
<option value="timclark">Clark, Tim</option>
<option value="lukedonald">Donald, Luke</option>
<option value="jasondufner">Dufner, Jason</option>
<option value="davidduval">Duval, David</option>
<option value="simondyson">Dyson, Simon</option>
<option value="ernieels">Els, Ernie</option>
<option value="rossfisher">Fisher, Ross</option>
<option value="fredfunk">Funk, Fred</option>
<option value="jimfuryk">Furyk, Jim</option>
<option value="sergiogarcia">Garcia, Sergio</option>
<option value="briangay">Gay, Brian</option>
<option value="lucasglover">Glover, Lucas</option>
<option value="retiefgoosen">Goosen, Retief</option>
<option value="sorenhansen">Hansen, Soren</option>
<option value="padraigharrington">Harrington, Padraig</option>
<option value="yutaikeda">Ikeda, Yuta</option>
<option value="trevorimmelman">Immelman, Trevor</option>
<option value="ryoishikawa">Ishikawa, Ryo</option>
<option value="zachjonhson">Johnson, Zach</option>
<option value="dustinjohnson">Johnson, Dustin</option>
<option value="martinkaymer">Kaymer, Martin</option>
<option value="jerrykelly">Kelly, Jerry</option>
<option value="sorenkjeldsen">Kjeldsen, Soren</option>
<option value="mattkuchar">Kuchar, Matt</option>
<option value="marcleishman">Leishman, Marc</option>
<option value="justinleonard">Leonard, Justin</option>
<option value="huntermahan">Mahan, Hunter</option>
<option value="stevemarino">Marino, Steve</option>
<option value="benmartin">Martin, Ben</option>
<option value="rossmcgowan">McGowan, Ross</option>
<option value="rorymcilroy">McIlroy, Rory</option>
<option value="philmickelson">Mickelson, Phil</option>
<option value="francescomolinari">Molinari, Francesco</option>
<option value="ryanmoore">Moore, Ryan</option>
<option value="kevinna">Na, Kevin</option>
<option value="seanohair">O'Hair, Sean</option>
<option value="geoffogilvy">Ogilvy, Geoff</option>
<option value="kennyperry">Perry, Kenny</option>
<option value="ianpoulter">Poulter, Ian</option>
<option value="angeloque">Que, Angelo</option>
<option value="alvaroquiros">Quiros, Alvaro</option>
<option value="johnrollins">Rollins, John</option>
<option value="rorysabbatini">Sabbatini, Rory</option>
<option value="johnsenden">Senden, John</option>
<option value="michaelsim">Sim, Michael</option>
<option value="heathslocum">Slocum, Heath</option>
<option value="henrikstenson">Stenson, Henrik</option>
<option value="stevestricker">Stricker, Steve</option>
<option value="davidtoms">Toms, David</option>
<option value="scottverplank">Verplank, Scott</option>
<option value="nickwatney">Watney, Nick</option>
<option value="tomwatson">Watson, Tom </option>
<option value="mikeweir">Weir, Mike</option>
<option value="leewestwood">Westwood, Lee</option>
<option value="oliverwilson">Wilson, Oliver</option>
<option value="tigerwoods">Woods, Tiger</option>
<option value="YEyang">Yang, Y.E.</option>
</select>
</p>

<p>Wimbledon 2010 (Tennis) <br /><br />
<select name="wimbledontennis2010">
<option value="federer">Roger Federer</option>
<option value="nadal">Rafael Nadal</option>
<option value="murray">Andy Murray</option>
<option value="roddick">Andy Roddick</option>
<option value="delpotro">Juan Martin Del Potro</option>
<option value="djokovic">Novak Djokovic</option>
<option value="soderling">Robin Soderling</option>
<option value="tsonga">Jo-Wilfried Tsonga</option>
<option value="cilic">Marin Cilic</option>
<option value="davydenko">Nikolai Davydenko</option>
<option value="verdasco">Fernando Verdasco</option>
<option value="gasquet">Richard Gasquet</option>
<option value="haas">Tommy Haas</option>
<option value="karlovic">Ivo Karlovic</option>
<option value="gonzalez">Fernando Gonzalez</option>
<option value="monfils">Gael Monfils</option>
<option value="nalbandian">David Nalbandian</option>
<option value="berdych">Tomas Berdych</option>
<option value="hewitt">Lleyton Hewitt</option>
<option value="wawrinka">Stanislas Wawrinka</option>
<option value="simon">Gilles Simon</option>
<option value="fish">Mardy Fish</option>

</select></p>

<p>Tour De France (Cycling) <br /><br />
<select name="tourdefrance" />
  <option value="TBA">TBA</option>

</select>
</p>

<p>Coca Cola Championship (Soccer) <br /><br />
<select name="championshipsoccer">
  <option value="TBA">TBA</option>


</select></p>


<p>Guiness Premiership (Rugby) <br /><br />
<select name="premiershiprugby">
<option value="TBA">TBA</option>

</select></p>

<p>World Lacross Championships (Lacrosse) <br /><br />
<select name="lacrosse">
  <option value="TBA">TBA</option>

</select></p>

<p>Heineken Cup (Rugby Union) <br /><br />
<select name="heinekencup">
  <option value="TBA">TBA</option> 

</select></p>

<p>Magners League (Rugby Union) <br /><br />
<select name="magnersleague">
  <option value="TBA">TBA</option>

</select></p>

<p>Barclays Premiership (Soccer) <br /><br />
<select name="premiershipsoccer">
  <option value="TBA">TBA</option>

</select></p>

<p>League Cup (Soccer) <br /><br />
<select name="leaguecupsoccer">
  <option value="TBA">TBA</option>

</select></p>

<p>FA Cup (Soccer) <br /><br />
<select name="facupsoccer">
  <option value="TBA">TBA</option>

</select></p>

<p>Champions League (Soccer) <br /><br />
<select name="championsleaguesoccer">
  <option value="TBA">TBA</option>

</select></p>

<p>Serie A (Soccer) <br /><br />
<select name="serieasoccer">
<option value="TBA">TBA</option>
</select></p>

<p>Bundesliga (Soccer) <br /><br />
<select name="bundesligasoccer">
<option value="TBA">TBA</option>
</select></p>

<p>La Liga (Soccer) <br /><br />
<select name="laligasoccer">
<option value="TBA">TBA</option>
</select></p>

<p>US Open (Tennis) <br /><br />
<select name="usopentennis">
<option value="TBA">TBA</option>
</select></p>

<p>National Championshp Game (American Football) <br /><br />
<select name="collegefootball">
<option value="TBA">TBA</option>
</select></p>

<p>NFL Superbowl (American Football) <br /><br />
<select name="superbowl">
<option value="TBA">TBA</option>

</select></p>

<p>Ryder Cup (Golf) <br /><br />
<select name="rydercupgolf">
<option value="TBA">TBA</option>
</select></p>

<p>NHL Stanley Cup (Ice Hockey) <br /><br />
<select name="stanleycup">
<option value="TBA">TBA</option>
</select></p>

<p>Australia Open 2011 (Tennis) <br /><br />
<select name="australiaopentennis">
<option value="TBA">TBA</option>
</select></p>

<p>Super League 2011 (Rugby League) <br /><br />
<select name="superleague">
<option value="TBA">TBA</option>
</select></p>

<p>Six Nations (Rugby Union) <br /><br />
<select name="sixnations">
<option value="TBA">TBA</option>
</select></p>

<p>Wimbledon 2011 (Tennis) <br /><br />
<select name="wimbledontennis2011">
<option value="TBA">TBA</option>
</select></p>

<p>Rugby World Cup (Rugby Union) <br /><br />
<select name="rugbyworldcup">
<option value="TBA">TBA</option>
</select></p>





<input name="submit" type="submit" />

</form>


</div>
<div id="twitterboxleft">
<h1>follow me on twitter</h1>
<img src="images/twitterlogo.jpg" alt="follow me on twitter" class="twitterlogo" />
<div id="twitter_div"><ul id="twitter_update_list"><li> </li><li> </li></ul></div>
</div>
<div id="upcboxleft">
</div>
</div>
</div>
<script type="text/javascript" src="http://twitter.com/javascripts/blogger.js"></script>
<script type="text/javascript" src="http://twitter.com/statuses/user_timeline/jerryhughes101.json?callback=twitterCallback2&count=3"></script>
</body>
</html>

 

TeddyKiller Advanced Member

TeddyKiller

Posted
Posted

So if I'm right in saying, if there is a field thats got the default value, to not include it in the query? My technical language isn't too brilliant. Though if thats correct, then it is possible. I should be able to do something. I'm currently working on someone elses project at the moment. Aswell as mine, little busy but sure. I could fit something :)

Cagecrawler Member

Cagecrawler

Posted
Posted

Try something like this: 

<?php
//Do your connection and checking player/password is correct.
$competitions = array('fifaworldcup' => 'fifaworldcup', 'golfusopen' => 'usopengolf', 'wimbledontennis2010' => 'wimbledon2010'); //Complete with each competition you run, where the key is the POST value and value is the database field.  

$sql_array = array();
foreach($competitions as $key => $value){
if($_POST[$key] != '-'){
	$sql_array[] = "$value = '{$_POST[$key]}'";
}
}
$sql = 'UPDATE upcpicks SET '.implode(',',$sql_array)." WHERE user='".$_POST['person']."'";
?>

 

The sql now only updates the fields where the data has been entered.

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.