[Resolved] Searching a string...

[stevesweetland]

Im just doing some regular expression searches on a string.

The string is a list of numbers, seperated by a comma. For example

$string = "4,5,12,22,32,2"';

now, i need to search that string for a number, lets say '2'. I need to search that string and ONLY return '2' as a result. I cannot have the code saying there is a match if it matches the '2' in '12' or '22'. Make sense?

Ideas on a postcard please.

[bad76]

Hi,
you can use explode() to put this value in an array.

[cahva]

Yep, I hope I don t spoil the fun now 🙂 :

$string = "4,5,12,22,32,2,2";
$p=explode(',',$string);
$search=2;
$found=0;

while ($f = current($p)) {
        if ($f == $search) {
                echo key($p).'<br>';     

                $found++;
        }
next($p);
}
echo 'Matches:'.$found;

[stevesweetland]

yeah - i would have done that - but the string is in a mysql database. and there is 1800 records, all with their own string. dont really feel like exploding each record one at a time...

its ok tho i got it covered using this code :

//(sql)
$sql = "SELECT * FROM table WHERE field LIKE '%,3,' OR user_interests REGEXP '^3,'";

[bad76]

Nice try, cahva, and nice boing ball too 🙂
But why don't use array_search() ?

stevesweetland I think next time you have to post question like this into DB forum, or however you write that you are talking about data stored in a db, or answer you get will are all useless...

see you

[cahva]

Actually I did use array_search first time, but it only returned one result so I figured, what the hell, lets do it in other way 🙂 Maybe I got "Software Failure" 😉

[bad76]

For multiple result there is array_keys()...

I have to signal you this link... is a my friend from Oulu...
http://saimobvq.interfree.it/MOM/index.html
and maybe it interesting you.

bye bye