[SniperTowers]

Form:

PHP Code:

<?php
session_start();
require ("connect.php");
require("functions.php"); 
include("template/header.php");
if($_SESSION['status'] != 2){
    die('You must be an administrator to access this section; please <a href="login.php">login</a>');
}
echo "<a href=\"admin.php\">Return to admin section!</a></br><br/><br/>";
echo "Here you can add thumbnails.";
echo "<br/>Add a Thumbnail:<br/><br/>";
    echo "<form action=\"thumbnail.php\" method=\"post\" enctype=\"multipart/form-data\">";
    echo "<select name=\"title\">";
    $result = mysql_query("SELECT * from layouts WHERE id ORDER BY `title` ASC");
    while($list = mysql_fetch_array( $result )){
    $title = $list['title'];  
    $cid = $list['id'];
    echo "<option value=\"$cid\">$title</option>";
    }
    echo "</select>";
    echo "<br/>Display image (100px x 100px): <input id=\"file\" type=\"file\" name=\"file\"/><br />";
        echo "<br/><input type=\"submit\" name=\"submit\" value=\"Create thumbnail!\">
        </form>";
       
include("template/footer.php");
?>

Thumbnail.php:

PHP Code:

<?php
session_start();
require ("connect.php");
require("functions.php"); 
include("template/header.php");
if($_SESSION['status'] != 2){
    die('You must be an administrator to access this section; please <a href="login.php">login</a>');
}
      $rand = rand(0,999999);
      move_uploaded_file($_FILES["file"]["tmp_name"], "http://www.hotscripts.com/forums/images/" . "$rand" . $_FILES["file"]["name"]);
      $thumbnail = "$rand" . $_FILES["file"]["name"];
      if(empty($_FILES["file"]["name"])){
          $thumbnail = "none.jpeg";
}
    $id = mysql_real_escape_string($_GET['id']);
    $result = mysql_query("UPDATE layouts SET thumbnail = '$thumbnail' WHERE id='$id'");
        echo "The thumbnail has been added.";
        echo "$title";
        
include("template/footer.php");
?>

I'm trying to update a database with the image i have uploaded however nothing updates? What am I doing wrong?

[Jcbones]

You are trying to update a row where the id = NULL.

Your values are being sent by "POST" not "GET".

So change your $id line to:

PHP Code:

$id = mysql_real_escape_string($_POST['title']); 


[mdhall]

PHP Code:

    $result = mysql_query("SELECT * from layouts WHERE id ORDER BY `title` ASC"); 


" WHERE id " doesn't have any value associated with it in your query.