Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Somethings not rightwith my MySQL do()

by gav^ (Curate)
on Jul 20, 2002 at 01:45 UTC ( #183526=note: print w/ replies, xml ) Need Help??


in reply to Somethings not rightwith my MySQL do()

You've got the UPDATE syntax wrong, it should be like:

UPDATE category SET name = ?, view_cats_prod = 'yes' WHERE id = ?

You should really test your SQL statements before you put them into your perl code.

Documentation can be found (for mysql) here.


Comment on Re: Somethings not rightwith my MySQL do()
Re: Re: Somethings not rightwith my MySQL do()
by andrew (Acolyte) on Jul 20, 2002 at 01:51 UTC
    Thank you I though you could use AND in SET I gues its commas thanks

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (8)
As of 2014-08-27 22:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (253 votes), past polls