PHP Help.

[TechnoPanda]

<?php
session_start();
require ("connect.php");
require("functions.php");
include("template/header.php");

if(!isset($_SESSION['status'])){
die('You need to <a href="login.php">login</a> before you can access the members area!');
}
if($_SESSION['id'] != $_GET['user']){
die ('Error');


}else{
$offer = mysql_real_escape_string($_GET['offer']);
$user = mysql_real_escape_string($_GET['user']);
$title = mysql_real_escape_string($_GET['title']);
$username = mysql_real_escape_string($_GET['username']);
$value1 = mysql_query("SELECT * FROM offers WHERE id='$offer'");
$value2 = mysql_fetch_array($value1);
$value = $value2['value'];
$date = date('Y-m-d H:i:s');
$ip = $_SERVER['REMOTE_ADDR'];
$status = "0";
$result = mysql_query("SELECT * FROM users WHERE id='$user'");
$valueoffer = mysql_fetch_array($result);
$valueamount = $valueoffer['pending'];
$newpending = $valueamount + $value;
$username = $valueoffer['username']; // I'm assuming 'username' is the name of you username field. Amend if incorrect.



$result = mysql_query("SELECT * FROM offers WHERE id='$title'");
$offertitle = mysql_fetch_array($result);
$otitle = $offertitle['offername'];


// table, field and value should all be replaced according to your table


mysql_query("INSERT into offersUSERS VALUES(NULL, '$username', '$offer', '$otitle', '$status', '$value', '$ip', '$user', '$date')");

mysql_query("UPDATE users SET pending='$newpending' WHERE id='$user'");
echo "Done! You will be credited as soon as an administrator approves the offer! <a href=\"members.php\">return?</a>";
}
include("template/footer.php");
?>

Here's my code, it currently updates the table 'username' in my database. But I can't get it to update 'offertitle'. Why?

[Calgon]

mysql_query("INSERT into offersUSERS VALUES(NULL, '$username', '$offer', '$otitle', '$status', '$value', '$ip', '$user', '$date')");


Basic syntax of your insert query isn't working out.



mysql_query( "INSERT INTO `offersUSERS` (table1, table2, table3) VALUES('value1', 'value2', 'value3') " );


Containing table information like the table name, where you've not bothered to use `table` - is not really neat, as you can see my version looks a lot neater.

You didn't define what columns need to be updated, so that explain's why it wasn't working.