How to prevent SQL injection?

Last week, I posted a demo video on SQL injection. If you would like to know what you should do to your web application to prevent SQL injection, please read this article Security Corner: SQL Injection, which was published in php|architect.

SQL injection is usually caused by user inputs and therefore washing your input and escaping your output help protect your web application from such attacks.

[tags]programming, sql, mysql, php, sql injection, web development[/tags]