AKB Forums

Go Back   AKB Forums > Technical sections > Languages, Compilers and Interpreters
Home Register Blogs FAQ Members List Calendar Downloads Arcade Mark Forums Read

Languages, Compilers and Interpreters C,C++,C#,.NET,Java,PHP,Perl,SQL and more

Troubles when posting message? Click here! :: Проблемы с отправлением сообщения? Нажмите сюда!

Reply
 
LinkBack Thread Tools Display Modes
Old Jun 24, 2004, 11:47   #1
Младенец
 
Join Date: Nov 2002
Location: Skofja Loka , Slovenia
Posts: 19
Rep Power: 0
Reputation: 10
Update statement in Mysql

jhoghovurd jan stegh mi hat khdir unem Mysql-i het karogha ogneq ?
bacatrem , unem table vori mej ka datark "row" , "varchar" tipi
uzum em et amen angam et row-@ update anem u inch vor bar gumarem

mysql_query("update msg set viewer=viewer + '$word ' wher id=1")

senc grum em et row-@ datark lini liq@ lini darcnuma "0"
vonc anem vor inq@ datark lini script@ ashkhatacnem darna "top" heto avelana mi urish bar darna "top top1" heto "top top1 top2" tenc
x.ice is offline   Reply With Quote Quote selected
Old Jun 24, 2004, 12:41   #2
Administrator
 
acid's Avatar
 
Join Date: Sep 2001
Location: South Korea, Gumi
Posts: 7,163
Blog Entries: 15
Rep Power: 10
Reputation: 298
Quote:
Originally Posted by x.ice
jhoghovurd jan stegh mi hat khdir unem Mysql-i het karogha ogneq ?
bacatrem , unem table vori mej ka datark "row" , "varchar" tipi
uzum em et amen angam et row-@ update anem u inch vor bar gumarem

mysql_query("update msg set viewer=viewer + '$word ' wher id=1")

senc grum em et row-@ datark lini liq@ lini darcnuma "0"
vonc anem vor inq@ datark lini script@ ashkhatacnem darna "top" heto avelana mi urish bar darna "top top1" heto "top top1 top2" tenc
Подразумеваю что это ПХП.
Для начала select-ом прочти что в этом row и сохрани в $oldword -е.
$query = 'update msg set viewer=' . $oldword . ' ' . $newword . 'wherе id=1';
mysql_query($query);

Удачи.
__________________
Chat with acid


acid is offline   Reply With Quote Quote selected
Old Jun 24, 2004, 12:47   #3
Administrator
 
greka's Avatar
 
Join Date: Sep 2001
Location: @work
Posts: 5,347
Rep Power: 10
Reputation: 23
Send a message via ICQ to greka
miguce

mysql_query("update msg set viewer=viewer + '$word ' wherE id=1")

?

vonc-vor tar er bac toghnvac...
__________________
И повешенные могут качаться в неположенную сторону. /С.Е.Лец/
greka is offline   Reply With Quote Quote selected
Old Jun 26, 2004, 10:05   #4
Младенец
 
Join Date: Nov 2002
Location: Skofja Loka , Slovenia
Posts: 19
Rep Power: 0
Reputation: 10
vsem spasibo , ya ujhe nashol vikod !

mysql_query("update msg set viewer=concat(viewer,'$word ') where id=1")

vot eto idealnoe reshenie
x.ice is offline   Reply With Quote Quote selected
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
restrictions on INLINE statement greka Languages, Compilers and Interpreters 9 Jun 14, 2004 19:28
www.3bids.am - update DreamWaver Web sites 6 May 26, 2004 16:23


All times are GMT. The time now is 00:47.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
This board was founded on September 29, 2001
Powered by Viper Internet

Affordable Web Hosting | ParevNet

Buy text link