$values = implode(",", $your_array);
  $query = "SELECT * FROM table WHERE column IN ($values)"

<?php
 
 
$Prescriber_Name = $_POST[thing];
$values = implode(", ", $Prescriber_Name); 
 
// open the connection
$conn = mysql_connect("location", "username", "password");
 
// pick the database to use
mysql_select_db("database",$conn);
 
//create the sql statement
$query = "SELECT * FROM  prescribing_test WHERE prescribing_test.Prescriber_Name IN ($values)"
 
 
//execute the SQL statement
$result = mysql_query($query, $conn) or die(mysql_error());
 
 
 
mysql_close($conn);
 
 
?>
 
<table>
<tr>
<th><B>Prescriber Name</B></th>
<th><B>BNF Name</B></th>
<th><B>Total Items</B></th>
</tr>
 
<?
 
//go through each row in the result set and display data
while($newArray = mysql_fetch_array($result)) 
 
{
 
?>
 
<tr>
<td><?=$newArray["Prescriber_Name"]?></td>
 
<td><?=$newArray["BNF_Name"]?></td>
 
<td>><?=number_format($newArray["Total_Items"],0,'.',',')?></td>
 
</tr>
<?
 
}
 
 
?>
 
</table>

  <?php echo $newArray["BNF_Name"]; ?>

$query = "SELECT * FROM prescribing_test WHERE prescribing_test.Prescriber_Name IN ('$values')";

$sql = "SELECT * FROM  prescribing_test WHERE Prescriber_Name IN ('$value')";

<?php echo $newArray["BNF_Name"]; ?>  <?php echo $newArray["BNF_Name"]; ?>

$num_rows = mysql_num_rows($result);
echo "$num_rows Rows";

$values = implode("','", $_POST[thing]);