Gossamer Forum
Home : General : Databases and SQL :

How do i display sql errors?

Quote Reply
How do i display sql errors?
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.
Subject Author Views Date
Thread How do i display sql errors? TheIceman 5527 Oct 22, 2002, 6:12 AM
Thread Re: [TheIceman] How do i display sql errors?
Paul 5392 Oct 22, 2002, 6:18 AM
Thread Re: [Paul] How do i display sql errors?
TheIceman 5385 Oct 22, 2002, 7:14 AM
Thread Re: [TheIceman] How do i display sql errors?
Paul 5402 Oct 22, 2002, 7:53 AM
Thread Re: [Paul] How do i display sql errors?
TheIceman 5367 Oct 22, 2002, 3:52 PM
Thread Re: [TheIceman] How do i display sql errors?
TheIceman 5391 Oct 23, 2002, 10:01 PM
Post Re: [TheIceman] How do i display sql errors?
TheIceman 5318 Oct 25, 2002, 7:31 AM
Post Re: [TheIceman] How do i display sql errors?
Alex 5303 Oct 25, 2002, 1:28 PM