Need Urgent MySQL Help

[Domains4u]

Hi all. Im in some real trouble here.


LINK: http://www.ukgmc.com/radio/add.php


Ive created a database that stores Radio URLs, and displays them in a .php file........all fine and good.

I then placed a form at the top of the page for users to enter there own submissions........all fine a good.

When a user submits a url its adds to the database and Displays 'ADDED TO DATABASE', but if the user then presses refresh it will add it again. I somehow need to stop duplicate entries into the database, becuase this could become a vunrability for hackers or annoying script kiddies who want to flood the databse.

Whats the best way to stop this?

Regards.

 

[weblord]

http://www.captcha.net/
download here:
http://www.puremango.co.uk/cm_php_captcha_script_113.php

php implementations found here:
http://en.wikipedia.org/wiki/Captcha

 

[Peter]

Alternatively you could do a select query in the script to check if it already exists, if it does then it will not be added. This of course will also stop someone maliciously adding the same url constantly.

A possible other alternative is to make the field in the database that holds the URL inique.

 

[Domains4u]

Fixed now. Thanks to SecondVersion