PHP - Update Multiple Records With A Single Hiddenfield

I am really not sure if this is a problem with me (probably is), php or mysql.

I have a calendar that I am adding events to. If I want to edit only the date I can but only once after I make this update I am out. If I attempt to update the time or event title the database is never updated and I am no longer able to update the date.
here is the controller for the save.
Code: [Select]
<?php 
function eventsave() {
$details = $_POST;
$this->load->model('eventsmodel');

$this->eventsmodel->eventsave($details,'', TRUE);

redirect('/admin/events', 'location');

}
?>
I have turned off the redirect to see if I was getting any errors and they seem to be non existent.

Here is the model that is used to create a new entry and update a record.
Code: [Select]
<?php
function eventsave($event) {

$startdate = explode('-', $event['startdate']);

$start = mktime($event['starthour'], $event['startmin'], 0, $startdate['0'], $startdate['1'], $startdate['2']);
$end = mktime($event['endhour'], $event['endmin'], 0, $startdate['0'], $startdate['1'], $startdate['2']);
$name = $event['name'];


if (isset($event['id'])) { // if is true then this is an update not a new event
$data = array(
'name' => $name,
                 'start' => $start,
                 'end' => $end
                        );
$this->db->where('id', $id);
$this->db->update('events', $data); 
}else{
$this->db->set('name', $name);
$this->db->set('start', $start);
$this->db->set('end', $end);
$this->db->insert('events');
}

}
?>


I am using code igniter if that helps and the information being submitted by the form looks good.

This is the submitted update array and the new event array is just missing the "id"
Code: [Select]
Array
(
    [name] => test
    [startdate] => 05-14-2011
    [starthour] => 1
    [startmin] => 0
    [endhour] => 1
    [endmin] => 0
    [id] => 54
    [saveevent] => save
)


Any suggestions would be appreciated. Thank you.

Hi guys, I am trying to UPDATE some records on a mySQL database but can't seem to find out why it is not working. This is my code.


Code: [Select]
<?php


$latitude = $_POST['lat_location'];
$longitude = $_POST['long_location'];
$unique_ID = $_POST['unique_ID'];

include('connect2.php');



$query = mysql_query("SELECT * FROM user_location WHERE unit = '$unique_ID'");

$numrows = mysql_num_rows($query);


if ($numrows == 1) {



$query2="UPDATE user_location SET lat = '$latitude', long = '$longitude' WHERE unit = '$unique_ID'";
mysql_query($query2);



$test = "matches";



} else {

mysql_query("INSERT INTO user_location VALUES ('','$unique_ID','$latitude','$longitude')");

$test = "not match";

}

echo $test . "<br />";
echo $numrows;

?>
The script receives the data via the POST method and assigns it to variables. Then I query the database for one of those variables and check how many results are found. If 0 results are found then a new record is created on the database, but if there is 1 record found then the record that is found has to be UPDATED. When the result is 0 the scripts creates the new record fine, but if the result is 1 it doesn't update. I just can't figure out why. Any help will be greatly appreciated.

Thanks in advanced,

Hi all,

I'm trying to make a query that allows the user to edit the name of a entry in SQL. I believe I have the corect Syntax but I'm not sure if I have the code set up correctly. I am using 2 queries when I think it is possible with one. The first query is used to Pint out results for a certain year and the second to update the names.

Code: [Select]
$desiredYear = $_POST['year'];
$nameEdit = $_POST['edit'];
$origName = $_POST['orig'];

echo ' The year you have chosen is '.$desiredYear;

$describeQuery = "SELECT ID, Name, (SELECT SUM(SalesVolume) as SalesVolume FROM MonthlySales WHERE ProductCode=Products.ID AND Year = '$desiredYear') AS num_sales FROM Products";
$editQuery = "UPDATE Products SET Name = '$nameEdit'  WHERE Name ='$origName'";


$results = sqlsrv_query($conn, $describeQuery);

echo '<table border="1" BORDERCOLOR=Black>';
echo '<tr><th bgcolor = "LightBlue">Name</th><th bgcolor = "LightBlue" >ID</th> <th bgcolor = "LightBlue" >Sales</th></tr>';


while($row = sqlsrv_fetch_array($results, SQLSRV_FETCH_ASSOC))
  {   
    echo '<tr>';
echo '<td >' .$row['Name'].'</td>';
echo '<td>' .$row['ID'].'</td>';
echo '<td>' .$row['num_sales'].'</td>';

echo '</tr>';
}

echo '</table>';
sqlsrv_close($conn);


 
Can somebody help me with this?

Thank you

I have a problem .
I 've been trying for a long time to make an update for php mysql to change the data.
but every time I do not manage to make it work with a form.
but it works if I only if I put this ($ sql = "UPDATE users SET username = 'value' WHERE id = 10 " ; )
so it only works when I put the value of the id.

but I want in an html form to indicate what I want to change and what id goes.

but I have tried so long that I do not feel like I so want someone help me.

make the same database and same as my records and make the code and test it if it works show me please
my database name : web test
my table called : users
my records are called :

id int ( 11) AUTO_INNCREMENT
username , varchar ( 255 )
password , varchar ( 255 )
first_name , varchar ( 255 )
last_name , varchar ( 255 )
email, varchar ( 255 )
Age, int ( 11)             Look, my update.php is like this now
<?php
$servername = "localhost";
$username = "root";
$password = ".....";
$dbname = "webtest";


$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 

$sql = "UPDATE users SET password='cotton candy' WHERE id=10";

if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}

$conn->close();
?>
but now i have still have to go into the php file to change the valeu or the id 
but i looked on site and youtube how to put it in a simple html form 
but it still does not work.

i want it in a html from.
I want that when I enter the ID that the data of the user appears and that I can change any valeu separately.

Hi there, hope have some help. I have a form where a user select time and days of the week (monday, tuesday..) that he is available. The insert script works fine, it insert and the days of week he checked in the table, the only problme is when i try to update each of them. I used this code above, but is not working, instead of updating/inserting days that is selected is inserting multi-records with the same day of the week value. here it is:

foreach($weekDay as $DaysofWeek){

$sql_days = "UPDATE available SET day_time = '$day_time', week_day = '$DaysofWeek' WHERE user_id = '$id_user'";

$update_availability = mysql_query($sql_days);

}

I need to create several buttons that when clicked it updates a field in a table and then passes params to another page (action). I cant seem to figure a logical way of doing this without making things messy, any one have any ideas

Hi Guys,

I am new to PHP/MYSQL. I am working on a web database project to record class attendance.
I have found this script which I have manipulated, however, I am not sure why it does not display the data. It may be something simple, I have checked over table names, field names, variable names to see that they match the database. It displays the textboxes with the php code rather than the data and all other fields display no data.

Can you help?

I will be focusing on Prepared Statements for SQL injections later.

<?php

$host="xxx"; // Host name
$username="xxx"; // Mysql username
$password="xxx"; // Mysql password
$db_name="xxx"; // Database name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");


$sql="SELECT * FROM attendance";
$result=mysql_query($sql);

// Count table rows
$count=mysql_num_rows($result);


?>


<html>
<head>
<title>Registers</title>
</head>
<body>


<?php include 'Navigation.php';?>

<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">

<table border="0" cellspacing="1" cellpadding="0" style="width: 1461px; height: 105px">

<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>Last Name</strong></td>
<td align="center"><strong>First Name</strong></td>
<td align="center"><strong>Form</strong></td>
<td align="center"><strong>Year Group </strong></td>
<td align="center"><strong>Date</strong></td>
<td align="center"><strong>Attendance</strong></td>


</tr>

<?php
while($rows=mysql_fetch_array($result)){
?>

<tr>
<td align="center"><? $Student_id[]=$rows['Student_id']; ?><? echo $rows['Student_id']; ?></td>
<td align="center"><? $firstname[]=$rows['firstname']; ?><? echo $rows['firstname']; ?></td>
<td align="center"><? $lastname[]=$rows['lastname']; ?><? echo $rows['lastname']; ?></td>
<td align="center"><? $Form_Group[]=$rows['Form_Group']; ?><? echo $rows['Form_Group']; ?></td>
<td align="center"><? $Year_Group[]=$rows['Year_Group']; ?><? echo $rows['Year_Group']; ?></td>
<td align="center"><? $Att_Date[]=$rows['Att_Date']; ?><? echo $rows['Att_Date']; ?></td>
<td align="center"><input name="Presence[]" type="text" id="Presence" value="<? echo $rows['Presence']; ?>"></td>
</tr>

<?php
}
?>

<tr>
<td colspan="7" align="center"><input type="submit" name="Submit" value="Submit Register"></td>
</tr>
</table>

</form>
</table>


<?php

// Check if button name "Submit" is active, do this
if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE attendance SET Presence='$Presence[$i]' WHERE Student_id='$Student_id[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1){
header("location:Registers.php");
}
mysql_close();
?>

 

Hi, I am trying to create an admin page for a local Gym Club to allow an Administrator to be able to update club prices which then show on different screens on the site.   I have been able to display the "Prices Admin" page which basically reads a MySQL database table (pricelist), display the description, member price and non-member price and allows the user to update any of these fields.   My problem is that when I try writing the data back to the database with the "UPDATE" statement it fails, what I mean is that nothing updates.  I have at the moment commented out the actual update statement and put in a "file_put_contents" command" to try and work out what is in the various fields before the UPDATE is run.  I find that the display/INPUT works perfectly well but when I do a foreach on the $record array variable I am getting strange results.   I may not have explained this very well but here are the relevant sections of my code;   // Display and Input section   <div id="admin-area">

I have a problem with an amend to an admin system I am trying to change. The shop stocks different colours of each product and the client wants to be able to update the stock levels of all colours of one product (which all share the same title) on one form. I have tried following some instructions on some sites and tried making my own and I can get it to display the form and the values correctly, but on submission it does nothing but direct me to a page without a title value in the address (e.g. www.example.com/example/stock_level_2.php?title=). I think it may be to do with the arrays I am using, has anyone got any ideas? Here is the code.

Form:
Code: [Select]
<?php
$pd_title = str_replace("_"," ",$_REQUEST["title"]);
$pd_title = str_replace("%","&#38;#37;",$pd_title);
$pd_title = str_replace("/","&#38;#47;",$pd_title);

$lookupqueryc = mysql_query("SELECT * FROM product WHERE pd_title = '".$pd_title."' ORDER BY pd_id DESC");

echo '<table><tr><th align="center" class="bodytext">Product<br />ID</th><th align="center" class="bodytext">Product Name</th><th align="center" class="bodytext">Stock Level</th></tr>';

$form = '<form name="frmAmendStock" method="post" action="stock_level_2.php?title="';
$form .=  $_GET["title"];
$form .= '" enctype="multipart/form-data">';
echo $form;
echo '<input name="submitted" type="hidden" value="true">';
$count=mysql_num_rows($lookupqueryc);
echo '<input name="count" type="hidden" value="';
echo $count;
echo '">';

                          
  while($lookupresultc = mysql_fetch_array($lookupqueryc)){  
  
        

echo '<tr><td align="center" class="bodytext">';
                                $id[]=$lookupresultc["pd_id"];
echo $lookupresultc["pd_id"];
echo '</td><td class="bodytext">';
echo $lookupresultc["pd_title"];
if (isset($lookupresultc["pd_colour"]) && $lookupresultc["pd_colour"] !="") {
echo " (";
echo $lookupresultc["pd_colour"];
echo ')';
}
if ($lookupresultc["pd_stock"] <= 5) {
echo '</td><td align="center" class="bodytext" style="border: 2px solid red;">';
echo '<input name="stock[]" type="text" id="stock" value="';
                                echo $lookupresultc["pd_stock"];
                                echo '"style="width: 50px;" />'; 
echo "</td></tr>";
}else{
echo '</td><td align="center" class="bodytext">';
echo '<input name="stock[]" type="text" id="stock" value="';
                                echo $lookupresultc["pd_stock"];
                                echo '"style="width: 50px;" />'; 
echo "</td></tr>";

}



} ?>
<tr>
                <td>&nbsp;</td>
                <td height="35"><a href="javascript: " onClick="javascript:document.forms.frmAmendStock.submit()" class="bodytext"><strong>click here to amend your stock </strong></a></td>
              </tr>
</form> </table>


And here is the code it should run on submission:
Code: [Select]
<?php
if (isset($_POST["submitted"])) {

for($i=0;$i<$_POST["count"];$i++){
mysql_query("UPDATE product SET pd_stock='$stock[$i]' WHERE pd_id='$id[$i]'");
}

}
?>

This is the form that I'm using and it populates just fine but when you make the changes I can't figure out how to get it to update each record in my database.
Code: [Select]
<table width="100%" cellspacing="1" cellpadding="2" border="0">
<form action="<?php echo $_SERVER["PHP_SELF"] . "?update=1"; ?>" method="post">
<tr>
<td><b>Category Name</b></td>
<td><b>Category Description</b></td>
<td><b>Order</b></td>
<td align="right"><input type="submit" value="Update"></td>
</tr>
<?php
read_cat_list($cat);
for ($i = 0; $i < $cat["count"]; $i++) {
echo "<tr>\n";
echo "<td width=\"30%\" valign=\"top\"><input type=\"text\" name=\"cat_name_" . safe_string($cat[$i]["cat_id"]) . "\" size=\"30\" maxlength=\"250\" value=\"" . safe_string($cat[$i]["cat_name"]) . "\"></td>\n";
echo "<td width=\"36%\" valign=\"top\"><textarea name=\"cat_desc_" . safe_string($cat[$i]["cat_id"]) . "\" rows=\"2\" cols=\"30\">" . safe_string($cat[$i]["cat_desc"]) . "</textarea></td>\n";
echo "<td width=\"10%\" valign=\"top\"><input type=\"text\" name=\"cat_order_" . safe_string($cat[$i]["cat_id"]) . "\" size=\"3\" maxlength=\"3\" value=\"" . safe_string($cat[$i]["cat_order"]) . "\"></td>\n";
echo "<td width=\"24%\" valign=\"top\">[&nbsp;<a href=\"#\" onmouseover=\"window.status = 'Delete " . safe_string($cat[$i]["cat_name"]) . "'; return true;\" onmouseout=\"window.status = ''; return true;\" onclick=\"javascript:del_cat(" . $cat[$i]["cat_id"] . ", '" . safe_string($cat[$i]["cat_name"]) . "'); return false;\">Delete</a>&nbsp;]</td>\n";
echo "</tr>\n";
}
?>
<tr>
<td colspan="4" align="right"><input type="submit" value="Update"></td>
</tr>
</form>
</table>
the safe_string function just cleans up the output/input from the database, This next block is my form processor for this form.
Code: [Select]
<?php
function update_cats($vars) {
$err = "";

#if ($SESSION["level"] != ADMIN) {
# $err = ERR_NOT_ENOUGH_ACCESS;
#} else {
$temp = array_keys($vars);

for ($i = 0; $i < count($temp); $i++) {
if (substr($temp[$i], 0, 9) == "cat_name_") {
if ($vars[$temp[$i]] == "") {
$err = "Category names cannot be blank.";
break;
} else {
$name_query["cat_name"] .= substr($temp[$i], 9) . ", ";
}
}
}
for ($i = 0; $i < count($temp); $i++) {
if (substr($temp[$i], 0, 9) == "cat_desc_") {
$desc_query["cat_desc"] .= substr($temp[$i], 9) . ", ";
}
}
for ($i = 0; $i < count($temp); $i++) {
if (substr($temp[$i], 0, 10) == "cat_order_") {
if ($vars[$temp[$i]] == "") {
$err = "Category orders cannot be blank.";
break;
} else {
$order_query["cat_order"] .= substr($temp[$i], 10) . ", ";
}
}
}
#}

if (!$err) {
if ($name_query["cat_name"]) {
$update_name_query  = "update category";
$update_name_query .= "   set cat_name = '" . $name_query["cat_name"] . "'";
$update_name_query .= " where cat_id in (" . substr($name_query["cat_name"], 0, -2) . ")";

update_db($update_name_query);
}

if ($desc_query["cat_desc"]) {
$update_desc_query  = "update category";
$update_desc_query .= "   set cat_desc = '" . $name_query["cat_desc"] . "'";
$update_desc_query .= " where cat_id in (" . substr($desc_query["cat_desc"], 0, -2) . ")";

update_db($update_desc_query);
}

if ($order_query["cat_order"]) {
$update_order_query  = "update category";
$update_order_query .= "   set cat_order = '" . $name_query["cat_order"] . "'";
$update_order_query .= " where cat_id in (" . substr($order_query["cat_order"], 0, -2) . ")";

update_db($update_order_query);
}
}

return $err;
}
?>
update_db is my database caller, if you need any of the functions that I use that are not here please post back and tell me.

now when I process the form all my fields change to this:

cat_name: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15,
cat_desc:
cat_id: 0

for all the records in the database table, I'm just trying to update each record with the values it needs

Here is my database table with the data.
Code: [Select]
CREATE TABLE `category` (
  `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(255) NOT NULL,
  `cat_desc` text NOT NULL,
  `cat_order` int(11) NOT NULL,
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(1, 'Hand Tossed Pizza', '', 1);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(2, 'Hand Tossed Specialty Pizzas', '', 2);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(3, 'Chicago Style Deep Dish', '', 3);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(4, 'Specialty Chicago Style Deep Dish', '', 4);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(5, 'Chicken Wings & Tenderloins', '', 5);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(6, 'Hot Sides', '', 6);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(7, 'Hot Sandwiches', '', 7);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(8, 'Cold Sandwiches', '', 8);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(9, 'Pastas', '', 9);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(10, 'Fresh Salads', '', 10);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(11, 'Fresh Breads', '', 11);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(12, 'Soups', '', 12);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(13, 'Kids Menu', '', 13);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(14, 'Drinks', '', 14);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(15, 'Desserts', '', 15);

Hope I have provided plenty of info on what I got and what I need for it todo

Thanks

Hi I'm using this code to insert multiple records. The code executes but nothing is entered into my database. This usually happens when there's a mismatch in data types.   How do I ensure that description goes in as text which in sql is wrapped in single quotes, but also make sure the other variables go in as numeric.

 // an array items to insert
    $array = array( 'theid'   => $theid,
            'descr'      =>   $descr,
            'costperunit'    => $costperunit,
            'quantity'       => $quantity,
'costperlot'       => $costperlot
            );


    // begin the sql statement
    $sql1 = "INSERT INTO  descriptions (jobid, description, costperunit, quantity, costperlot) VALUES ";

    $it = new ArrayIterator( $array );


    // a new caching iterator gives us access to hasNext()
    $cit = new CachingIterator( $it );


    // loop over the array
    foreach ( $cit as $value )
    {
        // add to query
        $sql1 .= "('".$cit->key()."','" .$cit->current()."')";
       

        if( $cit->hasNext() )
        {
            $sql1 .= ",";
        }
    }

I know how to pull data from sql table and limit down the results,

what i wanted to do is pull data from a sql table 'finished' and list data that has paid='0'

this is then limited to show the amount of rows set by variable 'maxPay'

here is my list what im pulling atm;
    <h2>Payment </h2>
    <?php 
if($userType[user_type]==28){
$queryPay = mysql_query("SELECT * FROM finished WHERE paid='0'&&method!='FALSE'&&method!='credit';") or die(mysql_error());

$queryAdmin = mysql_query("SELECT maxPay FROM `admin`;") or die(mysql_error());

$row = mysql_num_rows($queryPay);
//echo $row."row<br />";
$rowsArray = mysql_fetch_assoc($queryAdmin);
$rows = $rowsArray[maxPay];
//echo $rows."rows<br />";

if($rows>$row){
$r=$row;
}
else{
$r=$rows;
}
$s=0;
while($s<$r){
if($_POST[complete]==TRUE){
mysql_query("UPDATE `finished` SET `paid`='$_POST[paid]' WHERE `auctionID`='$_POST[aid]';");
$_POST[complete] = FALSE;

}
$s++;
}

$t=0;
while($t<$r){
$queryuser = mysql_query("SELECT * FROM finished WHERE paid='0'&&method!='FALSE'&&method!='credit';") or die(mysql_error());

$user = mysql_result($queryuser, $t, "username");
//echo $user;
$item = mysql_result($queryuser, $t, "itemName");
//echo $item;
$value = mysql_result($queryuser, $t, "marketPrice");
//echo $value;
$method = mysql_result($queryuser, $t, "method");
//echo $method;
$id = mysql_result($queryuser, $t, "auctionID");
//echo $id;



//echo $method;
if($method=='isk'){
?>
<FORM method="post" action="pay.php">
<input type="hidden" name=complete value="TRUE" />
<input type="hidden" name=paid value="YES" />
<input type="hidden" name=username value="<? echo $user; ?>" />
<input type="hidden" name=aid value="<? echo $id; ?>" />
<input type="submit" value="Paid" /><?
echo $user." won a ".$item." he selected to receive ".$value."ISK.";

echo "<br />";
?></FORM><?
}
elseif($method=='ship'){
?>
<FORM method="post" action="pay.php">
<input type="hidden" name=complete value="TRUE" />
<input type="hidden" name=paid value="YES" />
<input type="hidden" name=username value="<? echo $user; ?>" />
<input type="hidden" name=aid value="<? echo $id; ?>" />
<input type="submit" value="Paid" /><?
echo $user." won a ".$item." he selected to receive the ship.";

echo "<br />";
?></FORM><?
}
else{

}
$t++;
}

}
else{
echo "You are not an Admin.";
}
?>

and pay.php:
<?php 

header('Location: /admin.php');

include "connect.php";
echo $_POST[aid];
if($_POST[complete]==TRUE){
$tempID = (($_POST[aid])+1);
mysql_query("UPDATE `finished` SET `paid`='$_POST[paid]' WHERE `auctionID`='$tempID';") or die(mysql_error());
$_POST[complete] = FALSE;
}
?>

at the moment i am listing all my data, and processing it using pay.php, each dataset has a "paid" button, i want to change this to using a checkbox at end of each data row, and a submit button at the bottom. this way i can select which rows to update and tick the checkbox, then click submit and those rows will then be updated the value '0' in db to a value of 'YES'.

hope i explained myself clearly enough for some help.

im a relative php noob still in training. 

hello guys moving on from inserting multiple records im now stuck with updating multiple records. i can get most of the details nailed but i need it to match the id's for the table the code i have in the sql part are
Code: [Select]
if (isset($_POST['submit'])) {
//Assign each array to a variable
$StaffMember = $_POST['StaffMember'];
$referrer = $_POST['referrer'];
$referred = $_POST['referred'];
$SentOut = $_POST['SentOut'];
$today = date("y.m.d H:i:s");
$user_id = $_SESSION['user_id'];
$IssueNum = $_POST['Referrerid'];
$limit = count($StaffMember);



$values = array(); // initialize an empty array to hold the values
for($k=0;$k<$limit;$k++){
$msg[] = "$limit New KPI's Added";



$values[$k] = "( '{$StaffMember[$k]}', '{$referrer[$k]}', '{$referred[$k]}', '{$SentOut[$k]}', '{$today}', '{$user_id}' )"; // build the array of values for the query string
}
$query = "UPDATE `Referrer` (StaffMember, referer, referred, SentOut,
  SentOutDate, SentOutBy)
  VALUES " . implode( ', ', $values ) . "
  WHERE IssueNum= '{$IssueNum[$k]}'";
 

echo $query;




}
i obviously want the records updating where the issuenumber is the same and if the check box in the form is ticked
help with this one?

Yes, I am going to be one of those guys today. I have never done XML anything, besides past 2-3 hours or so, and I am getting frustrated. I have learned how to create simple XML files and save them. I am however having hard time figuring out how to create and XML file when trying to access an table from databse. I am looking to export from "registered_users" table all "registrations" and include "first_name", "last_name" and "age"   Sample:   <registered_users>    <registration>       <first_name>Bob</first_name>       <last_name>Smith</last_name>       <age>36</age>    </registration>    <registration>       <first_name>Jack</first_name>       <last_name>Miller</last_name>       <age>45</age>    </registration> </registered_users>   It would be nice if the file would be saved as spearate "all_users.xml"   Any help would be appreciated

As part of my User Profile, I have a series of open-ended questions that Members can answer, e.g...
Quote

1.) Why did you start your own business?
2.) If you could offer one piece of advice to other entrepreneurs, what would it be?
:
10.) How do you compete against large corporations?



I was leaning towards creating a many-to-many relationship like this...

member -||---------0<- answer ->0---------||- question


From a database standpoint this works great, HOWEVER, I just realized a big problem...

If run this query...

Code: [Select]
SELECT response
FROM answer
WHERE member_id = 1;
...then I would get TEN RECORDS back and I don't know of any way to maps those to the 10 Text Boxes on the "My Thoughts" page?!

(It would be a real PITA to have to create 10 separate Prepared Queries in PHP - one for each Field - to fill out my page?!)

So, is there a way to keep my table structure, but push the 10 records from above into 10 separate variables so I would have something like $response1, $response2,... $response10 ??

Thanks,


Debbie