PHP - Update Multiple Rows On Submit

Hello all, im new to this forum, im a noobie, just started coding about 3 weeks ago, don't be too hard on me.   My question is I wan't to check for challenges a user's team posted that have not been excepted after 1 day, then auto refund the user's team back there credits, and then also delete all the challenges. So far here is my code.

//Delete all matches not accepted after 1 day
$arrayin = array();
$autorefund = mysql_query("SELECT * FROM `challenges` WHERE `a` = " . $team['id'] . " "
. "AND `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 AND (`expires` < " . ((int) time()) . ")");
if (mysql_num_rows($autorefund) > 0) {
while ($autorefund = mysql_fetch_assoc($autorefund)) {
$arrayin[] = $autorefund['id'];
mysql_query("UPDATE `teams` SET `balance` = `balance` + " . $autorefund['credits'] . " "
. "WHERE `id` IN (" . mysql_real_escape_string(implode(',', $arrayin)) . ")");
mysql_query("DELETE FROM `challenges` WHERE `a` IN "
. "(" . mysql_real_escape_string(implode(',', $arrayin)) . ") "
. "AND `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 "
. "AND (`expires` < " . ((int) time()) . ")");
}
}

FYI here is the code i had, it works fine, however it will only delete 1 challenge per team, not all of there challenges. 

$autorefund   = mysql_query("SELECT * FROM `challenges` WHERE `a` = " . $team['id'] . " AND  `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 AND (`expires` < ".((int)time()).")");
if (mysql_num_rows($autorefund) > 0) {
while ($autorefund  = mysql_fetch_assoc($autorefund)) {
if ($autorefund['accepted'] == 0 and $autorefund['expires'] < time()) {
mysql_query("UPDATE `teams` SET `balance` =  `balance` + " . $autorefund['credits'] . " WHERE `id` = " . $team['id'] . "");
mysql_query("DELETE FROM `challenges` WHERE `a` = " . $team['id'] . " AND  `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 AND (`expires` < ".((int)time())."));
}
}
}

I inherited this script, its using deprecated statements, i know im not skilled to rewrite the entire site to use prepared statements.

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=325508.0

Hi All,

I'm hoping someone can help me. I'm looking to create a form that will submit multiple entries to a MySQL database depending on the options selected on the form. I am able to submit single entries, but the multiple entire is a bit of a mystery to me.

I have attached an JPG image to show an example of how I would like the form to work.

I have also added the description/explination below to this example:

Example 1            
The form was completed and three access types were selected. Thus Three entries, all with the Same Reference number were captured into the database   
         
Example 2            
The form was completed and Two Access Types were selected. Thus Two entries, all with the Same Reference number were captured into the database            
Example 3            
The form was completed and Four Access Types were selected. Thus Four entries, all with the Same Reference number were captured into the database      

Hello all,

i have a table that displays data from mysql, now i want to update multiple rows from that table with checkboxes, the value will basically just switch from 'new' to 'done' so far i have this:

Code: [Select]
<tbody>
                                        <tr class="first">
        </tr>
<?php
$ticketde=0;
while ($ticketde < $numpscde) {

$f1pscde=mysql_result($ticketresultde,$ticketde,"id");
$f2pscde=mysql_result($ticketresultde,$ticketde,"ticket");
$f4pscde=mysql_result($ticketresultde,$ticketde,"date");
$f5pscde=mysql_result($ticketresultde,$ticketde,"ip");
$f6pscde=mysql_result($ticketresultde,$ticketde,"done");

$setdone = ($f6pscde["done"] == 'n') ? "<a href=\"donepsc.php?id=".$f1pscde."\"><img src=\"ico_new.gif\" alt=\"new\" /></a>" : $f6pscde["done"];

if(isset($_POST['setdone'])){$checkbox = $_POST['checkbox'];

$id = "('" . implode( "','", $checkbox ) . "');" ;
$sql = "UPDATE ticket
        SET done='done'
        WHERE id='$f1pscde'";
$result = mysql_query($sql) or die(mysql_error());
}

?>

<tr class="first">
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f1pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f2pscde; ?></font></td>

<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f5pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $setdone; ?></font></td>
<td class="tc"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $f1pscde['id']; ?>"></td>


</tr>


<?php
$ticketde++;
}
?>
</tbody>
</table>
                                    <center><input type="submit" name="setdone" id="setdone" value="Set selected  to done" class="button"/>   
                                 -     <input type="submit" name="exporttxt" id="exporttxt" value="Export selected to .txt" class="button"/>
                                    </center>
                                   
</fieldset>
</form>
                           
I found that checkbox code sample on some other site and tried to implement it, i don't really know where to go from here, as it's a total mess to me now, any help would be greatly appreciated.

Hi, after banging my head against the wall for a while thinking this would be a simple task, I'm discovering that this is more complicated than I thought.

Basically what I have is a link table linking together source_id and subject_id.   For each subject there are multiple sources associated with each.

I had created a basic listing of sources by subject... no problem.   I now need a way of having a form to create an ordered list in a user-specified way.  In other words, I can currently order by id or alphabetically (subject name lives on a different table), but I need the option of choosing the order in which they display.  I added another row to this table called order_by.  No problem again, and I can manage all of this in the database, however I want to create a basic form where I can view sources by subject and then enter a number that I can use for sorting.

I started off looping through each of the entries and the database (with a where), and creating a foreach like so (with the subject_id being grabbed via GET from the URL on a previous script)
Code: [Select]
while($row = mysqli_fetch_array($rs)) {


//update row order
if (isset($_POST['submit']))  {

//get variables, and assign order

$subject_id = $_GET['subject_id'];
$order_by = $_POST['order_by'];
$source_id = $row['source_id'];


//echo 'Order by entered as ' . $order_by . '<br />';

foreach ($_POST['order_by'] as $order_by) {

$qorder = "UPDATE source_subject set order_by = '$order_by'
WHERE source_id = '$source_id'
AND subject_id = '$subject_id'";

mysqli_query($dbc, $qorder)
or die ('could not insert order');

// echo $subject_id . ', ' . $order_by . ', ' . $source_id;
// echo '<br />';
} 
}
else {
$subject_id = $_GET['subject_id'];
$order_by = $row['order_by'];
$source_id = $row['source_id'];

}

And have the line in the form like so:
Code: [Select]
echo '<input type="text" id="order_by" name="order_by[]" size="1" value="'. $order_by .'"/>

(yes I know I didn't escape the input field... it's all stored in an htaccess protected directory;  I will clean it up later once I get it to work)

This, of course, results in every source_id getting the same "order_by" no matter what I put into each field.

I'm thinking that I need to do some sort of foreach where I go through foreach source_id and have it update the "order_by" field for each one, but I must admit I'm not sure how to go about this (the flaws of being self-taught I suppose;  I don't have anyone to go to on this).

I'm hoping someone here can help?

Thanks a ton in advance

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=351561.0

Ok I'm trying to insert multiple rows by using a while loop but having problems. At the same time, need to open a new mysql connection while running the insert query, close it then open the previous mysql connection.

I managed to insert multiple queries before using a loop, but for this time, the loop does not work? 
I think it is because I am opening another connection... yh that would make sense actually?

Here is the code:


$users = safe_query("SELECT * FROM ".PREFIX."user");
       while($dp=mysql_fetch_array($users)) { 
          
   $username = $dp['username'];
 $nickname = $dp['nickname'];
 $pwd1 = $dp['password']; 
 $mail = $dp['email'];
 $ip_add = $dp['ip'];
 $wsID = $dp['userID'];
 $registerdate = $dp['registerdate'];
 $birthday = $dp['birthday'];
 $avatar = $dp['avatar'];
 $icq = $dp['icq']; 
 $hp = $dp['homepage'];
 
echo $username." = 1 username only? :(";
      

// ----- Forum Bridge user insert -----

$result = safe_query("SELECT * FROM `".PREFIX."forum`");
$ds=mysql_fetch_array($result);
$forum_prefix = $ds['prefix'];
define(PREFIX_FORUM, $forum_prefix);
define(FORUMREG_DEBUG, 0);

$con = mysql_connect($ds['host'], $ds['user'], $ds['password']) or system_error('ERROR: Can not connect to MySQL-Server');
$condb = mysql_select_db($ds['db'], $con) or system_error('ERROR: Can not connect to database "'.$ds['db'].'"');
                
include('../_phpbb_func.php');
$phpbbpass = phpbb_hash($pwd1);
$phpbbmailhash = phpbb_email_hash($mail);
$phpbbsalt = unique_id();

safe_query("INSERT INTO `".PREFIX_FORUM."users` (`username`, `username_clean`, `user_password`, `user_pass_convert`, `user_email`, `user_email_hash`, `group_id`, `user_type`, `user_regdate`, `user_passchg`, `user_lastvisit`, `user_lastmark`, `user_new`, `user_options`, `user_form_salt`, `user_ip`, `wsID`, `user_birthday`, `user_avatar`, `user_icq`, `user_website`) VALUES ('$username', '$username', '$phpbbpass', '0', '$mail', '$phpbbmailhash', '2', '0', '$registerdate', '$registerdate', '$registerdate', '$registerdate', '1', '230271', '$phpbbsalt', '$ip_add', '$wsID', '$birthday', '$avatar', '$icq', '$hp')");
if (FORUMREG_DEBUG == '1') {
echo "<p><b>-- DEBUG -- : User added: ".mysql_affected_rows($con)."<br />";
       echo "<br />-- DEBUG -- : Query used: ".end($_mysql_querys)."</b></p><br />";
      
       $result = safe_query("SELECT user_id from ".PREFIX_FORUM."users WHERE username = '$username'");
       $phpbbid = mysql_fetch_row($result);
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('2', '$phpbbid[0]', '0', '0')");
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('7', '$phpbbid[0]', '0', '0')");
mysql_close($con);
}

         include('../_mysql.php');        
         mysql_connect($host, $user, $pwd) or system_error('ERROR: Can not connect to MySQL-Server');
mysql_select_db($db) or system_error('ERROR: Can not connect to database "'.$db.'"');
       
       }



So I need to be able to insert these rows using the while loop.. how can I do this?

I really appreciate any help.

Say I have an "Entries" table. I want to submit same multiple entries using a form submission. And If I have other queries submitted in the same form, I want those quarries to be submitted only once.  Is that possible to do? 

Here's my code.

if(isset($_POST['submit'])) {

  $entries = 10;

  $id   = 55;
  $name = 'Smith';

  $insert = $db->prepare("INSERT INTO entries(id, name) VALUES(:id, :name)");
  $insert->bindParam(':id', $id);
  $insert->bindParam(':name', $name);
  $result_insert = $insert->execute();
  if($result_insert == false) {
    echo 'Fail';
  } else {
    echo 'Success';
  }

}
?>
<form action="" method="post">
  <input type="submit" name="submit" value="SUBMIT" />
</form>

 

Edited January 13, 2019 by imgrooot

I want to echo out a few subcategories per main category.
It should be a maximum of 20 entries per column

At this stage I have the following... It echo's the results out in 4 columns and not what I want.
Any suggestions?

$query = "SELECT 
adsubcat.name AS subname, adsubcat.linkname AS sublink, adcat.clinkname AS clink
FROM adsubcat 
JOIN adcat ON adcat.id=adsubcat.catid
WHERE adsubcat.catid='$catid' ORDER BY adsubcat.name ASC";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)) {

$count = 0;

print '<table style="text-align:left;margin-left:0px;width:943px;">'."\n";
while ($row = mysql_fetch_assoc($result)){
$gal = '<a href="'.$root.'/'.$row['clink'].'/'.$row['sublink'].'">'.$row['subname'].'</a>';
if ($count == 0){
print '<tr>';
}
++$count;
print '<td>'.$gal.'</td>';
if ($count == 4){
$count = 0;
print'</tr>'."\n";
}
}
print'</table>'."\n";
}

Hi,

Ok, so I'm making a registration form system, where I can create new registration forms for the users to pick a date etc.

In my form I can add and remove text fields via Javascript - to add additional dates etc. so I don't know if I'll be submitting 3 fields or 15.

The could look like this:
<input type="hidden" name="session_id[]" value="<?php echo $session_id; ?>">
<input type="text" name="picked_date[]">
<input type="text" name="picked_room[]">

They are put in a big array:
De bliver smidt i et stort array:
$n=0;
    foreach ($session_id as $_session_id) {
        $bigar[$n][1] = $_session_id;
        $n++;
        }
        $n=0;
    foreach ($picked_date as $_picked_date) {
        $bigar[$n][2] = $_picked_date;
        $n++;
        }
        $n=0;
    foreach ($picked_room as $_picked_room) {
        $bigar[$n][3] = $_picked_room;
        $n++;
        }
        $n=0;

which is then updated in the database using:
foreach ($bigar as $part)
{
mysql_query("UPDATE...
}

Right - so far so good. The updating works fine with existing fields, but if I remove some of the fields (via JS) it obviously only updates the remaining in the array. The left out will be ignored. On the same note I would like to add fields as well, so - the bottom line - I want to:

- UPDATE rows, where the ID is in the array
- DELETE existing rows, WHERE the ID is NOT in the array
- CREATE new rows for the new fields in the array (not having an ID)

How can this be achieved? Hope someone can help...

My site seems to be going well, but on the back end, the users database is going crazy with duplicate entrys. but its not doing it from an INSERT. it seems to be doing it with this code:
Code: [Select]
               $bitquery = $bitcoin->move("bittleship$username", "bittleships", $cost, $minconfirmations);
               if ($bitquery == true){
               $query = mysql_query("INSERT INTO `transactions` ( `id` , `username` , `type` , `amount`, `address`) VALUES ('', '$username', 'buyclicks', '$cost', '')")  or die(mysql_error());
               $query = mysql_query("UPDATE users SET `clicks` = `clicks`+$quantity, `balance`=`balance`-$cost WHERE `username` = '$username' ") or die(mysql_error());
               include('update.php');

Hey. Third question today. Very stuck on this one. I am displaying a ton of while loops to display a bunch of data from two different tables. there is NO possible way i can combine the two tables. I mean, I can, but I'm not going to because they are two totally different thins. Anyway. Here is what I'm trying to do:
Lets say I have 3 items, a grape, an orange and an apple.
- 3 apples
- 2 oranges
- 1 grape

I'm displaying an update price box for each different fruit. (so 3 different boxes), and one submit button.

I update it, and it does update the price but it only updates the very first row. I want to be able to update every row I types the price in for. Here is my code: (it is quite long):
Code: [Select]
<?php
session_start();
include("config536.php");
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>

<?php
if(!isset($_SESSION['username'])) {
echo "<banner></banner><nav>$shownavbar</nav><ubar><a href=login.php>Login</a> or <a href=register.php>Register</a></ubar><content><center><font size=6>Error!</font><br><br>You are not Logged In! Please <a href=login.php>Login</a> or <a href=register.php>Register</a> to Continue!</center></content>";
}

if(isset($_SESSION['username'])) {
echo "<nav>$shownavbar</nav><ubar>$ubear</ubar><content><center><font size=6>User Shops</font><br><br>";

$action = $_GET['action'];

if(!isset($action)) {
echo "<a href=?action=edit>Edit Shop</a> | <a href=?action=view&user=$showusername>View Shop</a> | <a href=?action=stock>View Stock</a> | <a href=?action=quick>Quick Stock</a><br><br>";
}
if(isset($action)) {
$getshopq = "SELECT * FROM usershops WHERE owner='$showusername'";
$getshop = mysql_query($getshopq);
while($tri = mysql_fetch_array($getshop)) {
$theid = $tri['ushopid'];
$owner = $tri ['owner'];
$desc = $tri['description'];
$image = $tri['image'];
$name = $tri['name'];
$status = $tri['status'];
$discount = $tri['discount'];
}

$countq = "SELECT * FROM usershops WHERE owner='$showusername'";
$countit = mysql_query($countq);


 if($action == "edit") {
echo "<a href=?action=edit>Edit Shop</a> | <a href=?action=view&user=$showusername>View Shop</a> | <a href=?action=stock>View Stock</a> | <a href=?action=quick>Quick Stock</a><br><br><font size=5>Edit Shop</font><br><br>";
if(mysql_num_rows($countit)) {
?>
<form action="<?php echo "$PHP_SELF"; ?>" method="POST">
<?php
}
if(!mysql_num_rows($countit)) {
$create = $_POST['create'];
$thename = $_POST['thename'];
$thedesc = $_POST['thedesc'];
$thestatus = $_POST['thestatus'];
$theimage = $_POST['theimage'];
if(!isset($create)) {
?>
<form action="<?php echo "$PHP_SELF"; ?>" method="POST">
Shop Name: <input type="text" name="thename"><br>Description<br><textarea name="thedesc" rows="5" cols="25"></textarea><br>
Status: <select name="thestatus">
<option>Open</option>
<option>Closed</option>
<option>Gallery</option>
</select><br><br>
<input type="submit" name="create" value="Create Shop"></form>
<?php
}
if(isset($create)) {
 if($thename == "" || $thedesc == "") {
echo "<font color=red>Error! Please fill out the entire form!</font><br><br>";
?>
<form action="<?php echo "$PHP_SELF"; ?>" method="POST">
Shop Name: <input type="text" name="thename"><br>Description<br><textarea name="thedesc" rows="5" cols="25"></textarea><br>
Status: <select name="thestatus">
<option>Open</option>
<option>Closed</option>
<option>Gallery</option>
</select><br><br>
<input type="submit" name="create" value="Create Shop"></form>
<?php
}
if($thename != "" && $thedesc != "") {
mysql_query("INSERT INTO usershops (owner, name, description, image, status, discount) VALUES ('$showusername', '$thename', '$thedesc', 'image.gif', '$thestatus', 'None')");
echo "<font color=green>Success! You have created your shop! Click <a href=?action=view>here</a> to view it.</font><br><br>";
}
}
}

}

 if($action == "view") {
echo "<a href=?action=edit>Edit Shop</a> | <a href=?action=view&user=$showusername>View Shop</a> | <a href=?action=stock>View Stock</a> | <a href=?action=quick>Quick Stock</a><br><br><font size=5>Shop Name Here</font><br><br>";

$wowq = "SELECT * FROM uitems WHERE username='$showusername' AND location='2'";
$wow = mysql_query($wowq);
while($wrow = mysql_fetch_array($wow)) {
$umid = $wrow['uitemid'];
$umiid = $wrow['theitemid'];
$umloc = $wrow['location'];
$umprice = $wrow['price'];

$infoq = "SELECT * FROM items WHERE itemid='$umiid'";
$info = mysql_query($infoq);
while($row = mysql_fetch_array($info)) {
$myname = $row['name'];
$myid = $row['itemid'];
$myimage = $row['image'];
$mydesc = $ow['description'];
$myrarity = $row['rarity'];

echo "$myname";
}
}
}
 if($action == "stock") {
$setprice = $_POST['price'];
$updateprice = $_POST['updateprice'];

echo "<a href=?action=edit>Edit Shop</a> | <a href=?action=view&user=$showusername>View Shop</a> | <a href=?action=stock>View Stock</a> | <a href=?action=quick>Quick Stock</a><br><br><font size=5>Stock Shop</font><br><br>";
$eq = "SELECT * FROM uitems WHERE username='$showusername' AND location='2' GROUP BY theitemid";
$ee = mysql_query($eq);
while($erow = mysql_fetch_array($ee)) {

$eeloc = $erow['location'];
$eeid = $erow['theitemid'];
$eenowid = $erow['uitemid'];
$eeprice = $erow['price'];

$wq = "SELECT * FROM items WHERE itemid='$eeid'";
$ww = mysql_query($wq);
while($wrow = mysql_fetch_array($ww)) {

$cq = mysql_query("SELECT * FROM uitems WHERE username='$showusername' AND location='2' AND theitemid='$eeid'");
$lcq = mysql_num_rows($cq);
$fid = $wrow['itemid'];
$fname = $wrow['name'];
$fimage = $wrow['image'];
$frarity = $wrow['rarity'];
$fdesc = $wrow['description'];

echo "$fname<br><img src=/images/items/$fimage>";
?>
<form action="<?php echo "$PHP_SELF"; ?>" method="POST">
<input type="text" name="price" maxlength="5"><br><br>
<?php
}
}
if(isset($updateprice)) {
mysql_query("UPDATE uitems SET price='$setprice' WHERE username='$showusername' AND theitemid='$fid'");
echo "<font color=green>Success! Your prices have been set and updated!</font>";
}
?>
<input type="submit" name="updateprice" value="Update Prices">
<br>
<?php

}

 if($action == "quick") {
echo "<a href=?action=edit>Edit Shop</a> | <a href=?action=view&user=$showusername>View Shop</a> | <a href=?action=stock>View Stock</a> | <a href=?action=quick>Quick Stock</a><br><br><font size=5>Quick Stock</font><br><br>";
}
}

}
?>

</html>
To help you find it, I'm asking about the "stock" $_GET part, about three quarters down. Thanks in advance for anybody who can help me, I've been stuck on this script all day! Thanks again!

I have 3 set of pages. The first html page only contains a search textbox and a submit button which then call up the second page search.php which populate html table with search result. The third page is update.php which allows to update the records populated by search.php.

The problem is that it when it update the records it automatically updates all rows in the table making all records look the same. I do not know where I have made a mistake please help. When I use phpadmin to update the records no problem as I can specifically input the cf_id number directly.


Search.php code
Code: [Select]
  <?php


  if(isset($_POST['submit'])){ 
  if(isset($_GET['go'])){ 
  if(preg_match("^/[A-Za-z]+/", $_POST['name'])){ 
   $name=$_POST['name']; 
  } 
  } 
  else{ 
  echo  "<p>Please enter a search query</p>"; 
  } 
}
//connect  to the database 


$con = mysql_connect("localhost","dbusrn","dbpwd");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("mydb", $con);
$name = $_POST['name'];
$result = mysql_query ("select * from Customer_Registration where Firstname like '%$name%' or lastname like '%$name%' ");



$row = mysql_fetch_row($result);
$cf_uid = $row[0];
$Firstname = $row[6];
$lastname = $row[7];
$Address = $row[8];
$Postcode = $row[9];
$Phone = $row[10];
$Email = $row[11];
$Customer_Type = $row[12];
$Computer_type = $row[13];
$Computer_maker = $row[14];
$Model = $row[15];
$OS = $row[16];
$Appointment_date = $row[17];
$Problem = $row[18];
$Solution = $row[19];
$Comment = $row[20];
?>
       

 <form action="updatecus.php" method="post">

<table width="100%" border="2" cellspacing="0" cellpadding="8">

<tr><td width="45%" class="FormText">Customer ID:</td>
<td width="55%"><?php echo $row[0];?></td></tr>
<tr><td width="45%" class="FormText">First name:</td>
<td width="55%"><input  name="Firstname" type="text" value="<?php echo $Firstname;?>"?> </td></tr>


<tr><td width="45%" class="FormText">Last name:</td>
<td width="55%"><input  name="lastname" type="text" value="<?php echo $lastname;?>"?> </td></tr>



<tr><td width="45%" class="FormText">Address:</td>
<td width="55%"><input  name="Address" type="text" value="<?php echo $Address; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Postcode:</td>
<td width="55%"><input  name="Postcode" type="text" value="<?php echo $Postcode; ?>"?> </td></tr>


 <tr><td width="45%" class="FormText">Phone:</td>
<td width="55%"><input  name="Phone" type="text" value="<?php echo $Phone; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Email:</td>
<td width="55%"><input  name="Email" type="text" value="<?php echo $Email; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Customer:</td>
<td width="55%"><input  name="Customer_Type" type="text" value="<?php echo $Customer_Type; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Computer :</td>
<td width="55%"><input  name="Computer_type" type="text" value="<?php echo $Computer_type; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Manufactural:</td>
<td width="55%"><input  name="Computer_maker" type="text" value="<?php echo $Computer_maker; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Model:</td>
<td width="55%"><input  name="Model" type="text" value="<?php echo $Model; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Operating System:</td>
<td width="55%"><input  name="OS" type="text" value="<?php echo $OS; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Appointment:</td>
<td width="55%"><input  name="Appointment_date" type="text" value="<?php echo $Appointment_date; ?>"?> </td></tr>

  <tr><td width="45%" class="FormText">Problem:</td>
<td width="55%"><textarea name="Problem" rows="10" cols="20" ><?php echo $Problem; ?></textarea></td></tr>

 <tr><td width="45%" class="FormText">Solution:</td>
<td width="55%"><textarea name="Solution" rows="10" cols="20" ><?php echo $Solution; ?></textarea></td></tr>

 <tr><td width="45%" class="FormText">Comment:</td>
<td width="55%"><textarea name="Comment" rows="10" cols="20" ><?php echo $Comment; ?></textarea></td></tr>

 
 
<td width="55%"><input name="submit"  value="submit"  type="submit" <br> <input type="Submit" value="Cancel"</br></td>


        </form>
        <?php

 
 
?>

update.php code

Code: [Select]
<?php
//connect  to the database 


$con = mysql_connect("localhost","dbusrn","dbpwd");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("mydb", $con);




//if (isset($_POST['submit']))  {
$cf_id  = $_POST['cf_id'];
$Firstname = $_POST['Firstname'];
$lastname = $_POST['lastname'];
$Address = $_POST['Address'];
$Postcode = $_POST['Postcode'];
$Phone = $_POST['Phone'];
$Email = $_POST['Email'];
$Customer_Type = $_POST['Customer_Type'];
$Computer_type = $_POST['Computer_type'];
$Computer_maker = $_POST['Computer_maker'];
$Model = $_POST['Model'];
$OS = $_POST['OS'];
$Appointment_date = $_POST['Appointment_date'];
$Problem = $_POST['Problem'];
$Solution = $_POST['Solution'];
$Comment = $_POST['Comment'];



if (isset($_POST['submit']))  {
  

$query ="UPDATE Customer_Registration SET  Firstname='$Firstname',lastname='$lastname',Address='$Address',Postcode='$Postcode',Phone='$Phone',Email='$Email',Customer_Type='$Customer_Type',Computer_type='$Computer_type',Computer_maker='$Computer_maker',Model='$Model',OS='$OS',
Appointment_date='$Appointment_date',Problem='$Problem',Solution='$Solution',Comment='$Comment' WHERE cf_id=cf_id"or die (mysql_error());

echo $query;

mysql_query($query) or die(mysql_error());
//mysql_close($con);
 
echo "<p>Congrats Record Updated</p>";
}

?>
Thank you in advance for your help

Hey Guys. I have tried looking this up on Google but the only answers I am finding is using there where clause. I wanted to know if I can update or delete a range of rows like from id 100-200. Is there a way to do that? Thanks!

Hi all,
I have a data base with the following table:

---member_data---
id ^ mid ^fieldname^ fieldvalue
1 - 2 - applicant - Seth Smith
2 - 4 - firstname - Chris
3 - 4 - lastname - Cooper
4 - 7 - full_name - Joey Jones
5 - 7 - occupation - Programmer
6 - 7 - phone - 800-555-1212


And below is a snippet that I use to display the selected members data for editing

-------------------------------
<table>
<tr>
<td>Name:</td>
<td>Value:</td>
</tr>
<?php

$query = "SELECT * FROM member_data WHERE mid='$mid'";
$result= mysql_query($query);
  while($row = mysql_fetch_array($result)) {

      $fieldname = $row["fieldname"];
      $fieldvalue = $row["fieldvalue"];

?>
<tr>
<td><input type="text" name="<?php echo $fieldname;?>" value="<?php echo $fieldname;?>"></td>
<td><input type="text" name="<?php echo $fieldvalue;?>" value="<?php echo $fieldvalue;?>"></td>
<?php } ?>
</tr>
</table>
-------------------------------

My question is:

- using the Db example above:
- lets say Ive selected mid#7 (member id 7) to edit which is displayed using the snippet code from above.
- once displayed how do I edit  mid#7  given the fact that  mid#7  is located on 3 seperate rows from the same table?

Thank you,
Dave


*ALSO - I tried the snippet below which did Not work.

foreach($_POST as $key => $val) {
$sql = "UPDATE member_data SET fieldname='$key', fieldvalue='$val' WHERE mid='$mid'";
$result = mysql_query($sql);
}