Hi there...I have a problem here...i got 3 checkbox-cat,dog,snake... when user click cat checkbox..the result is been displayed perfectly...but when the user click more than 1 checkboxe, only 1 of the checkbox value is been displayed..here are my codings..pls help...
<?
$connection = @mysql_connect("localhost", "root") or die("Couldn't connect.");
$db = @mysql_select_db($db_name, $connection) //select database
or die("Couldn't select database.");
if(isset($_POST['action']) && is_array($_POST['action']) && !empty($_POST['action']))
{
$action_list = "'" . implode("','",$_POST['action']) . "'";
$sql = "SELECT * FROM $table_name WHERE product_no like '%$product_no%' and action in ($action_list) and required_date >= '$required_date1' and required_date <= '$required_date2' and mfg_vendor='$mfg_vendor'";
$query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());
while($result = mysql_fetch_array($query)) {
$univac_po = stripslashes($result["univac_po"]);
$product_no = ($result["product_no"]);
$required_date = ($result["required_date"]);
$action = ($result["action"]);
}
echo "<table width=\"75%\" border=\"1\"> \n";
echo "<tr> \n";
echo "<td width=\"15%\">$product_no</td> \n";
echo "<td width=\"15%\">$univac_po</td> \n";
echo "<td width=\"15%\">$required_date</td> \n";
echo "<td width=\"15%\">$action</td>\n";
echo "<td width=\"15%\">[ <a href='display_oc.php?univac_po=$univac_po'>View</a> ]<br>";
echo "</table> \n";
}
?>
