Variable split

ramu_rp2005

Hi all,
I've got a variable $query holding values as say,
$query="s.stream_name,s.stream_id,v.video_pid";

How do i split this variable values as per comma and store each in a n array?

stewartship

Hi Ramu

if the $query is a string (you state it is a varibale and not a mysql query) the you can do:

$new_variables = explode(',',$query); // this will split the string at all ,

$new_variables[0]; // will hold s.stream_name
$new_variables[1]; // will hold s.stream_id
$new_variables[2]; // will hold v.video_pid

You can access these variables as above and assign them new names or arrays etc.

IF it is a database query, could you just verify exactly what you are trying to do and can give you some help.....

saraadmin

Er, with the explode(separator, string) function?

Please read the manuals. They're quite good, you know ;-)

stewartship

Hey saraadmin!
Yeah i know about the manuals!

But was not sure if that was what ramu_rp2005 was after, or if it was a mysql query that ramu_rp2005 was interested in, so just thought i would post a small bit of info to see if was any help, and if not then to try and help with the query!

saraadmin

Sorry, stewartship. I must have still been typing my reply when you posted yours. It was a fresh thread when I started!