PHP - Variables Sometimes Quoted Or Not-unquoted In Echos Or Select/update Statements?

Hi,

I'm only just getting started with php and mysql but I like to go off the deep end.

something is wrong with my script.

it seems to work up untill it comes to the UPDATE part. It wont actually update the table and the mysql_affected_rows bit returns -1 I've searched for an explanation and can't find one.

Can someone tell me what I'm doing wrong

Thanks.

//connect to mysql
$con = mysql_connect("xxx","yyy","zzz");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
//use the right database
mysql_select_db("foo_bar");

//select all cancelled tickets
$status_query = "SELECT * FROM jos_vm_orders where order_status = 'X'";
$status_result = mysql_query($status_query) or die(mysql_error());

while ($newArray = mysql_fetch_array($status_result, MYSQL_ASSOC)) {
                $order_id = $newArray['order_id'];


$quantity_query = "SELECT * FROM jos_vm_order_item where order_id = $order_id";
$quantity_result = mysql_query($quantity_query) or die(mysql_error());

        while ($newArray2 = mysql_fetch_array($quantity_result, MYSQL_ASSOC)) {
                $product_quantity = $newArray2[product_quantity];
                $order_item_sku = $newArray2[order_item_sku];

echo ("$order_id cancelled $product_quantity tickets sku was $order_item_sku \n");

mysql_query("UPDATE LOW_PRIORITY jos_vm_product SET product_in_stock = product_in_stock + $product_quantity
WHERE product_sku = $order_item_sku AND STR_TO_DATE($order_item_sku, '%Y-%d-%m')
$quantity_query = "SELECT * FROM jos_vm_order_item where order_id = $order_id";
$quantity_result = mysql_query($quantity_query) or die(mysql_error());

        while ($newArray2 = mysql_fetch_array($quantity_result, MYSQL_ASSOC)) {
                $product_quantity = $newArray2[product_quantity];
                $order_item_sku = $newArray2[order_item_sku];

echo ("$order_id cancelled $product_quantity tickets sku was $order_item_sku \n");

mysql_query("UPDATE LOW_PRIORITY jos_vm_product SET product_in_stock = product_in_stock + $product_quantity)
WHERE product_sku = $order_item_sku AND STR_TO_DATE($order_item_sku, '%Y-%d-%m')
>= CURDATE()");
echo ("$product_quantity tickets released into $order_item_sku \n");
echo ("Affected rows ");
echo (mysql_affected_rows());
echo ("\n");

}
}
mysql_free_result($status_result);
mysql_free_result($quantity_result);
mysql_close($con);
?>

This topic has been moved to PHP Regex.

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

Guys, you are so going to be sick of me. But I really appreciate the help I am receiving here thus far.

I have the code below sending the data from the form to the database. That's excellent. However, where I am stuck is doing the following two:

1. Updating currently inserted data
2. Displaying the data on the site.

Here is settings.php:

<?php
include "../settings.php";
include "../lang/english.php";
include "../config/config.php";
$errors = array();
// condition and map inputs
$fields = array('site_name'=>'sitename','site_email'=>'email','your_name'=>'name','meta_description'=>'meta-description','meta_keywords'=>'meta-keywords');
foreach($fields as $var => $field){
   $$var = isset($_GET[$field]) ? trim($_GET[$field]) : '';
}
// check if the form was submitted
if(isset($_GET['submit'])){
   // connect to/select database
   mysql_connect("$db_hostname", "$db_username", "$db_password") or die(mysql_error());
   mysql_select_db("$db_database") or die(mysql_error());
   
   // basic validation (not empty) and escape data
   foreach($fields as $var => $field){
      if(empty($$var)){
         $errors[] = "The form field: $field, is empty!";
      }
      // escape the data
      $$var = mysql_real_escape_string($$var);
   }
   // if no validation errors, insert the data
   if(empty($errors)){
      $insert = sprintf("INSERT INTO settings (site_name, description, keywords, email, name) VALUES ('%s','%s','%s','%s','%s')",
      $site_name,
      $meta_description,
      $meta_keywords,
      $site_email,
      $your_name
      );
      if(!mysql_query($insert)){
         // a query error occurred
         // check if due to duplicate data
         if(mysql_errno() == 1062){
            // 1062 = duplicate primary key error (your error number might be different depending on your table definition)
            $errors[] = "The site name: $site_name, already exists and cannot be inserted!";
         } else {
            // all other query errors -
            $errors[] = "A database error occurred and your query cannot be processed!";
            trigger_error(mysql_error()); // use error_reporting/display_errors/log_errors to display/log the error condition
         }
      } else {
         echo "The data was successfully inserted!";
      }
   }
}
//database_connect();
$sql = "UPDATE settings
SET site_name='$site_name', description='$description', keywords='$keywords', email='$site_email', name='$your_name'
WHERE id='$id'"; 


$query = mysql_query($sql)or die("There's a problem with the query: ". mysql_error()); 
if($query) echo "<br>The settings have been updated.<br>";
$_SESSION['tekst']="";
?>
<!DOCTYPE html>
<html>
<head>
    <title><?php echo $site_name; ?> :: :: Powered by osPHPSite</title>
    <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
    <link  href="css/admin.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <div id="main">
        <div id="header">
            <h1><?php echo $sitename; ?></h1>
            <ul id="top-navigation">
                    <li><a href="index.php"><?php echo $lang_button_index; ?></a></li>
                    <li><a href="settings.php" class="active"><?php echo $lang_button_settings; ?></a></li>
                    <li><a href="pages.php"><?php echo $lang_button_pages; ?></a></li>
                    <li><a href="gallery.php"><?php echo $lang_button_gallery; ?></a></li>
                    <li><a href="/"><?php echo $lang_button_viewsite; ?></a></li>
                    <li><a href="logout.php"><?php echo $lang_button_logout; ?></a></li>
            </ul>
        </div>
        <div id="middle">
            <div id="left-column">
                <h3><?php echo $eng_navigation; ?></h3>
                <ul class="nav">
                    <li><a href="index.php"><?php echo $lang_button_index; ?></a></li>
                    <li><a href="settings.php"><?php echo $lang_button_settings; ?></a></li>
                    <li><a href="pages.php"><?php echo $lang_button_pages; ?></a></li>
                    <li><a href="gallery.php"><?php echo $lang_button_gallery; ?></a></li>
                    <li><a href="/"><?php echo $lang_button_viewsite; ?></a></li>
                    <li><a href="logout.php"><?php echo $lang_button_logout; ?></a></li>
                </ul>
                <a href="http://www.osphpsite.com" target="_blank" class="link">osPHPSite</a>
                <a href="http://www.osphpsite.com/forums/" target="_blank" class="link">Support Forums</a>
                <a href="http://www.vichost.com" target="_blank" class="link">VicHost.Com</a>
            </div>
            <div id="center-column">
                <div class="table">
            <?php
               if(!empty($errors)){
                  echo 'The following errors occurred:<br />';
                  foreach($errors as $error){
                     echo "$error<br />";
                  }
               }
            ?>
                    <form action="" id="settings" name="settings">
                    <table class="listing form" cellpadding="0" cellspacing="0">
                        <tr>
                            <th class="full" colspan="2">Site Configuration</th>
                        </tr>
                        <tr>
                            <th colspan="2">From the options below, define the default settings for your website.</th>
                        </tr>
                        <tr>
                            <th colspan="2"></th>
                        </tr>
                        <tr>
                           <td>Site name: </td> <td><input type="text" name="sitename" value="<?php echo $site_name; ?>" width="172" /> <em>Site name for logo</em></td>
                        </tr>
                        <tr>
                           <td>Email: </td> <td><input type="text" name="email" value="<?php echo $site_email; ?>" width="172" /> <em>Your email address</em></td>
                        </tr>
                        <tr>
                           <td>Name: </td> <td><input type="text" name="name" value="<?php echo $your_name; ?>" width="172" /> <em>Your own name</em></td>
                        </tr>
                        <tr>
                           <td>Meta Description: </td> <td><input type="text" name="meta-description" value="<?php echo $meta_description; ?>" width="172" /> <em>SEO</em></td>
                        </tr>
                        <tr>
                           <td>Meta Keywords: </td> <td><input type="text" name="meta-keywords" value="<?php echo $meta_keywords; ?>" width="172" /> <em>Separate with Commas</em></td>
                        </tr>
                       <tr>
                       <td><input type="submit" class="button" name="submit" value="Submit"></td>
                       </tr>
                    </table>
      </form>
                </div>
            </div>
        </div>
    </div>
</body>
</html>

This will be a huge hurdle if I can get passed this one, I am well and truly on my way.
Any help, advice etc that you can give, and what needs to go where, I would really appreciate it and I promise not to annoy you guys unless absolutely necessary.

This has been bugging me for quite a while and I've tried so many different things and just run into all kinds of problems...

What I'm doing or trying at least is pulling data from a table displaying it into a multiple select box allowing the user the oppertunity to remove one or more options.  As the code stands now I'm getting no value at all in the post variable, by taking the [] brackets out of the inputs name i was able to get the first selected option but the php code was then unable to remove that value from the database.  I hope I'm explaining this well enough but the code follows I'd really appreciate some help or direction on this one.

The FORM
Code: [Select]
                <FORM action='' method='post'>
                    <select size='8' multiple name='remove_player[]'>
<?php
foreach ($members as $key => $mem) {
    if ($mem != "") {
        $mem = str_replace("-", " ", $mem);
        $mem = ucwords($mem);
        echo ("<option value='" . $mem . "'>" . $mem . "</option>");
    }
}
?>
                    </select>


and then the handler code:
Code: [Select]
        $to_remove = $_POST['remove_player'];
$as_team = str_replace(" ", "-", $teamname);
$as_team = strtolower($as_team);
$for_remove = "SELECT * FROM teams WHERE name = '$as_team'";
$for_query = (mysql_query($for_remove));
foreach ($to_remove as $y => $z) {
$z = str_replace(" ", "-", $z);
$z = strtolower($z);
}
while($arr_remove = mysql_fetch_array($for_query)) {
foreach ($arr_remove as $a => $b) {
foreach ($to_remove as $c => $d) {
if ($b == $d) {
unset($arr_remove[$a]);
}
}
}
foreach ($arr_remove as $e => $f) {
$add_replace = (mysql_result($for_query, 0, 'members'));
$replace = ($add_replace . "\r\n" . $f . "\r\n");
$replace_mem = "UPDATE teams SET members = '$replace'";
$replace_q = (mysql_query($replace_mem));
}
}
echo "Member List successfully updated.<br>";
foreach ($to_remove as $h => $g) {
echo ($g . " removed from the team.<br>");
}
Also any time i try to print any part of the array/s I get no values but the database is being updated with 2 line breaks and a "3" at the end of the table which has me a bit confused as well.

Thanks!

I want to update a value by setting cookie. I use this code:

Code: [Select]
<?php
    if (isset($_POST['ChangeOrdering'])) {
        setcookie("Ordering", $_POST['ChangeOrdering'], time() + 31536000);
    }
echo $_COOKIE["Ordering"];
?>

<form method="post" action="<?php echo $_SERVER["PHP_SELF"] ?>"> Reorder messages:
<select name="ChangeOrdering">
<option value="DateAdded ASC">Oldest first</option>
<option value="DateAdded DESC">Newest first</option>
<option value="Title ASC">By Title, A-Z</option>
<option value="Title DESC">By Title, Z-A</option>
</select>
<input type="submit" value=" Save Settings " />
</form>
Problem is that echo will return the previous cookie set, not the last value. As a matter of fact, my problem is about updating the cookie. It seems that the browser load the cookie before it is updated by the POST value.

Hi guys,

Im developing a stock system and so far new stock and can be added with the quantity, however im trying to update the stock by using a select box and selecting the type of stock and inputting a  new qty.

the form and everything is set up and i can select files from the database, however i dont know how to update files from a select box

The code i got so far is

Code: [Select]
<!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" />
<title>stock manager</title>
</head>

<body>
<?php
$stockqty =&$_POST['stock_qty1'];
?>
<center>
<table>
<td>
    <table>
<td>
        <form action='stockview.php' method='POST'>
        Please Enter a Stock Name and Stock Value
       
        <table>
            <tr>
            <td>
                Stock Name:
            </td>
            <td>
              <input name="stock_name" type="text" /><BR />
            </td>
        </tr>
        <tr>
            <td>
                Stock Qty:
            </td>
            <td>
                <input name="stock_qty" type="text" />
            </td>
        </tr>
       
        </table>
         <input name="submit" type="submit" value="Add New Stock Items" />
        </form>
  </td>
</table>
</td>

<td>
   
<table>
<td>
<form action='stockmanager.php' method='POST' enctype="multipart/form-data">
        Please Select from the list the item you wish to update
          <table>
            <tr>
            <td>
                Stock Name:
            </td>
            <td>
               
                <?php
$connect = mysql_connect("localhost","root", "") or die ("Couldn't Connect!");
mysql_select_db("stock", $connect) or die("Couldn't find db"); // select database

$query=("SELECT id, stockname FROM stocks");
$result = mysql_query ($query);
echo "<select name=stock value=''>Edit Stock QTY</option>";

while($nt=mysql_fetch_array($result))
{ //Array or records stored in $nt
echo "<option value=$nt[id]>$nt[stockname]</option>";
/* Option values are added by looping through the array */
}


$queryreg = mysql_query("SELECT * FROM stocks WHERE stockqty='$stockqty'");
$numrows = mysql_num_rows($queryreg);

$update = mysql_query("UPDATE stocks SET stockqty='$stockqty' WHERE stockname  = '$stockname'");
echo("Its updated");
?>
               
               
            </td>
        </tr>
        <tr>
            <td>
                Stock Qty:
            </td>
            <td>
                <input name="stock_qty1" type="text" />
            </td>
        </tr>
        </table>
         <input name="submit" type="submit" value="Update stock items" />
        </form>
    </td>
</table>
</td>
</table>

</center>


</body>
</html>

Any help would be greatly appreciated.

Thanks

Lance

Hello,   I'm having a huge issue right now decoding a zip file from an attachment with a content-encoding of quoted-printable.  I have tried a couple different methods (such as decoding the entire attachment or decoding it line by line), but none have produced a valid file when saved.  What I don't understand is that I can download and open the file in Outlook fine, so there must be something wrong with the decoder.  Here is a code snippet of my recent attempt:

                            elseif ($transferEncoding == 'quoted-printable'){
                                $fileError = true;
                                $attachmentParts = explode("\n", $currentPart->getContent());
                                $attachmentArray = array();
                                foreach ($attachmentParts as $line){
                                    array_push($attachmentArray, quoted_printable_decode($line));
                                }
                                $attachment = implode("", $attachmentArray);
                                file_put_contents($unzipPath . '.zip', $attachment);
                            }
                            $unzipper = new Decompress(array(
                                'adapter' => 'Zip',
                                'options' => array(
                                    'target' => $unzipPath,
                                )
                            ));
                            $unzipper->filter($unzipPath . '.zip');
                            unlink($unzipPath . '.zip');

I'm using Zend Framework 2 methods for unzipping the file when it's done, but there is a CRC error because the file is getting corrupted during the decode.   This is how the file compares to the original (using Beyond Compare 3):   So it is finding the hex for CLRF and removing it from the file.   Any ideas on this would be greatly appreciated as I have been trying to solve this for about a month now.   Thanks, -mcfloyd

I have:
{$content['size']} inside Code: [Select]
echo "";
I had to switch the quotes around because I added something else that required me to do so, so it now sits at this:
{$content["size"]} inside Code: [Select]
echo '';
Before I made the quote switch, it was echoing "Large", which is correct. Now after the switch, it echo's "{$content["id"]} ". Why?!
I've tried 567568758654 different combinations of quotes and removing {} and stuff but non of them fix it. I don't even see why its suddenly not even echoing! All I did was quote reverse!

I'm pulling 10 records here. How do I split the results in to several echos?

$query = "SELECT statez, COUNT(statez)FROM mylist GROUP BY statez"; 
$results = mysql_query($query);
$returnS="";
while($line = mysql_fetch_array($results))
{
$returnS.= $line['COUNT(statez)'].",,".$line['statez'].",,,";
}
echo $returnS;
mysql_close($link);
?>

I need the code to look like this by showing the (COUNT) number for each state.
$results = mysql_query($query);
while($line = mysql_fetch_array($results))
{
echo $line["number_in_state1"].",,";
echo $line["number_in_state2"].",,";
echo $line["number_in_statee3"].",,";
echo $line["number_in_state4"].",,";
echo $line["number_in_state5"].",,";
echo $line["number_in_state6"].",,";
//etc....
}

ok my code is below but i want to count how many $sname or ['member_name'] there is as if there is 4 or more i want it to add a marquee to it  have that sorted but im having trouble getting it to count can you help me?


$query = "SELECT * FROM `ibf_members` WHERE member_group_id = '4' or member_group_id = '6' or member_group_id = '17' or member_group_id = '18' or mgroup_others = '4' or mgroup_others = '6' or mgroup_others = '17' or mgroup_others = '18' "; 

$result99 = mysql_db_query("pbf99_backup", $query);
$staff1 = mysql_num_rows($result99);
if ($result99) 
{  
while ($r = mysql_fetch_array($result99)) { // Begin while 
$sid = $r["member_id"];
$smgid = $r["member_group_id"];


$query2 = "SELECT * FROM `ibf_sessions` WHERE member_id = '$sid'"; 
$result2 = mysql_db_query("pbf99_backup", $query2); 
if ($result2) 
{  
while ($r2 = mysql_fetch_array($result2)) { // Begin while 
$sname = $r2["member_name"]; 

$query3 = "SELECT * FROM `ibf_groups` where g_id = '$smgid'"; 
$result3 = mysql_db_query("pbf99_backup", $query3); 
if ($result3) 
{  
while ($r3 = mysql_fetch_array($result3)) { // Begin while 
$ssuffix = $r3["suffix"];
$sprefix = $r3["prefix"];

echo "<a href='$host$sid' target='_parent'>$sprefix$sname$ssuffix$stafff</a><br><br>";
}}}}}}

?>

I am trying to update a mysql table called AvItems with the value 'Torso' in the Equip "section?" I have been through the forums and cannot see anything to match.
I dont mind if the page looses the onsubmit() and has a button instead.
Though I would like to update the database and link back to the same page: There is a display that shows the item that is currently equiped, I have put this in to show it works, or doesn't as the case may be.
Hope I got the code /code right this time.

many thanks in advance

Andy Curtis

Code: [Select]
create table Items(
ItemID integer unsigned auto_increment primary key,
ItemName varchar(20) not null,
Type varchar(10),
UsedOn varchar(10),
);

create table AvItems(
AvItemID integer unsigned auto_increment primary key,
AvID integer unsigned,
ItemID integer unsigned,
Equip varchar(8));


<?php

$username="root";
$password="MyPassword";
$database="MyDataBase";
$AvName = "AndyJCurtis";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$AvAccR = mysql_query( " SELECT AvID FROM AvAcc WHERE AvName = '$AvName' " );
$AvID = mysql_result($AvAccR, 0, 'AvID');
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$Torso = mysql_query(" select ItemName from AvItems, Items where AvItems.itemID = Items.itemID AND AvItems.AvID = '$AvID' AND UsedON = 'Body' ");
$TorsoE = mysql_query(" select ItemName from AvItems, Items where AvItems.itemID = Items.itemID AND AvItems.AvID = '$AvID' And UsedON = 'Body' AND Equip = 'Body' ");
if(mysql_num_rows($TorsoE) != 0)
{
$TorsoItem = mysql_result($TorsoE ,0,"ItemName");
//mysql_close();
?>

<title></title>
<head></head>
<body>
<form action="http://localhost/CI/Equip2.php" method="post">

<table border=1>
<tbody>
<tr>
<td>Torso<BR>
<?PHP
echo "$TorsoItem <BR>";
?>
<select name="Torso" onchange="submit();" value =" Update">
<?PHP
while($TorsoRow = mysql_fetch_array($Torso))
{
echo "<option value=\"".$TorsoRow['ItemName']."\">".$TorsoRow['ItemName']."\n </option>";
}
?>
</select>
</td>
</tr>

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
<?php
if($_POST['Torso'] == 'Update')
{
mysql_query("update AvItems set Equip = '' where Equip='Torso'") or die("cant update unequip"); 
mysql_query("update AvItems set Equip = 'Torso' where ItemID='{$_POST['ItemName']}'") or die("cant update equip"); 
}
?>
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

</tbody>
</table>
</.form>
</body>
</html>

Well, I made this yesterday then realised, I need to check is it exists...
I got this but when I go to accept the application and the member exists in the table it enters it anyway...

Code: [Select]
<?php
$member=$_POST['memberid'];
$status=$_POST['Status'];

$con = mysql_connect("host","user","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("a2186214_hbclan",$con);
$sql="UPDATE application SET Status = '$status' WHERE ID = '$member'";
$sql1="INSERT INTO table_members(name) SELECT application.Name FROM application WHERE application.ID = '$member'";
if ($status == 'ACCEPTED')
{
if(mysql_num_rows(mysql_query("SELECT name FROM table_members WHERE name = '$member'")))
{
if(mysql_query($sql, $con) or die(mysql_error()))
{
echo 'Status Changed.<br /><a href="../applications.php">Return To Members List</a>';
}
else
{
die('Could not submit: ' . mysql_error());
}
}
else
{
if(mysql_query($sql, $con) or die(mysql_error()))
{
if(mysql_query($sql1, $con) or die(mysql_error()))
{
echo 'Status Changed.<br /><a href="../applications.php">Return To Members List</a>';
}
}
else
{
die('Could not submit: ' . mysql_error());
}
}
}
else
{
if(mysql_query($sql, $con) or die(mysql_error()))
{
echo 'Status Changed.<br /><a href="../applications.php">Return To Members List</a>';
}
else
{
die('Could not submit: ' . mysql_error());
}
}
mysql_close($con);

?>

Hi there,

I'm having a problem with updating a record with an UPDATE mysql query and then following that query with a SELECT query to get those values just updated.

This is what I'm trying to do...I'd like a member to be able to complete a recommended task and upon doing so, go to a page in their back office where they can check off that task as "Completed".  This completed task would be recorded in their member record in our database so that when they return to this list, it will remain as "Completed".  I'm providing the member with a submit button that will call the same page and then update depending on which task is clicked as complete.

Here is my code:
Code: [Select]
$memberid = $_SESSION['member'];

// Check if form has been submitted
if(isset($_POST['task_done']) && $_POST['task_submit'] == 'submitted')
{
  $taskvalue = $_POST['task_value'];
  $query = "UPDATE membertable SET $taskvalue = 'done' WHERE id = $memberid";
  $result = mysqli_query($dbc, $query);
}

$query ="SELECT task1, task2, task3 FROM membertable WHERE id = $memberid";
$result = mysqli_query($dbc, $query);
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);

$_SESSION['task1'] = $row['task1'];
$_SESSION['task2'] = $row['task2'];
$_SESSION['task3'] = $row['task3'];
?>
<h4>Task List</h4>
<table>

  <form action="" method="post">
    <tr>
      <td>Task 1</td>
      <td><?php if($_SESSION['task1'] == 'done') {echo '<div>Completed</div>';} else{ echo '<input type="submit" name="task_done" value="Mark As Completed" />';} ?></td>
    </tr>
    <input type="hidden" name="task_value" value="task1" />
    <input type="hidden" name="task_submit" value="submitted" />
  </form>

  <form action="" method="post">
    <tr>
      <td>Task 1</td>
      <td><?php if($_SESSION['task1'] == 'done') {echo '<div>Completed</div>';} else{ echo '<input type="submit" name="task_done" value="Mark As Completed" />';} ?></td>
    </tr>
    <input type="hidden" name="task_value" value="task2" />
    <input type="hidden" name="task_submit" value="submitted" />
  </form>

  <form action="" method="post">
    <tr>
      <td>Task 1</td>
      <td><?php if($_SESSION['task1'] == 'done') {echo '<div>Completed</div>';} else{ echo '<input type="submit" name="task_done" value="Mark As Completed" />';} ?></td>
    </tr>
    <input type="hidden" name="task_value" value="task3" />
    <input type="hidden" name="task_submit" value="submitted" />
  </form>

</table>

The problem that I am having is that the database is not updated with the value "done" but after submission, the screen displays "Completed" instead of "Mark As Completed".  So the value is being picked up as "done", but that is why I have the SELECT after the UPDATES, so that there is always a current value for whether a task is done or not.  Then I refresh and the screen returns the button to Mark As Complete.  Also, when I try marking all three tasks as, sometimes all three are updated, sometimes only one or two and again, I leave the page or refresh and the "Marked As Completed" buttons come back.  Bizarre.  If anyone can tell me where my logic is going wrong, I would appreciate it.

Hello.

I have  a simple enough code that takes information from one table and drops it into another.  This is great, but I have 2a new complexities that I have been unable to code correctly.

A.  'lastname', 'firstname' on table1 need to be combined into 'name'

How & Where do I combine these strings and then pass them?

Code: [Select]
<?php
include('dbconfig.php');


// Make a MySQL Connection
mysql_connect("localhost", "$user", "$password") or die(mysql_error());
mysql_select_db("$database") or die(mysql_error());

$result = mysql_query(
"INSERT INTO table2 (lastname, firstname, email)
SELECT lastname, firstname, email
FROM table1
WHERE email='someemail@gmail.com' ") or die(mysql_error());

?>

$var = @$_GET['q'] ;
$trimmed = trim($var);
$table = @$_GET['field'];
$query="SELECT * FROM contacts WHERE @'table' contains @'trimmed' order by id";
$result=mysql_query($query);
$num=mysql_numrows($result);


Why wont this work?

Zacron