Help with sscanf() function

[Anon]

Hi,

I'm trying to parse the return of a set of mySQL ENUM options returned from a mySQL query. The returned value is as such:

enum('wip','backburner','retired','completed')

I'm currently using the sscanf() function to try to rip off the "enum" and parenthisis portions of the string:

$enumStr = "enum('wip','backburner','retired','completed')"

sscanf($enumStr,"enum('%s')",&$setList);

I'm expecting this to return:

wip','backburner','retired','completed

From there I could just use the explode function to get my actual values. But instead it returns this:

wip','backburner','retired','completed')

Why does it return the trailing "')"? How can I get sscanf() to return everything but? Is there an easier way to do what I'm trying to do?

Thanks,
Chris Bloom

[psr540]

I had the same problem before, seems to be a bug? cause if there is a space before the )' like enum('a','b','c' )', it will work.

anyway, here is the solution for you:

$setList = preg_replace("/enum(\'([\S]+)\')/","\1", $enumStr);

check preg_replace for more detail about this function, it's magic!