Re: Parsing URL/Form to grab ID for MySQL

[Randy Clamons]

Other than using double quotes where single quotes would work fine, your script looks like it should work. Are you sure you are filling values for $rndnum1 and $rndnum2?

Have you tried submitting the query as a straight html request, not ajax?

Here's my suggestion for a start on debugging:

use CGI;
my $cgi = CGI->new();
my $myid = $cgi->param("id");
print "QUERY_STRING: $ENV(QUERY_STRING}<br>\n"
print "myid: $myid<br>\b"; #this line isn't printing anything at all

Then paste into your address bar: http://www.mydomain.com/mysqlinsert.pl?id=5

Substitute the actual path and a valid id. If this works (you should see the entire query string), then try again with AJAX call.