change a value.

[Richardtagger]

I have a submission form where ppl submit an URL, but even though i say dont put the [url]http://[/url] some thick heads still do it so in the db it ends up http://http:// GAH! how can i remove the [url]http://[/url] part of the string if they put it?

thanx

[bubblenut]

preg_replace("/^http:\\/\\//", '', $string);

HTH
Bubble

[rachel2004]

bubblenut has answered your question, but I was wondering if there is a reason for storing the [url]http://[/url] string along with the URI?

Might be better to just store the URI and then, when you pull the record from the database, append it using PHP:

$http = "h t t p://"

while ($row = mysql_fetch_array($result))
{
    echo $http.$row['web_address'];
}

This would save you a little bit of storage space as your db grows, no?

[Richardtagger]

Thanx Rachel and bubble 🙂