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>