function in a mysql array. doh!

[doofy]

I hope I'm not being a vampire here sucking the life out of you guys, but I can't find any resources in google that explains how to properly use this function in a mysql array. All it does is add a url for any urls added in plaintext.

 

Code:

---

<?php

 

function hyperlink ($string) {

$string = preg_replace('#(^|\s)([a-z]+://([^\s\w/]?[\w/])*)#is', '\\1<a href="\\2" target="_blank">\\2</a>', $string);

$string = preg_replace('#(^|\s)((www|ftp)\.([^\s\w/]?[\w/])*)#is', '\\1<a href="http://\\2" target="_blank">\\2</a>', $string);

$string = preg_replace('#(^|\s)(([a-z0-9._%+-]+)@(([.-]?[a-z0-9])*))#is', '\\1<a href="mailto:\\2">\\2</a>', $string);

return $string;

}

 

// mysql connection

 

$result = mysql_query("SELECT * FROM top_web_articles ORDER BY ID DESC");

 

echo "<table border='0'>";

 

while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td class='newstitle' align='left' valign='top' bgcolor='#D6D6D6'>".$row['Category']."</td></tr>";

  echo "<td class='newstitle' align='left' valign='top' bgcolor='#D6D6D6'>". $row['ArticleName'] ."</td></tr>";

  echo "<td class='newstitle' align='left' valign='top' bgcolor='#D6D6D6'>"hyperlink(. $row['ArticleDescription'] .);"</td></tr>";

  echo "<tr><td  class='newstitle' align='left' valign='top' bgcolor='#D6D6D6'><a href='". $row['URL'] . "' target='_blank'><img src='http://www.thenewsguys.ca/images/read entire article.png' alt='' width='130' height='11' border='0' /></a></td>";

  echo "</tr>";

  echo "<td align='left' valign='top'> </td>";

}

echo "</table>";

 

mysql_close($con);

?>

---

 

Error:

"Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/doofyd5/public_html/trevor/playground/displayarticles.php on line 146"

 

(Clearly an error where I'm abusing the heck out of the bolded line. Any ideas on how to properly code this?

[QuickOldCar]

I think this should work

 

echo "<td class='newstitle' align='left' valign='top' bgcolor='#D6D6D6'>".hyperlink($row['ArticleDescription'])."</td></tr>";

 

[doofy]

That seemed to produce the exact same error. It's not happy with what I did at all. Thanks for the reply though, I appreciate the effort.

[teynon]

Whats line 146

[doofy]

Line 146 is what I put in bold.

 

When I remove the semi colon, I get no error, but it doesn't function either. Weird!!!

[MasterACE14]

What QuickOldCar posted should of fixed it. Post your latest code.

[teynon]

doofy, if that line is line 146, then you didn't actually run QuickOldCar's code in place of that.

 

I think this should work

 

echo "<td class='newstitle' align='left' valign='top' bgcolor='#D6D6D6'>".hyperlink($row['ArticleDescription'])."</td></tr>";

 

 

Swap out that line with what he posted and try again.

[doofy]

I've copied and pasted it now. It's producing no errors but the function doesn't seem to be applying.

[doofy]

<?php

 

function hyperlink ($string) {

$string = preg_replace('#(^|\s)([a-z]+://([^\s\w/]?[\w/])*)#is', '\\1<a href="\\2" target="_blank">\\2</a>', $string);

$string = preg_replace('#(^|\s)((www|ftp)\.([^\s\w/]?[\w/])*)#is', '\\1<a href="http://\\2" target="_blank">\\2</a>', $string);

$string = preg_replace('#(^|\s)(([a-z0-9._%+-]+)@(([.-]?[a-z0-9])*))#is', '\\1<a href="mailto:\\2">\\2</a>', $string);

return $string;

}

 

//connection

 

$result = mysql_query("SELECT * FROM top_web_articles ORDER BY ID DESC");

 

echo "<table border='0'>";

 

while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td class='newstitle' align='left' valign='top' bgcolor='#D6D6D6'>".$row['Category']."</td></tr>";

  echo "<td class='newstitle' align='left' valign='top' bgcolor='#D6D6D6'>". $row['ArticleName'] ."</td></tr>";

  echo "<td class='newstitle' align='left' valign='top' bgcolor='#D6D6D6'>".hyperlink($row['ArticleDescription'])."</td></tr>";  echo "<tr><td  class='newstitle' align='left' valign='top' bgcolor='#D6D6D6'><a href='". $row['URL'] . "' target='_blank'><img src='http://www.thenewsguys.ca/images/read entire article.png' alt='' width='130' height='11' border='0' /></a></td>";

  echo "</tr>";

  echo "<td align='left' valign='top'> </td>";

}

echo "</table>";

 

mysql_close($con);

?>

[Spring]

Where's your mysql connection?

[doofy]

damn the code provided did work, it wasn't producing errors because there wasn't a valid http as it was in brackets.

 

Thanks a million!