Linux, Apache, MySQL, PHP

$sql_item=mysql_query("select * from add_out_stock where challan_no='$challan_no'");

while($rs=mysql_fetch_array($sql_item))
{

 $cata_name=$rs['catalogue_name'];


 $design_no=$rs['design_no'];


$qty=$rs['quantity'];



  $sql_stock=mysql_fetch_array(mysql_query("select * from  stock where catalogue_name='$cata_name' AND design_no ='$design_no'"));


   $tqty=$sql_stock['roll_no']-$qty;


 $qty= mysql_query("update stock set roll_no='$tqty' where catalogue_name='$cata_name' AND design_no ='$design_no'");



}

mysql_query("insert into test('1','12345')");

mysql_query("insert into test('1','12345')");

CREATE TABLE tbltest(id integer primary key auto_increment, testvalue varchar(20) not null);

<?php
$value=$_POST['TestValue'];

$qShowStatus = "SHOW TABLE STATUS LIKE 'tbltest'";
$qShowStatusResult = mysql_query($qShowStatus);
$row = mysql_fetch_assoc($qShowStatusResult);
$next_increment = $row['Auto_increment'];

$Query="Insert into tbltest(testvalue) value('".$value."')";
$res=mysql_query($Query,$conn);

$id=mysql_insert_id($res);

echo "What was suppose to be :".$next_increment."<br>What you got: ".id;
?>
<FORM method=get>
<input name='TestValue'>
<input type=submit value=submit>

<?php
echo "<pre>";
print_r($_POST);
print_r($_FILES);
echo "

Array
(
    [submit] => Submit
)
Array
(
    [file] => Array
        (
            [name] => Water lilies.jpg
            [type] => image/jpeg
            [tmp_name] => D:\Temp\php\php9B61.tmp
            [error] => 0
            [size] => 83794
        )
)

if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 20000))