Work this one out

NZ_Kiwis

I have heaps of row in my SQL DB

ID 1 - 14,88,11,2,114
ID 2 - 99,1,8,14
ID 3 - 999,14,16,2

I want to write a code which runs through everline line and exlodes it finds a set number ie: 2 and echo's the row nubmer in this case Row 1 and Row 3

How can this be done?

fuzic

guessing this is not fulltext... possible you could narrow the sql query down if it were (reduce the chances of running into a memory overload).

// the integer to be matched (or string, whatever)
$match="2";

$result=mysql_query('get your rows');
for ($i=0;$i<mysql_num_rows($result);$i++){
$string=mysql_result(blah blah);
$breakdown=split(",",$string);
if (in_array($match,$breakdown)){
echo "row".$i."<br />";
}
}

kburger

How can this be done?

By first normalizing your database. Then it's pretty trivial. Not trying to be flippant about it, but seriously, is there a valid reason your data looks like that?

NZ_Kiwis

because there is a field which has numbers in it.. a user might have three numbers they might have 10 numbers... what other way of doing this should i use?

laserlight

what other way of doing this should i use?

A normalised database. PHPBuilder even has an article on it.

kburger

Without knowing what all those numbers mean, it's a little hard to tell you what your table structure should look like, but it might look something like this:

userid|number
1|14
1|88
1|11
1|2
1|114
2|99
2|1
2|8
2|14
3|999
3|14
3|16
3|2

Then your query is simply:

SELECT userid FROM tablename WHERE number='2';