code adds my url to url for link?

[djr33]

Honestly I have no idea. Clearly some part of the process, unknown to us, is doing something odd. All I can say is double check all the code and be sure that it isn't like that in the database. Can you export/backup the db and go trough it manually?

[I am Abby]

It looks correct in the database.
Well thanks for your time anyway

[traq]

this is it <a href=\"http://www.uiuc.edu\">U of I</a></p><p><strong>September 14, 2010</strong></p>

But when you move the mouse over the link on the page it looks like

http://mysite.com/%22http://www.there.com

In your source code, are the backslashes present before the doublequotes ( \" )?

If something (some kind of server configuration, most likely) is automatically adding a base url to your links, it probably looks for href attributes that seem to be internal. The slashes (which shouldn't be there) might be interfering with that check...

Maybe. ( ??? )

Try running stripslashes() on the url the database returns and see if helps.

while($r = mysql_fetch_assoc($q)) {

//  try it here - I think that'll catch it
stripslashes($r);

print_r($r);
} 

Also try adding an external url ( <a href="http://www.othersite.com">external</a> ) directly into your html and see if the base url is added or not.

You could also contact your service provider and see if there is someway to turn that "feature" off.

[I am Abby]

one of my friends said because the urls in the source code has slashes

<a href=\"http://page.com\">link</a>

I should do a remove slashes...so I tried

// Make a MySQL Connection
mysql_connect("xxx.xxx.xxx.xx", "login", "password") or die(mysql_error());
mysql_select_db("nlchdb") or die(mysql_error());

// Retrieve all the data from the "webcalendar_events" table
$result = mysql_query("SELECT * FROM webcalendar_events WHERE dt >= now() AND color='ffff00' ORDER BY dt")
or die(mysql_error());  

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
//remove code we don't need to see for this.
<snip>---</snip>
 list($year, $month, $day) = split('[/.-]', $row['dt']);
 $month = $monthnames[$month];
 $str = stripslashes($row['description'];
 echo "<p><strong>{$month} {$day}, {$year}</strong><br />".
 "Decription: {$str}</p>";

and that didn't remove them.
So I came back here and saw your post and tried...

// Make a MySQL Connection
mysql_connect("xxx.xxx.xxx.xx", "login", "password") or die(mysql_error());
mysql_select_db("nlchdb") or die(mysql_error());

// Retrieve all the data from the "webcalendar_events" table
$result = mysql_query("SELECT * FROM webcalendar_events WHERE dt >= now() AND color='ffff00' ORDER BY dt")
or die(mysql_error());  

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
 stripslashes($row);
//remove code we don't need to see for this.
<snip>---</snip>
 list($year, $month, $day) = split('[/.-]', $row['dt']);
 $month = $monthnames[$month];
 echo "<p><strong>{$month} {$day}, {$year}</strong><br />".
 "Decription: {$row['description']}</p>";

Again it did not take the slashes out...is there another way to do it?

I not only put

<a href="http://www.othersite.com">external</a>

on the page I also placed

echo "<a href=\"http://www.othersite.com\">external</a>";

within the code tags...both worked correctly.

[traq]

You might try stripslashes() in the individual entry that holds the link - I just noticed that $r is the entire row. Try stripslahes($r['link']) (or whatever the column that holds the link is called).

If you write a normal external link directly in your html, do you still get this problem? or is it limited to the links this script is generating?

[I am Abby]

 
 <snip>
 list($year, $month, $day) = split('[/.-]', $row['dt']);
 $month = $monthnames[$month];
 echo "<p><strong>{$month} {$day}, {$year}</strong><br />".
 "Decription: {stripslahes($row['description'])}</p>";
}

The above gave me an error
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

I tried that earlier and it's the reason I tried

<snip>
$str = stripslashes($row['description'];
 echo "<p><strong>{$month} {$day}, {$year}</strong><br />".
 "Decription: {$str}</p>";

which did not remove the slashes

[I am Abby]

It worked.
Thanks Boys