[Resolved] Website Link From The Database

[usernot]

Hello,

In my database table I have a WEBSITE column where I enter a businesses website in the following format: www.website.com However, when a search is done for a business and the search page pulls the WEBSITE information from the table, it shows it exactly how it was entered: www.website.com

echo "<strong>$business</strong><br> <u>Website</u>: $website<br><br>";

What I would like is to have it so that when the website information is shown on the results page, it shows the www.website.com but if you click on it, it will open up another window and take you to that particular website.

Any suggestions??

Thanks!

[hmemnon]

<strong><?=$business?></strong><br> <a href="http://<?=$website?>" target=_blank>: <?=$website?></a><br><br>"; 

Cheers

[usernot]

hmemnon,

I replaced what I had with what you suggested but I am getting an error...

Parse error: parse error, unexpected '<'

Any ideas?

Thanks!

[hmemnon]

Can you post your code here plz? Along with the full error message.
Thx

Cheers

[usernot]

<?
mysql_connect("user","password");

mysql_select_db("database");

$explode = explode(' - ', $_POST['submit']);
$result = mysql_query('SELECT * FROM table WHERE business REGEXP "^[' . $explode[0] . '-' . $explode[1] . ']" ORDER BY business');
while($r=mysql_fetch_array($result))
{

$business=$r["business"];
$website=$r["website"];

echo "<strong>$business</strong><br> <u>Website</u>: $website<br><br>";

}
}
?>

[hmemnon]

echo "<strong>$business</strong><br> <u>Website</u>: <a href=\"http://$website\" target=_blank>$website</a><br><br>"; 

SHould work

Cheers

[usernot]

hmemnon,

You are awesome! Thanks so much- it worked!!!

[hmemnon]

You're welcome

Cheers