Ive got a perl script that loops and updates a mysql database as it loops with variables in the sql statement. This is the exact statement below
my $sql_update = "UPDATE members_rankings SET members_rankings.name = '$FORM{$newname}', members_rankings.regno = '$FORM{$newregno}', members_rankings.rank1 = '$FORM{$newrank1}', members_rankings.rank2 = '$FORM{$newrank2}', members_rankings.regexpireday = $FORM{$newregexpireday}, members_rankings.regexpiremonth = $FORM{$newregexpiremonth}, members_rankings.regexpireyear = $FORM{$newregexpireyear}, members_rankings.profile = $FORM{$newprofile}, members_rankings.profileloc = '$FORM{$newprofileloc}', members_rankings.club = $FORM{$newclub} WHERE (((members_rankings.memid)=$count))";
The script wont run. it wont give any errors neither, it just sits on a white blank screen saying its done. Theres obviously an error that halts the damn script. How do i find out what the error is? i have no access to error logs.
my $sql_update = "UPDATE members_rankings SET members_rankings.name = '$FORM{$newname}', members_rankings.regno = '$FORM{$newregno}', members_rankings.rank1 = '$FORM{$newrank1}', members_rankings.rank2 = '$FORM{$newrank2}', members_rankings.regexpireday = $FORM{$newregexpireday}, members_rankings.regexpiremonth = $FORM{$newregexpiremonth}, members_rankings.regexpireyear = $FORM{$newregexpireyear}, members_rankings.profile = $FORM{$newprofile}, members_rankings.profileloc = '$FORM{$newprofileloc}', members_rankings.club = $FORM{$newclub} WHERE (((members_rankings.memid)=$count))";
The script wont run. it wont give any errors neither, it just sits on a white blank screen saying its done. Theres obviously an error that halts the damn script. How do i find out what the error is? i have no access to error logs.