I need some help

[blaze1one]

I have a file called competed.php which displays to the individual members offers that they have completed on my site

it looks like this

<?php
include "config.php";
$con = mysql_connect("localhost","$DB_User","$DB_Pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("$DB_Name", $con);

$result = mysql_query("SELECT * FROM uoffers WHERE status='1' AND uid='$uid'");
while($row = mysql_fetch_array($result))
{
echo $row['title'];

echo "</a> - Completed: ";
echo $row['date'];
echo "<br>";

}mysql_close($con);
?>

now the problem is i need for the row title to be displayed

the info in this script above gets inserted by this script

<?

$id = $HTTP_GET_VARS['id'];

$result = mysql_query("UPDATE uoffers SET status='1' WHERE idd='$id'")
or die(mysql_error());

echo "Updated.";
?>

but I do not know how to get the row 'title' from offers table to the uoffers table, so that it can be outputted in the first set of code.

the output of this:
" - Completed: Wednesday 2nd of May 2007 04:49:30 PM"
the blank spot is where I want the title of the offer to be displayed

if you need more info let me know, and any help is well appreciated!

[Scriptmaker]

I just wanted to check if this was a typo:

$result = mysql_query("UPDATE uoffers SET status='1' WHERE >>>i<<<dd='$id'")
or die(mysql_error());

also, $http_get_vars is old, what version of PHP are you using?

finally, it helps if you put your code in php brackets, that way the forum will show it with syntax highlighting and it won't distort the window.

...

If the script is displaying the correct date, and is just omitting the title, the first place I would check is if 'title' is the correct column name in your database (although I would think mysql would print out an error).

Try print_r ($row); or something similar to output the contents of the array to see if any values are being passed.

Sorry for the being so random with my suggestions.