[richardhotscript]

Hi guys

I have a mysql question. here's my problem.

I have a table with a column that contains two IDs from a separate table.
the IDs are separated by commas like this


Now these two IDs are located in separate table so I made my query like this:
$sql=mysql_query("select * from tb_client_category where id like '%$id%' ");

instead of returning only 110 and 52 it return these IDs 110,52 and 1 when it should ony be 110 and 52. Can you guys help fix this? Is there I can fix this without modifying the structure of my table?

Thanks

[End User]

Originally Posted by richardhotscript

instead of returning only 110 and 52 it return these IDs 110,52 and 1 when it should ony be 110 and 52. Can you guys help fix this? Is there I can fix this without modifying the structure of my table?

If you use "LIKE" then mySQL returns all of the values that match any part of your specified string, which is probably why you're getting values back that you don't want or expect.

[richardhotscript]

so using LIKE is not correct for this right? so what am I going to use? the datatype for this comma separated ID is varchar.

[landing]

It might be better to pull the row then split up the ID's, then use them separately? I presume you know the ID's that you need to pull?

PHP Code:

$client_category = explode(",", $row['client_category']);

// This will loop through all the comma seperated caterogy ID's available
foreach ($client_category as $k => $category_id) {
    // Use the $category_id you need here
} 


Ignore me if I have misunderstood!