php - inserting image base on description

Question

I wanted to insert image into my database , after I send in the forms.

it will be display based on the description instead of id. I'm following one tutorial which was showing how to insert based on id, which is the following code //Add this prouct into the database now

$sql = mysql_query ("INSERT INTO supermarket (category,subcategory,name,description,packaging,price)
VALUES ('$category','$subcategory','$product_name','$product_description','$product_package','$product_price')");




$pid= mysql_insert_id();
//place image in the folder
$newname = "$pid.jpg";
move_uploaded_file($_FILES['fileField']['tmp_name'],"images/$newname");
    header("location: inventory_list.php"); 
    exit();
}

now, i would like to change it to based on description. I not whether did I do it correctly.

   $pdes = mysql_insert_description();
    //place image in the folder
    $newname = "$pdes.jpg";
    move_uploaded_file($_FILES['fileField']['tmp_name'],"images/$newname");
        header("location: inventory_list.php"); 
        exit();
    }

Answer 1

There is no mysql_insert_description() method. You don't need a mysql method here though, you already have the $product_description variable available to you.

It looks like you should be able to simply do this:

$newname = "$product_description.jpg";