extracting from a pattern

[Lionel]

I've got this pattern in a category table:

PHP Code:

 3#35#0:2#15#0:7#93#0:7#101#0:1#1#0:1#3#0:5#71#0:6#86#0:4#57#0 


I must do a query to extract only what is between the # e.g. 35 15 93 101 etc... as subcats

then from those results I need to do another query in another subcategory table in order to get the name from those subcats id

and create a list with a link for each one of them like

a href= view.php?subcat=35>subcat 35 name
a href= view.php?subcat=15>subcat 15 name

etc....

if extracted list count ==1 then instead of displaying a link I simply do a redirect to that subcat (no need to display it for selection)



That one is a big toughy for me. Can someone please help?

Thanks.

[Marco van Herwaarden]

You can do it with an REGEX, but you should think about normalizing your tables and create new rows for each sub category.

[Lionel]

That's a premade script from which I am trying to extract that info. I am looking at ereg_replace. That will give me 35 15 93 101 as one line but how do I get them individually as items?

[AN-net]

explode the spaces and make them into an array

[Lionel]

That's easy to say :speechless:
I got somewhere the hard way

PHP Code:

 $string = $f[category];
$string2 = ereg_replace('^.[#]', '', $string);
$string3 = ereg_replace('[#].[:].[#]', ',', $string2);
$string4 = ereg_replace('[#].','', $string3);
$array = array($string4); 


before

PHP Code:

3#35#0:2#15#0:7#93#0:7#101#0:1#1#0:1#3#0:5#71#0:6#86#0:4#57#0 


after

PHP Code:

35,15,93,101,1,3,71,86,57 


now I have to find a way to put quotes around the values

then I'll struggle to extract each one of them individually from array

now that my $string5 looks like this

PHP Code:

"35" , "15" , "93" , "101" , "1" , "3" , "71" , "86" , "57" 


if I do

PHP Code:

$array = ("35" , "15" , "93" , "101" , "1" , "3" , "71" , "86" , "57" );
echo count($array); 


the count correctly returns 9

but if I do

PHP Code:

$array = array($string5);
echo count($array); 


I get only one :disappointed:

[AN-net]

just explode() $string5 using ',' as the separator

[Lionel]

I did that and I get

PHP Code:

35 15 93 101 1 3 71 86 57 


but I am still getting 1 for count

PHP Code:

$subcats = explode(",", $string5);
 $array = array($subcats);
echo "<br />";
echo count($array); 


[Marco van Herwaarden]

There is no need for the line: $array = array($subcats);

Remove that and it will work.

[Lionel]

:banana: I found a nice article about arrays and I've got everything where I wanted it, only one problem remains and you just gave me perhaps a solution. The count is what is wrong. I have nine items but it is printing 90...

edit: hihihi take that back... the "0" was from an echo I forgot to remove.