$table_name Data
";
$query = "SELECT Product_desc, Cost*Numb FROM $table_name WHERE Product_desc = '$Search'";
print "The query is $query
";
mysql_select_db($database);
$result_id = mysql_query($query);
if($result_id)
{
print '';
// NOTE: only two columns displayed
print '| Product | Total_Val';
while($row = mysql_fetch_row($result_id))
{
print ' | ';
foreach ($row as $field)
print "| $field | ";
print '
';
}
}
else
{ die ("Query=$query failed!"); }
mysql_close($connect);
?>
Search Again