Welcome to the E-Blah Community!
We would like to welcome you to our community and invite you to register an account or login.
Being a registered member is important, as it gives you several advantages over the normal Guest status. After registering you will be able to download files and images, post messages, and access member-only portions of the forum - just to name a few. Registration is quick and simple, and only takes about a minute of your time.

E-Blah Community    E-Blah SQL Technical Support    General E-Blah SQL  ›  sql update?
Users Browsing Forum
No Members and 1 Guests

sql update?  This thread currently has 930 views. Print
1 Pages 1 Recommend Thread
der_hippe_Chip
August 9, 2009, 3:54am Report to Moderator Report to Moderator

E-Blah Member
Posts: 6
Posts Per Day: 0.01
Time Online: 2 hours 32 minutes
can somebody help me with an update order?

i just need:
update topics set freigeschaltet = 0 where id = $URL{'id'}

i allready tried:

          $sql = SQL->new('topics');
          $sql->set('freigeschaltet');
          $sql->where('id');
          $sql->update('0',$URL{'id'});

but nothing helps
i never seen SUCH statements bevore and i do not know how to use them

/edit: you can close the post, i found out what was wrong
the right syntax is:

          $myid = $URL{'m'};
          $sql = SQL->new('topics','id');
          $sql->set('freigeschaltet');
          $sql->where('id');
          $sql->update(0,$myid);

Revision History (1 edits)
der_hippe_Chip  -  August 9, 2009, 4:26am
Logged Offline
Private Message Private message
1 Pages 1 Recommend Thread
Print


Thread Tags