how to POST checkbox values to php program from database?

[karnbhed]

I HAVE TO POST DATA FROM 1 PHP FILE TO ANOTHER VIA POST METHOD USING CHECKBOX.BUT WHEN I CHECK THE BOXES THEN IN OTHER PHP FILE, THERE RETRIEVES ONLY LAST CHECKBOX VALUE RATHER THAN ALL...


TIS IS FIRST PHP FILE

COMPARE.PHP

<?php
$con=mysql_connect("localhost","root","pass");
if(!$con) echo "not connected";
mysql_select_db("laptop",$con);
$r=mysql_query("SELECT * FROM gallary ");
echo '<form action="compare1.php" method="POST">';
while($row=mysql_fetch_array($r))
{	
	

	echo " BRAND:       ".$row['brand'];
	echo"</br>";
	echo "MODEL:         ".$row['model'];
	echo"</br>";
	echo "HARDDISC:    ".$row['hdd'];
	echo"</br>";
	echo "RAM :       ".$row['ram'];
	echo"</br>";
	echo "SCREEN SIZE:     ".$row['screen'];
	echo"</br>";
	echo "LAPTOP PRICE:   ".$row['price'];
	echo"</br>";
	echo "PROCESSOR:    ".$row['proccesor'];
	echo"</br>";
	echo " <img src= '".$row['image']." ' height=320 width=200>";
	echo"</br>";
	echo"<b>compare<b>";
	
	//$p_id=$row['product_id'];
	echo'<input type="checkbox"  name="checkbox[]" value='.$row[product_id].'>';///////here i selected checkbox array
	echo"</br>";
	
	
	echo"</br>";

}
echo '<input type="submit" name="submit" value="submit" >';
echo'</form>';
?>

and linked php program is

compare1.php

<?php
$con=mysql_connect("localhost","root","pass");
if(!$con)
echo" not coonected";
else "connected";
mysql_select_db("laptop",$con);
echo.$_post['checkbox'];
$product_id=$_POST['checkbox'];
if(isset($_POST['submit']))
{
for ($i=0;$i<=count($_POST['checkbox']);$i++)
 {
$product_id=$_POST['checkbox'];
echo $product_id;
$result1=mysql_query("SELECT * FROM gallary WHERE product_id=$product_id");
while($row1=mysql_fetch_array($result1))
{
echo " BRAND:       ".$row1['brand'];
echo"</br>";
echo "MODEL:         ".$row1['model'];
echo"</br>";
echo "HARDDISC:    ".$row1['hdd'];
echo"</br>";
echo "RAM :       ".$row1['ram'];
echo"</br>";
echo "SCREEN SIZE:     ".$row1['screen'];
echo"</br>";
echo "LAPTOP PRICE:   ".$row1['price'];
echo"</br>";
echo "PROCESSOR:    ".$row1['proccesor'];
echo"</br>";
echo " <img src= ' ".$row1['image']." ' height=320 width=200>";

}
}

}
?>

it is giving an error
thanx....

[helimeef]

Put some code tags around this so that it's easier to debug. What exactly is the problem?

[PsychoCoder]

You say "It gives an error", well show us exactly what the error message you're getting.