Help with scripts!

**microcolt** · 11-05-2007, 08:50 PM

I have 2 things i need help with.

1. Can you do more than 1 LEFT JOIN in a MySQL query? If so how can you do this?

2. How can i allow ONLY certain types of HTML to work(like <a href="123">123</a>) when a user does something like post a comment on a page and such?

Thanks in advance!

**joder** · 11-05-2007, 10:12 PM

1. http://dev.mysql.com/doc/refman/5.0/en/join.html
2. http://us2.php.net/manual/en/function.strip-tags.php

**gos1** · 11-06-2007, 03:58 PM

you may create an array for the tags you want users not to use and after that you can use the eregi (looks for the given statement in a string ) function for each of the arrays elements . If there is one prohibited element in the given string it will change a variables value to true . And if the variables value is true than echo an error message else go on ....