help!

[brcolow]

Hey, ok I have this script that uploads pictures to a file on my webserver, that works perfectly but im having trouble writing the filename to a mysql database, my query is as follows:

$sql ="INSERT INTO `revscreenshots` (id, name) VALUES ('$id', '$name')"; 
$result = mysql_query($sql);
if ($result)
    echo "Your screenshot has been uploaded to the database.";

and i define id and name here, (im sure these work because i can echo them)

$name = $HTTP_POST_FILES['userfile']['name'];
$id = $HTTP_GET_VARS['id'];

It uploads the pictures to the file (another part of the script) but after that it doesnt write them to the database, anyone know why?

[jeremuck]

try printing out the final SQL statement and see what it says.

Maybe you need to [man]addslashes[/man] or something.
Is anything inserted into the DB?
Does mysql give any errors?

[brcolow]

Umm, well i dont need to add slashes because only stuff like this is going in the database: blah.gif
And what do you mean rpint out the final sql statement?
And well duh dude, the filenam is insterted into the db obviously...

[jeremuck]

pastes a bullseye to a concrete wall
proceeds to bang ahead against bulls-eye

The filename is supposed to be inserted. I asked you what was actually inserted because you said it wasn't working.

Is it working or not?

brcolow, change your code from:

$sql ="INSERT INTO `revscreenshots` (id, name) VALUES ('$id', '$name')"; 
$result = mysql_query($sql);
if ($result)
    echo "Your screenshot has been uploaded to the database.";

to:

$sql ="INSERT INTO `revscreenshots` (id, name) VALUES ('$id', '$name')"; 
echo $sql . "<br>";

$result = mysql_query($sql);
if(mysql_error() != "")
{
  echo "mysql said: " . mysql_error();
  die();
}

Once again, like I've said in the past, perform tests to see if what you did actually worked. Don't just assume.
Printing out the sql statement will let you see what the database is recieving. (If it's not working, this is most likely the problem, and seeing it should let you know why.)
Printing out mysql_error() will tell you what the database thought about it.