groupbrand

I have an issue when trying to retrieve results from an inner join query where the tables queried have column names. Basically if I inner join table1 with table2 and they both contain an id field, the query results return a table1.id and table2.id (along with any other column data requested). When I run through the results using mysql_fetch_assoc I can grab any unique column data but using $row['colname'] but I cannot get data from columns that have the same name e.g. $row['table1.id'] - can anyone point me in the right direction? Thanks in advance!

My client has an old application that did not clean the data before storing it into the MySQL database - basically they would copy and paste directly from word into a text box and PHP would just store whatever that looked like. Looking at the old database the information is still preserved (e.g. a bullet point would like like one rather than an html tag etc.) but when I export the data in order to create a new database MySQL converts this information into a series of funny characters so that they import weirdly and means I cannot convert them back to their original format! For the most part it happens with '£' signs and bullet point (the many that word can output). Any ideas on how to correct these and clean this data in order to move forward would be massively appreciated. DK.

Hi, I am trying to remove specific tag attributes from my HTML whilst leaving some intact. Really I need a regular expression that matches a list of 'accepted' tag attributes (e.g. href) and removes all others (e.g. style, class etc.) as in the following example: <a href="http://mysite.com" target="_blank" class="myclass"> would become <a href="http://mysite.com" target="_blank"> However, i won't just be matching <a> tags but all tags including <p>, <ul>, <li> etc. Hope someone can help! Cheers.