Thanks for that. From what I understand this may well be the solution. The only problem is deploying it.
So far I'm trying ...
$Prescriber_Name = $_POST[thing];
$values = implode(", ", $Prescriber_Name);
// open the connection
$conn = mysql_connect("location", "username", "password");
// pick the database to use
//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());
//go through each row in the result set and display data
while($newArray = mysql_fetch_array($result))
... but its not working. Can you tell me if I am on the right track here please?
Following on from my last posting and the tweaks made, I have discovered that selecting a single entry from the multi line list box works. Full results are displayed as required. However, it is the multiple selection that is failing. With more than one line selected I get zero rows returned.