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 musing on the Monastery: (3)
As of 2014-07-14 05:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (255 votes), past polls