question re: multiple where values
Posted: Wed Dec 01, 2004 12:37 pm
I would like to select a name field based on a PK field (ref).
I'm using this statement:
The intent is to get multiple names from the records with those ref numbers, but the statement seems to only pick up the name with ref=29.
I'm using this statement:
Code: Select all
$mysql="SELECT name FROM $detail WHERE ref='29, 30, 2, 4, 25'";