UPDATE dbc_pages_subitems SET Show = 'Yes' WHERE ID = $prod
What the hell. I can't get any updates to work. This is really freaking me out. Maybe I am just tired, as it is 5am?
Someone shoot me! Or at least help me a little with the problem... ;-)
anything wrong with the database connection. do you have the rights to update the table?... must be something else, because the query looks ok.
Thanks for confirming that. I thought I was going nuts. I tried changing the "Show" field to "UseShow" instead... and it worked. So, I suppose Show is a protected word...
🙁
oh, sorry. i had to see that... yes, it`s a protected word to retrieve information about databases, tables, columns, or status information about the server.
