PHP - Update Database With A Single Button

When I display the data in my database I have included a radio button in each row. When the button is clicked, the intention is to delete all the information in that row. But it won't delete anything...

Here's the form:
Code: [Select]
<FORM Method = "POST" action ="update_tee_times.php">
 
<?php

include("opendatabase.php"); 

$dateID = $_POST[teetimedate];

$result = mysql_query("
SELECT Date, Player1,Player2,Player3,Player4,Player5,Time, IF( TIME(Time) BETWEEN '17:30:00' AND '19:30:00','FFFF66','FFFFFF') AS color
FROM Daysheets
WHERE Date ='$dateID'"); 

echo "<h1>";
echo date("l, F d, Y", strtotime($dateID));
echo "</h1>";

echo "<table align=center width=700 border=1>\n";
echo "<th>Clear</th><th>Time</th><th>Player 1</th><th>Player 2</th><th>Player 3</th><th>Player 4</th><th>Player 5</th>
<th>M</th><th>W</th><th>G</th>";

$i=0;

while($row = mysql_fetch_array( $result )) 
{
$dateID = $row['Date'];
$timeID = $row['Time'];

echo "<tr>";
echo "<td>";
echo "<input type='radio' name='time1[$i]' value='$timeID'>"; //HERE'S THE RADIO BUTTON
echo "</td><td>";
echo date("g:i ", strtotime($row[Time]));
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player1]' name='player1[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player2]' name='player2[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player3]' name='player3[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player4]' name='player4[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player5]' name='player5[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='2' value= '$row[Men]' name='women'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='2' value= '$row[Women]' name='women'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='2' value= '$row[Guest]' name='guests'
style ='background-color:#{$row['color']};'>";

echo "<input type='hidden' name='date[$i]' value='$dateID'>";
echo "<input type='hidden' name='time2[$i]' value='$timeID'>";
echo "</td></tr>";
$i++;
}
echo "</table>";

mysql_close($con);

?>
<br /><br />

<input type="Submit" name="Submit" value="Update Tee Times">
</FORM> And here's the form action:
Code: [Select]
<?php

header("Location: /teetimes/preteetimesadmin.php");

include("opendatabase.php");

$size = count($_POST['player1']);
$timeID1 = $_POST['time1'][$i];

//HERE'S WHERE I'M TRYING TO DELETE THE DATA.
mysql_query("
UPDATE Daysheets
SET 
        Player1='',
        Player2='',
        Player3='',
        Player4='',
        Player5=''
WHERE Time ='$timeID1' ");

//HERE'S THE UPDATE, WHICH WORKS FINE.
$i=0;

while ($i < $size)
     {
     $dateID = $_POST['date'][$i];
     $timeID2 = $_POST['time2'][$i];  
     $player1 = ($_POST['player1'][$i]);
     $player2 = ($_POST['player2'][$i]);
     $player3 = ($_POST['player3'][$i]);
     $player4 = ($_POST['player4'][$i]);
     $player5 = ($_POST['player5'][$i]);

mysql_query("
UPDATE Daysheets
SET 
        Player1='$player1',
        Player2='$player2',
        Player3='$player3',
        Player4='$player4',
        Player5='$player5'

WHERE Date ='$dateID' 
AND Time ='$timeID2' ");
     $i++;
}

mysql_close($con)

?>When I add or update any information it works fine. It just won't delete anything where the radio button is clicked.
Any help appreciated! Thanks.

Hi there.
I have this course registering website whereby i will need to :
1. pull out all course info and display (done that)
2. when user choose the course they are interested in using radio button and click submit , it will display you're registered and update the database to decrease the head count by 1.

i m stuck on the radio button part... after i click submit nothing happens...

Please advice... thanks a lot


Code: [Select]
<html>
<head>
  <title>TimeTable</title>

</head>

<body>
 <h1> Here is the timetable</h1>

<?php


     
  @ $db = new mysqli('localhost', 'root', '', 'mylifestyle');

  if (mysqli_connect_errno()) {
     echo 'Error: Could not connect to database.  Please try again later.';
     exit;
  }
  
  $query = "SELECT course.CourseName , course.Instructor , course.ClassSize , courseschedule.Date ,courseschedule.Time , courseschedule.Location FROM course INNER JOIN courseschedule ON course.CourseID = courseschedule.CourseID";
  $result = $db->query($query);
  $num_results = $result->num_rows;
  
  
  echo "<table border='1'>
  <tr>
  <th>Course Name</th>
  <th>Instructor</th>
  <th>Class size</th>
  <th>Date</th>
  <th>Time</th>
  <th>Location</th>
  <th>Register</th>
  </tr>"; ?>
 
<?php 

  for ($i=0; $i <$num_results; $i++) {
     $row = $result->fetch_assoc();?>
  <tr>
      <form action = ""
          method = "post">
<td><? echo $row['CourseName']; ?></td>
<td><? echo $row['Instructor']; ?></td>
<td><? echo $row['ClassSize']; ?></td>
<td><? echo $row['Date']; ?></td>
<td><? echo $row['Time']; ?></td>
<td><? echo $row['Location']; ?></td>


<td align="center"><input name="radio" type="radio" id="radio[]" value="<? echo $row['ClassSize']; ?>"></td>
</tr>
<?php
}
?>

<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="submit" type="submit" id="submit" value="submit"></td>

 
 <?php




if($submit){
for($i=0;$i<$num_results;$i++){
$del_id = $radio[$i];
$query = "UPDATE course SET ClassSize = ClassSize -1 Where id='$del_id'";
$result = mysql_query($query);
}

// if successful redirect to delete_multiple.php
if($result){

echo  "$CourseName was deleted from database - myliftstyle!!<br />";

// Compute the item costs and total cost
 

  }
  }



    ?>

   </div>
</body>
</html>
[attachment deleted by admin]

Which languages do I need to make this happen? And I am unsure of how to incorporate PHP within a javascript query and what jQuery functions I will need. 

Hi, I've been scratching my head for a while now about how to do this, I'm relatively new to php and mysql and perhaps foolishly taking on creating a user area for a website.  I have everything else working, all of my register account functions and confirmations and all of the login scripts etc. 

I have created a profile page which returns various information to the user (this bit works fine) and I've got some nice show/hide toggles running with some javascript/css but my intention is to allow the user to change thier information (e-mail address, contact phone number and also whether they are subscribed to the e-mail list), it also displays any support tickets or messages.

So after the long intro, here's what I'm struggling with...  I have a form in a visibility toggled <div> which submits a 'change_email' script, so a user wants to change their e-mail, clicks on change, the <div> appears, they bang in the new e-mail and hit submit.

My php script appears to work (because it doesn't throw up any errors), until you realise that actually it's not updated the record in the db...

I'm using mysql_query("UPDATE users SET email='$new_email' WHERE username='$user'");

Do I need to setup variables for all of the information in the db (name, username, password, email, contno etc etc) and include them in the command to get it to work or should that just pick the correct record and then update it? If that is the case is there a way I can include 'blank' variables so I don't have to set them all up...

e.g.  mysql_query("UPDATE users SET user='',password='',email='$new_email', etc WHERE username='$user'");

Many thanks in anticipation

Hi i have this simple update form and scrip but somehow it doesnt seem to be update the field on the database can someone help out please.
The html form is the second form bellow where the action send to status_update.php
HTML FORM
Code: [Select]
<?php                include("../header.html");            ?>
<?php                include("header_news.html");            
extract($_REQUEST,EXTR_SKIP);
?><?php            
/*                print("sfilm_refnum = $sfilm_refnum<BR>");                
print("sfilm_addr01 = $sfilm_addr01<BR>");                
print("sfilm_postcode = $sfilm_postcode<BR>");                
print("Film Client = $fclient<BR>");            */             
?>           
<form id="search" action="list.php" method="post" name="search">               
<table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#eeeeee">                   
<tr>                       
<td align="right" width="140"></td>                       
<td width="320"><span class="hofblack10">                           
</span>                           
</td>                       
<td align="center" width="100"><input type="hidden" name="lstart" value="<?php print("$lstart"); ?>" /><input type="hidden" name="lend" value="<?php print("$lend"); ?>" /><input type="hidden" name="lamount" value="<?php print("$lamount"); ?>" /></td>                        <td align="center" width="100"></td>                       
<td align="right"></td>                   
</tr>               
</table>           
</form>           
<table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#4050c4">               
<tr>                 
<td width="60" class="hofwhite10">action</td>                   
<td width="140"><span class="hofwhite14">DATE</span></td>                   
<td width="80"><span class="hofwhite14">ID</span></td>                   
<td><span class="hofwhite14">News Titile</span></td>                   
<td width="100"><span class="hofwhite14">Status</span></td>               
</tr>               
<tr height="0">                 
<td bgcolor="white" width="60"></td>                   
<td bgcolor="white" width="140" height="0"></td>                   
<td bgcolor="white" width="80" height="0"></td>                   
<td bgcolor="white" height="0"></td>                   
<td bgcolor="white" width="100" height="0"></td>               
</tr>           
</table><table width="780" border="0" cellspacing="0" cellpadding="4"><tr>                   
<td width="60"></td>                 
<td width="80"></td>                   
<td><a class="blueullrg" href="add.php">Add News</a></td>                   
<td align="right" width="120"></td>               
</tr>               
<tr height="0">                   
<td width="60" height="0"></td>                 
<td width="80" height="0"></td>                   
<td height="0"></td>                   
<td align="right" width="120" height="0"></td>               
</tr>           
</table>  <?php          
//get the DB connection variables    
include("../../../includes/config.php");        
//connect to DB        
$connection = @mysql_connect($db_address,$db_username,$db_password) or die("Couldn't CONNECT.");        
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select DATABASE.");                
$query2="SELECT * FROM news WHERE !(news_status='deleted')";        
$result2 = mysql_query($query2) or die("Couldn't execute QUERY - Select NEWS Qty");        
$fqty = mysql_num_rows($result2);            
//SELECT or FIND the same USERNAME        
$query3="SELECT * FROM news WHERE !(news_status='deleted') ORDER BY news_id DESC";        
$result3 = mysql_query($query3) or die("Couldn't execute QUERY - Select NEWS");        
while ($row = mysql_fetch_array($result3))            
{                
$news_id                 = $row['news_id'];                
$news_title                = $row['news_title'];                
$news_story                = $row['news_story'];                
$news_image                = $row['news_image'];                
$news_image_caption        = $row['news_image_caption'];                
$news_image_link        = $row['news_image_link'];                
$news_date_day            = $row['news_date_day'];                
$news_date_month        = $row['news_date_month'];                
$news_date_year            = $row['news_date_year'];                
$news_status            = $row['news_status'];                
$news_website            = $row['news_website'];                
$news_date_created        = $row['news_date_created'];        
        $news_date_modified        = $row['news_date_modified'];    ?>           
        <table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#eeeeee">               
        <tr>                 
        <td width="60"><span class="hofblack10">                   
         <?php                    
         if($news_status=="deleted"){                        
         print("<a class='hifblack10'>deleted</span>");                    
         }ELSE{                        
         print("<a class='blueul' href='edit.php?id=$news_id'>edit</a>");                    
         }                    
         ?>                 
          </span></td>                   
          <td width="140"><span class="titlegrey12">                     
          <?php                      
          if(!$news_date_day) 
          { echo "00"; }
          else{ echo $news_date_day; }                      
          echo "/";                     
           if(!$news_date_month) { echo "00"; }else{ echo $news_date_month; }                      
           echo "/";                      
           if(!$news_date_year) { echo "0000"; }else{ echo $news_date_year; }                    
           ?>                   
           </span></td>                   
           <td width="80"><span class="titlegrey12"><?php                    print("$news_id");                    ?></span>
           </td>                   
           <td><?php                    
           if($news_status=="deleted")
           {                        
           print("<class='hofblack10'>$news_title</span>");                    
           }ELSE{                        
           print("<a class='blueul' href='edit.php?id=$news_id'>$news_title</a>");                    
           }                    
           ?></td>                   
           <td width="100">                       
           <form id="list_update" action="status_update.php" method="post" name="list_update">                           
        <select name="newnstatus" size="1">                               
           <option  <?php if($row['news_status'] == "") 
           {
            print("selected");
           } ?>
           selected="selected" value="">Status...</option>                               
           <option  <?php if($row['news_status'] == "on")
           {
            print("selected");
           } ?> value="on">On</option>
               <option  <?php if($row['news_status'] == "off")
           {
            print("selected");
           } ?> value="off">Off</option>
            <option  <?php if($row['news_status'] == "deleted")
           {
            print("selected");
           } ?> value="deleted">Delete</option>
        </select>
         <input type="hidden" name="nstatus" value="<?php echo $row[news_status]; ?>" />                           
           <input type="hidden" name="id" value="<?php echo $row[news_id]; ?>" />                       
           <input type="submit" name="update" value="update" />                       
           </form>                     
            </td>               
            </tr>               
            <tr height="0">                 
            <td bgcolor="white" width="60"></td>                   
            <td bgcolor="white" width="140" height="0"></td>                   
            <td bgcolor="white" width="80" height="0"></td>                   
            <td bgcolor="white" height="0"></td>                   
            <td bgcolor="white" width="100" height="0"></td>               
            </tr>           
            </table>
            <?php            }        mysql_close($connection);//}?>           
            <table width="780" border="0" cellspacing="0" cellpadding="4">         
            <tr>                   
            <td width="60"></td>                 
            <td width="80"></td>                   
            <td><a class="blueullrg" href="add.php">Add News</a></td>                   
            <td align="right" width="120"></td>               
            </tr>           
            </table><?php                // include("list_navigation.html");            ?>
            <?php                include("../footer.html");            ?>
            </div></body></html>
The action script php
Code: [Select]
<?php
/*    echo "fstatus: ".$fstatus."<BR>";    
echo "id: ".$id."<BR>";    
echo "fclient: ".$fclient."<BR>";    
echo "newfstatus: ".$newfstatus."<BR>";*/    
//set the date of agreement        
$timestamp = date('l jS \of F Y h:i:s A');    
//get the DB connection variables        
include("../../../includes/config.php");
//connect to DB        
$connection = @mysql_connect($db_address,$db_username,$db_password) or die("Couldn't CONNECT.");        
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select FILMS DATABASE.");    
// All appears well, so enter into database                
$query= "UPDATE news SET news_status = '$newnstatus' WHERE news_id='$id'";

$result = mysql_query($query) or die("could not execute query - Update FILMS Record to DB");    
//setup an email to the Admin @ hof, w/o attachment            
$emailto="xx@xxx.co.uk";        
$emailfrom="no-reply@xxxx.co.uk";        
$emailsubject="xx Record Updated";        
$emailmessage="Hello Registrar\n\n";        
$emailmessage.="News ID: ".$id."\n";        
$emailmessage.="Updated on: ".$timestamp."\n\n";        
$emailmessage.="Status was: ".$nstatus."\n";        
$emailmessage.="Status now: ".$newfnstatus."\n";        
$emailmessage.="Thank you,\n\n";        
$emailmessage.="Web Site ROBOT\n";        
$emailmessage.="(Administrator)\n";        
$emailmessage.="xxx.co.uk | xxx.biz\n";        
$emailmessage.="----------------------------------------------\n";        
$emailmessage.="e. http://www.xxx.co.uk/contact.php\n";        
$emailmessage.="w. http://www.xxx.co.uk\n";        
$emailheader="From: xxx.co.uk<$emailfrom>";
$emailheader  .= 'Cc: xxx@xxx.co.uk'."\r\n";
$emailheader  .= 'Bcc: xxx@xxxxx.co.uk'."\r\n";        
$ok=mail($emailto,$emailsubject,$emailmessage,$emailheader);        
mysql_close($connection);            
if ($ok)
 {        
 header("Location: list.php"); 
 /* Redirect browser */        
 exit;    
 } else {        
 $errmsg="There was a problem, please try later or telephone us direct.";        
 $errsta="1";        
 include("edit_error.html");        
 //echo "<p>Mail could not be sent. Sorry!</p>";        
 exit;    
 }        
 ?> Thanks in advance