Posted - 06/19/2013 : 14:54:38
| I manage a sql database for one client who happens to operate a funeral home. We use a "Tribute Submission" page that puts their tributes into a database awaiting my approval or removal of them before they are posted to a deceased's tribute page. I am getting spam submissions of SQL injection errors around 300-900 per day. This is my error code that shows....
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 42 in /home/content/23/8106623/html/Skradski/tributes.php on line 178
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 42 in /home/content/23/8106623/html/Skradski/tributes.php on line 179
and I am getting submissions that look like this:
queens science museum
quinn travel insurance
rain water harvesting pictures
What can I add to my tribute.php page to stop these postings from being submitted into my approval/disapproval database? It is taking me almost 2 hours a day to clean out all the spam submissions.
Any helpful suggestions?