Hey I'm having trouble with updating my database.
I have no idea why it isnt.. because its not displaying any errors.

The form posts the variables perfectly, then the page puts the information into the function page with

PHP Code:

<?
if ($functions->assignProject($_GET['allocate'], $_GET['ID'])) {
  header("Location: index.php");
}
?>

Then this is the function page.

PHP Code:

function assignProject($allocate, $ID) {
     $this->sql->Update("UPDATE ".$this->TABLES['projects']." SET assigned = '".$allocate."', WHERE id = $ID");
    return true;
  } 


It returns true as though its updated assigned. But when I check the database manually the figures are still the same.

I have checked the form is sending the variables, the information is getting to the function page. its just not updating properly.
This is the SQL Update query

PHP Code:

function Update($sql)    {
        if ((empty($sql)) || (!eregi("^update",$sql)) || (empty($this->CONNECTION))) {
      $this->ERROR_MSG = "\r\n" . "SQL Statement is <code>null</code> or not an UPDATE - " . date('H:i:s');
      $this->debug();
      return false;
    } else {
          $conn = $this->CONNECTION;
          $results = mysql_query($sql,$conn);
          if (!$results) {
        $this->ERROR_MSG = "\r\n" . mysql_error()." - " . date('H:i:s');
        $this->debug();
        return false;
      } else {
            return mysql_affected_rows();
      }
    }
    } 


try:

PHP Code:

<?
if (functions->assignProject($_GET['allocate'], $_GET['ID']) == true) {
  header("Location: index.php");
} else {
echo "SOMETHING_WRONG";
}
?>

Originally Posted by rogem002

try:

PHP Code:

<?
if (functions->assignProject($_GET['allocate'], $_GET['ID']) == true) {
  header("Location: index.php");
} else {
echo "SOMETHING_WRONG";
}
?>

There is no fault in this part of the problem. Because I can get the function to echo back $ID and $allocate with the correct values.
Problem seems to be when its actually trying to update the database. Its not actually updating it.

Still does the same thing, takes me to index.php but doesnt actually update the database.

This is ment to give someone a project from a list of ones that havent been allocated. So when it assigns it it takes it from the unallocated projects and adds it to the persons list.

Thats whats getting changed in the database. TABLES['projects']." SET assigned = '".$allocate."' well, its ment to.

I cant see anything wrong with the update sql line.
Its coming back true, but it isnt working.

Is there a way to test to see if it comes back false?

Sorry for so many replies.

I have tried changing the function and how it updates with a couple of syntax changes.

PHP Code:

function assignProject($allocate, $ID) {
     $this->sql->Update("UPDATE ".$this->TABLES['projects']." SET assigned = $allocate WHERE id = $ID");
    return true;
  } 


I'm not getting returned back to index.php now.
I get the error -
Unknown column 'DawnForge' in 'field list' - 18:52:57done

$allocate = DawnForge

PHP Code:

    function assignProject($allocate, $ID) {
     $this->sql->Update("UPDATE ".$this->TABLES['projects']." SET assigned = '".$allocate."' WHERE id = $ID");
    return true;
  } 


PHP Code:

<?
require('inc/header.inc.php');
if ($SZUserMgnt->assignProject($_GET['allocate'], $_GET['ID']) == true) {
  header("Location: index.php");
} else {
echo "SOMETHING_WRONG";
}
?>

And it works, for some reason it worked. I have no idea why... just suddenly worked...
Only thing I can see is I removed a , in the update function...

Could that be the reason?
Thankyou for your help, added to your talkthingy

if $allocate is a string it will need single quotes around it.

the difference between the code in post #4 and post #5 is the single quotes have been added

SET assigned = $allocate WHERE

SET assigned = '".$allocate."' WHERE

Yes but in the first post I originally had them in it.

But i think the , stopped it from working correctly