When you submit a form, you can specify the method to be either POST or GET.. now it seems the difference among them is obvious, however ... what is the difference?

the search engine i created uses GET.. and basically I have a perl script which uses..
$CGI->param("fieldname").. to retrieve the stuff from the form, and then it takes this variable and puts into an SQL statement which is then sent to the mySQL database and processes and returns query.

Recently I've been trying to do the same thing, but instead of searching the database I want to add data to the database, using SQL insert statements.. Now I don't understand why my code doesn't work, because the script is able to extract the fields from the submited form and print them out on the screen.. however, the actual SQL statement doesn't execute because nothing gets added to a database.

So I was wondering, is this in anyway related to the GET/POST of the form. Theoretically GET shoudl work as long as its able to extract those variables.

I also don't get any error message regarding compilation errors or anything liek that.. so syntax is A-ok..