FIND_IN_SET not retrieving results (PHP)

Question

I am troubles with this method not returning results. There are ids within 'table' that match the array. I guess it's not liking something, except I cannot quite put my finger on it.

$define = ",8,9,10,";

// ** Data Retrieve ** // 
mysql_select_db($database_db, $db);
$query_data = "SELECT * FROM table WHERE FIND_IN_SET('".$define."', id)";
$data = mysql_query($query_data, $db) or die(mysql_error());
$row_data = mysql_fetch_assoc($data);
$totalRows_data = mysql_num_rows($data);

You have the arguments reversed to `FIND_IN_SET()`. The target value is first, and the list second. http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_find-in-set — Michael Berkowski, Aug 27 '14 at 01:32
But in this instance, since your column is `id` in the database and your set is user-supplied, this is more appropriately done with an `IN()`. `SELECT * FROM table WHERE id IN (8,9,10)` — Michael Berkowski, Aug 27 '14 at 01:33
Thanks @MichaelBerkowski I was thinking that that might be the crux of it, I tried the IN command though had my commas in the wrong place. Really appreciate your feedback / insight. — Brandrally, Aug 27 '14 at 01:41
Would be great to give you the points if you want them. Else, I can draw it up. — Brandrally, Aug 27 '14 at 02:21

score 0 · Answer 1 · answered Aug 27 '14 at 02:34

0

In FIND_IN_SET the target value is first, and the list second. So, the query should be as follows:

SELECT * FROM table WHERE FIND_IN_SET(id,'".$define."');

answered Aug 27 '14 at 02:34

Tarun Parswani

4,565
3
13
13

FIND_IN_SET not retrieving results (PHP)

1 Answers1