Forum Discussion

Unico001's avatar
Unico001
Copper Contributor
Jun 17, 2023

SQL Help

I'm no doubt in the wrong place but I'm desperate. Can anyone tell me where I can get help with an SQL problem- I have a Table UPDATE that doesn't work and just can't find the problem.

Thank you

Michele

  • Unico001's avatar
    Unico001
    Jun 19, 2023
    Thanks olafhelper. At the time of my post I really wanted to know in which forum I should post the problem. As for my problem, I finally found the problem. I had "WHERE `user`="userid" instead of '$userid' -$ sign missing. Unfortunately there was no error message. It just didn't work.
  • olafhelper's avatar
    olafhelper
    Bronze Contributor

    I have a Table UPDATE that doesn't work and just can't find the problem.

    Unico001 , "doesn't work" is something we can work on; it says nothing.

    That's really to less on information.
    Please post table design as DDL, some sample data as DML statement and the expected result.

    And if there is an error message, then please post the complete error text.

    • Unico001's avatar
      Unico001
      Copper Contributor
      Thanks olafhelper. At the time of my post I really wanted to know in which forum I should post the problem. As for my problem, I finally found the problem. I had "WHERE `user`="userid" instead of '$userid' -$ sign missing. Unfortunately there was no error message. It just didn't work.