Does anyone know how to make an image upload script to Mysql database that renames the image to the same ID as it is in the DB my ID column is auto-incremented.

I also want to make a drop down category box and a drop down subcategory box that when the selection of category is for example php the subcategory values change to subcategories of php.

I All want This Made Using PHP & MySQLwuth as little javascript as possible

First one is easy:


http://us2.php.net/manual/en/functio...-insert-id.php
http://us3.php.net/rename

<?php
$id = mysql_insert_id();
$filename = $id.'.jpg';
rename("/path/to/file/old.jpg", "/path/to/file/".$filename);
?>

Your second question is probably going to require some JavaScript if you want to do on the fly.

i thought the second question could need that

There are different solutions for the second task. You can either load all categories with all subcategories into a javascript array and then use an appropriate array of sibcategories for selected category or you can make ajax requests to server to obtain subcategories list when the category is selected. Anyway the amount of javascript coding will be sufficient in each case.