Quotes driving me crazy :-)

[Working with PHP3 on a shared NT server. No access to php.ini. ODBC connection to an MS SQL Server 7 database] I was having problems with single quotes. The magic_quotes setup in the ISP's php.ini was driving my SQL Server 7 nuts. The following two lines took care of all the insert display problems I was having: $sql = str_replace("\'","''",$sql); $sql = stripslashes($sql); The first allowed me to insert the singles and the second the doubles. My next big challenge concerns xhtml compliance and inserting clickable URLS in the article in my database. I initally searched for the double quotes and replaced them with &quot;. Worked fine for stuff like &quot;I love PHP,&quot; he said. Where I'm still having problems is making my URLs clickable and compliant _and_ SQL friendly. <a href="/pageonmysite.html">A page</a> hangs up the insert form. <a href=&quot;/pageonmysite.html&quot;>A page</a> creates a link but the &quot; throws off the address in the browser and makes it http://www.site.com/"pageonmysite.html" instead of http://www.site.com/pageonmysite.html Any advice would be appreciated. -- Ian Evans