Help with preg_replace

[thePhpLady]

Hi there!

 

I need to echo some text from a database table, this text should be linked to a url stored in the same database. I am trying to do this with preg_replace but I am terrible at it! I keep getting this error:

 

Warning: Wrong parameter count for preg_replace()

 

while($row = mysql_fetch_array( $result ))

{

 

$reg_exUrl = "/(http|https|ftp|ftps)\:\/\/[a-zA-Z0-9\-\.]+\.[a-zA-Z]{2,3}(\/\S*)?/";

 

echo preg_replace ($reg_exUrl, $row['title');

 

 

Any suggestion?

 

Thanks

[premiso]

preg_replace 

 

You need the regex to find, the items to replace and the string where the replace occurs. Not really rocket science.

[thePhpLady]

 

I have changed the code, I understand the mistake. Now I can echo the text but it has no link.

 

while($row = mysql_fetch_array( $result ))

{

 

$reg_exUrl = "/(http|https|ftp|ftps)\:\/\/[a-zA-Z0-9\-\.]+\.[a-zA-Z]{2,3}(\/\S*)?/";

 

echo preg_replace ($reg_exUrl,$row['title'], $row['imageurl']);

[thePhpLady]

How can I show the text in 'title' with a link to 'imagurl'. Can I do that from the database?

[ManiacDan]

Show the contents of Title, Imgurl, and a final example of what you want.  So far you're showing code that appears to want to take one URL out of title and replace it with another URL.

[thePhpLady]

the content of title is : Butterfly dress

the content of imageurl is : http://www.styleandcurves.co.uk/sites/default/files/lb_dress.html

 

 

  Great Plains

Butterfly Dress

      £10

 

What I want to do is click on Butterfly Dress and  be redirected on b_dress.html.

 

Thanks for your help.

[ManiacDan]

So what makes you think you need regex for this at all?

 

echo '<a href="' . $row['imageurl'] . '">' . $row['title'] . '</a>';

[thePhpLady]

Just to complicate my life!

 

It works now, thank you.