Replace - with ","

[raouleduke]

I want to insert this into a query,

-1992-1993-1994-1995-1996-etc....

but I need it changed to this:

'1992','1993','1994','1995','etc.....

How do I change it.

Thanks in advance.

[swr]

As your attourney I advise you to rent a very fast car with no top. And you'll need the PHP...

$str = "-1992-1993-1994-1995-1996-";

// Turn the - into ','
$str = str_replace("-", "','", $str);
// Remove the extra ', from the start, and ,' from the end
$str = substr($str, 2, -2);

echo $str;

[raouleduke]

A Hunter Thompson fan, that's awesome, A fan of excessive drug use, drinking and complete debatchery I hope also. Just one thing more how do I add the ' on the end of the $str there is no dash - on the end.

Thanks,

And remember in the land of the one eyed king the guildedswine is king. HST

[swr]

That's easy... Change this:

$str = substr($str, 2, -2);

To this:

$str = substr($str, 2)."'";

It's important to remove the ,-2 from the substr call, or it will remove the last two characters of the last item. Then it's just a matter of putting a ' on the end.

[raouleduke]

How do I add a ' to the front without removing any, what I want to do is add a ' to the beginning and the end, and replace - with ','.

// Turn the - into ',' 
	$str = str_replace("-", "','", $str); 
	// Remove the extra ', from the start, and ,' from the end 
	$str = substr($str, 2)."'"; 
	echo $str;

Thanks in advance.

[swr]

That's even easier... Change this:

$str = substr($str, 2)."'";

To this:

$str = "'".$str."'";

This is pretty simple string handling stuff. The dot is the string concatenation character. The above line concatenates three strings (the single quote, the contents of $str, and the other single quote) and puts the results into $str.