okay....i can't delete the row...
the screen is juz blank...been trying to figure this out....

$invoice_no=$_SESSION['invoice_no'];
	$dbh1=mysql_connect("$host", "$username", "$password")or die("cannot connect");
	$dbh2=mysql_connect("$host", "$username", "$password",true)or die("cannot connect");
	mysql_select_db("$db_name",$dbh1)or die(mysql_error());
	mysql_select_db("$db_name1",$dbh2)or die(mysql_error());
	$sql="SELECT * FROM $tbl_name WHERE invoice_no = '$invoice_no'";			//the sql query
    $result = mysql_query($sql,$dbh1);
	$row = mysql_fetch_array($result);
	$container_no=$row['container_no'];
	$document_no=$row['document_no'];
	$part_no=$row['part_no'];
	$spart_no=$row['spart_no'];
	$no_pallets=$row['no_of_pallets'];
	$status='Inactive';

	$sql1="INSERT INTO $tbl_name1 (invoice_no,container_no,document_no,part_no,spart_no,no_of_pallets,status)VALUES('".$invoice_no."','".$container_no."','".$document_no."','".$part_no."','".$spart_no."','".$no_pallets."','".$status."')";		//sql query defined
    $result=mysql_query($sql1,$dbh2);
    $containernumber=$_POST['containernumber'];
	$sql2="DELETE $tbl_name WHERE invoice_no='".$invoice_no."'";
	$result2=mysql_query($sql2,$dbh1);
	echo "Container Number changed";

LOL....forgot the 'FROM'

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.