Database Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers Forums > Other Technologies > Database Help
Reload this Page

updating 3 rows with posts?

Discuss updating 3 rows with posts? in the Database Help forum on Codewalkers.
updating 3 rows with posts? General SQL help. Help with MySQL, MSSQL, Oracle, mSQL, PostgreSQL, etc.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
  #1  
Old March 25th, 2004, 07:05 PM
treelo treelo is offline
Contributing User
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 121 treelo User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 28 m 39 sec
Reputation Power: 2
updating 3 rows with posts?
here is the code im currently working with
php Code:
Original - php Code 
  1. <table cellspacing="0" cellpadding="0" width="100%">
  2.   <tr>
  3. <td align="center">
  4. <form action="update_pred_results.php" METHOD="POST">
  5.   <div align="center">
  6.     Winner: 
  7.     <select name="winner">
  8.       <option value="<?php
  9.     $results = mysql_query("SELECT *  FROM prediction WHERE fight = 'fight1'") or die(mysql_error());
  10.     $row = mysql_fetch_array($results);
  11.      echo $row['fighter1'] .'">'. $row['fighter1'] .'</option>'; 
  12. ?> 
  13.       <option value="<?php
  14.     $results = mysql_query("SELECT *  FROM prediction WHERE fight = 'fight1'") or die(mysql_error());
  15.         
  16.      $row = mysql_fetch_array($results);
  17.      
  18.      echo $row['fighter2'] .'">'. $row['fighter2'] .'</option>'; 
  19. ?> 
  20. </select>
  21.     <br />
  22. Result:
  23.     <select name="result">
  24.       <option value="pts">Points</option>
  25.       <option value="ko">Stoppage</option>
  26.       <option value="draw">Draw</option>
  27.     </select>
  28.     <br />Round:
  29. <select name="round">
  30.     <option value="01">1</option>
  31.     <option value="02">2</option>
  32.     <option value="03">3</option>
  33.     <option value="04">4</option>
  34.           <option value="05">5</option>
  35.           <option value="06">6</option>
  36.     <option value="07">7</option>
  37.           <option value="08">8</option>
  38.           <option value="09">9</option>
  39.     <option value="10">10</option>
  40.           <option value="11">11</option>
  41.           <option value="12">12</option>
  42.     </select> 
  43.     <input type="submit" value="submit">
  44.   </div>
  45. </form>
  46. <td align="center">
  47. <?php
  48. if( isset($_POST['winner']) && isset($_POST['result']) && isset($_POST['round']) )
  49. {
  50. $conn = mysql_connect('localhost', 'treelo', 'joseph')
  51. or die('Invalid query:' . mysql_error());
  53. $rs = mysql_select_db('boxchamp_test', $conn)
  54. or die('Invalid query:' . mysql_error());
  56. $sql = "UPDATE prediction SET winner='".$_POST['winner']."', result='".$_POST['result']."', round='".$_POST['round']."' WHERE fight='fight1'";
  59. echo mysql_error();
  61. $rs = mysql_query($sql,$conn)
  62. or die('Invalid query:' . mysql_error() . '<br /> $sql was : ' . $sql); 
  63. } else {
  64. echo "POST VARS not filled out";
  65. }
  66. ?>
  67. </td>
  68. <td>
  69. <form action="update_pred_results.php" METHOD="POST">
  70.   <div align="center">
  71.     Winner: 
  72.     <select name="winner">
  73.       <option value="<?php
  74.     $results = mysql_query("SELECT *  FROM prediction WHERE fight = 'fight2'") or die(mysql_error());
  75.     $row = mysql_fetch_array($results);
  76.      echo $row['fighter1'] .'">'. $row['fighter1'] .'</option>'; 
  77. ?> 
  78.       <option value="<?php
  79.     $results = mysql_query("SELECT *  FROM prediction WHERE fight = 'fight2'") or die(mysql_error());
  80.         
  81.      $row = mysql_fetch_array($results);
  82.      
  83.      echo $row['fighter2'] .'">'. $row['fighter2'] .'</option>'; 
  84. ?> 
  85. </select>
  86.     <br />
  87. Result:
  88.     <select name="result">
  89.       <option value="pts">Points</option>
  90.       <option value="ko">Stoppage</option>
  91.       <option value="draw">Draw</option>
  92.     </select>
  93.     <br />Round:
  94. <select name="round">
  95.     <option value="01">1</option>
  96.     <option value="02">2</option>
  97.     <option value="03">3</option>
  98.     <option value="04">4</option>
  99.           <option value="05">5</option>
  100.           <option value="06">6</option>
  101.     <option value="07">7</option>
  102.           <option value="08">8</option>
  103.           <option value="09">9</option>
  104.     <option value="10">10</option>
  105.           <option value="11">11</option>
  106.           <option value="12">12</option>
  107.     </select> 
  108.     <input type="submit" value="submit">
  109.   </div>
  110. </form>
  111. <td align="center">
  112. <?php
  113. if( isset($_POST['winner']) && isset($_POST['result']) && isset($_POST['round']) )
  114. {
  115. $conn = mysql_connect('localhost', 'treelo', 'joseph')
  116. or die('Invalid query:' . mysql_error());
  118. $rs = mysql_select_db('boxchamp_test', $conn)
  119. or die('Invalid query:' . mysql_error());
  121. $sql = "UPDATE prediction SET winner='".$_POST['winner']."', result='".$_POST['result']."', round='".$_POST['round']."' WHERE fight='fight2'";
  124. echo mysql_error();
  126. $rs = mysql_query($sql,$conn)
  127. or die('Invalid query:' . mysql_error() . '<br /> $sql was : ' . $sql); 
  128. } else {
  129. echo "POST VARS not filled out";
  130. }
  131. ?>
  132. </td>
  133. <td>
  134. <form action="update_pred_results.php" METHOD="POST">
  135.   <div align="center">
  136.     Winner: 
  137.     <select name="winner">
  138.       <option value="<?php
  139.     $results = mysql_query("SELECT *  FROM prediction WHERE fight = 'fight3'") or die(mysql_error());
  140.     $row = mysql_fetch_array($results);
  141.      echo $row['fighter1'] .'">'. $row['fighter1'] .'</option>'; 
  142. ?> 
  143.       <option value="<?php
  144.     $results = mysql_query("SELECT *  FROM prediction WHERE fight = 'fight3'") or die(mysql_error());
  145.         
  146.      $row = mysql_fetch_array($results);
  147.      
  148.      echo $row['fighter2'] .'">'. $row['fighter2'] .'</option>'; 
  149. ?> 
  150. </select>
  151.     <br />
  152. Result:
  153.     <select name="result">
  154.       <option value="pts">Points</option>
  155.       <option value="ko">Stoppage</option>
  156.       <option value="draw">Draw</option>
  157.     </select>
  158.     <br />Round:
  159. <select name="round">
  160.     <option value="01">1</option>
  161.     <option value="02">2</option>
  162.     <option value="03">3</option>
  163.     <option value="04">4</option>
  164.           <option value="05">5</option>
  165.           <option value="06">6</option>
  166.     <option value="07">7</option>
  167.           <option value="08">8</option>
  168.           <option value="09">9</option>
  169.     <option value="10">10</option>
  170.           <option value="11">11</option>
  171.           <option value="12">12</option>
  172.     </select> 
  173.     <input type="submit" value="submit">
  174.   </div>
  175. </form>
  176. <table width="100%">
  177. <tr>
  178. <td align="center">
  179. <?php
  180. if( isset($_POST['winner']) && isset($_POST['result']) && isset($_POST['round']) )
  181. {
  182. $conn = mysql_connect('localhost', 'treelo', 'joseph')
  183. or die('Invalid query:' . mysql_error());
  184.  
  185. $rs = mysql_select_db('boxchamp_test', $conn)
  186. or die('Invalid query:' . mysql_error());
  187.  
  188. $sql = "UPDATE prediction SET winner='".$_POST['winner']."', result='".$_POST['result']."', round='".$_POST['round']."' WHERE fight='fight3'";
  189.  
  190.  
  192.  
  193. $rs = mysql_query($sql,$conn)
  194. or die('Invalid query:' . mysql_error() . '<br /> $sql was : ' . $sql); 
  195. } else {
  196. echo "POST VARS not filled out";
  197. }
  198. ?>
  199. </td>
  200.   </tr>
  201. </table>
  202. </table>
  203. <br />
  204. <br />
  205. <table cellspacing="0" cellpadding="0" width="100%">
  206.   <tr>
  207.     <td class="th2">Fight 1 Result</td><td class="th2">Fight 2 Result</td><td class="th2">Fight 3 Result</td>
  208. </tr>
  209. <tr>
  210.     <td class="pred1">
  211.     <?php
  212.         $results = mysql_query("SELECT *  FROM prediction WHERE fight = 'fight1'") or die(mysql_error());
  213.         
  214.      $row = mysql_fetch_array($results);
  215.      
  216.     echo $row['winner'].'<br />';
  217.      echo $row['result'].'<br />';
  218.     echo $row['round'].'<br />';
  219.  ?>
  220. </td>
  221. <td class="pred1">
  222.     <?php
  223.         $results = mysql_query("SELECT *  FROM prediction WHERE fight = 'fight2'") or die(mysql_error());
  224.         
  225.      $row = mysql_fetch_array($results);
  226.      
  227.     echo $row['winner'].'<br />';
  228.      echo $row['result'].'<br />';
  229.     echo $row['round'].'<br />';
  230.  ?>
  231. </td>
  232.  
  233. <td class="pred1">
  234.     <?php
  235.         $results = mysql_query("SELECT *  FROM prediction WHERE fight = 'fight3'") or die(mysql_error());
  236.         
  237.      $row = mysql_fetch_array($results);
  238.      
  239.     echo $row['winner'].'<br />';
  240.      echo $row['result'].'<br />';
  241.     echo $row['round'].'<br />';
  242.  ?></td>


the problem im having is im updating all the fights each time i submit

i can see why its happenening but i dont know how to fix the problem

anyone?
Reply With Quote
  #2  
Old March 29th, 2004, 03:58 AM
Nicky's Avatar