Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Re: Re: Re: Re: Somethings not rightwith my MySQL do()

by Fastolfe (Vicar)
on Jul 20, 2002 at 01:52 UTC ( #183529=note: print w/ replies, xml ) Need Help??


in reply to Re: Re: Re: Re: Somethings not rightwith my MySQL do()
in thread Somethings not rightwith my MySQL do()

It would help more if you told me what you were seeing. I mentioned that you should add some debugging code to print out the value of $cat prior to your database update. I do see that you have a print occurring after the database update. Does this get printed by your script? Does it have the correct value for $cat here even though your database is placing a "0" into this record? Are you sure an update is actually occurring in the database? (I.e. is your code reaching this point in its execution?)

I also notice that you may have ignored the advice regarding the use of placeholders and bind variables. You're using user-provided input here directly in your SQL query, which is a horribly bad thing to do. Hopefully you've taken this into consideration and will fix this after you've identified your more immediate problems.


Comment on Re: Re: Re: Re: Re: Somethings not rightwith my MySQL do()

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://183529]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (8)
As of 2015-07-06 10:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (72 votes), past polls