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.