[RESOLVED] IN() MySQL Function error

[spudmurf2k]

Hi,

The script below is working, only instead of showing all applicable records, it shows n-1 records - ie, I had 3 it shows 2, I had 4 it shows 3. I'm running windows xp pro n mysql 5.0.9-beta-nt, could this be a platform specific problem? If anyone has any suggestions please say so. Thanks.

$catchmentareas = '1, 2';         # Is got from a db, string here for convenience
$query = "SELECT * FROM properties WHERE area_id IN(" . $catchmentareas . ") ORDER BY dateadded DESC;";

$result = mysql_query($query);

while ($data = mysql_fetch_array($result)) {
	echo $data['address1'];     # Only one field echoed for testing purposes.
	echo '<br>';
	}