By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,751 Members | 1,216 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,751 IT Pros & Developers. It's quick & easy.

prepend data to field

P: n/a
I have a record in a MySql database which can be edited. Each time it
is edited I want to give the user the opportunity to summarise the
changes, which I store in a field. It doesn't really warrant another
table it would be sufficient to prepend the data to the existing data in
the field.

Sorry if this is really a MySql problem, but at the moment I can only
think of a php/html hidden field solution.
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
Apr 26 '07 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Rik
Geoff Berrow wrote:
I have a record in a MySql database which can be edited. Each time it
is edited I want to give the user the opportunity to summarise the
changes, which I store in a field. It doesn't really warrant another
table it would be sufficient to prepend the data to the existing data in
the field.

Sorry if this is really a MySql problem, but at the moment I can only
think of a php/html hidden field solution.
Why does it have to be hidden?

Maybe you're looking for something simple like:

HTML:
<textarea name="new_comments"></textarea>

SQL:
UPDATE `tablename` SET `comments` =
CONCAT('{$_POST['new_comments']}','\n',`comments`) WHERE #your clause...

HTH,
--
Rik Wasmus

Estimated date being able to walk again: 01-05-2007.
Less then a week, hurray!
Apr 26 '07 #2

P: n/a
| --
| Rik Wasmus
|
| Estimated date being able to walk again: 01-05-2007.
| Less then a week, hurray!

less than a week? what happened, rik?
Apr 26 '07 #3

P: n/a
Rik
Steve wrote:
| Estimated date being able to walk again: 01-05-2007.
| Less then a week, hurray!

less than a week? what happened, rik?
I made a brave effort to clean the raingutters on the third floor.
Unfortunately, the ladder did not agree with me, so I took about a 9
meter tumble. Both legs broken, so I'm temporarily in a wheel chair. Sad
thing was I live on the forementioned third floor, and the house did not
have any lifts...

Well, that's about 6 weeks ago, the casts come off come tuesday, and
then we'll check wether the walking is an option. Would be nice, to be
able to work with my normal dualcore AMD souped up machines again,
instead of this ancient laptop. It's got some unfixable harddisk
problems, which mean every time you save a file it's a bit of a gamble
wether it will actually be retrievable later. Oh joy :-)

--
Rik Wasmus

Estimated date being able to walk again: 01-05-2007.
Less then a week, hurray!
Apr 26 '07 #4

P: n/a

"Rik" <lu************@hotmail.comwrote in message
news:f0**********@news5.zwoll1.ov.home.nl...
| Steve wrote:
| | Estimated date being able to walk again: 01-05-2007.
| | Less then a week, hurray!
| >
| less than a week? what happened, rik?
|
| I made a brave effort to clean the raingutters on the third floor.
| Unfortunately, the ladder did not agree with me, so I took about a 9
| meter tumble. Both legs broken, so I'm temporarily in a wheel chair. Sad
| thing was I live on the forementioned third floor, and the house did not
| have any lifts...

good god! so, you heft'd yourself up to the third floor with casts in tow
and stayed up there six weeks?!

| Well, that's about 6 weeks ago, the casts come off come tuesday, and
| then we'll check wether the walking is an option. Would be nice, to be
| able to work with my normal dualcore AMD souped up machines again,
| instead of this ancient laptop. It's got some unfixable harddisk
| problems, which mean every time you save a file it's a bit of a gamble
| wether it will actually be retrievable later. Oh joy :-)

so a wap and shared drive on your home lan wasn't an option? ;^) i know what
you mean though. i'm glad work keeps giving me new ones. the last one i
bought was a 386 32mb ram with a whopping 200mb hd. i took win98 off of it
and put knopix on to see if i could use it for anything...unless i
command-lined, xwindows blew just as hard. i actually gave it away to my
neighbor two weeks ago...ne'r a tear was shed.

best wishes on a speedy and full recover.
Apr 26 '07 #5

P: n/a
Message-ID: <f0**********@news6.zwoll1.ov.home.nlfrom Rik contained
the following:
>SQL:
UPDATE `tablename` SET `comments` =
CONCAT('{$_POST['new_comments']}','\n',`comments`) WHERE #your clause...
Thanks Rik, that's what I need.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
Apr 26 '07 #6

P: n/a
Rik wrote:
Steve wrote:
>| Estimated date being able to walk again: 01-05-2007.
| Less then a week, hurray!

less than a week? what happened, rik?

I made a brave effort to clean the raingutters on the third floor.
Unfortunately, the ladder did not agree with me, so I took about a 9
meter tumble. Both legs broken, so I'm temporarily in a wheel chair. Sad
thing was I live on the forementioned third floor, and the house did not
have any lifts...

Well, that's about 6 weeks ago, the casts come off come tuesday, and
then we'll check wether the walking is an option. Would be nice, to be
able to work with my normal dualcore AMD souped up machines again,
instead of this ancient laptop. It's got some unfixable harddisk
problems, which mean every time you save a file it's a bit of a gamble
wether it will actually be retrievable later. Oh joy :-)
Wow - sorry to hear about you accident, Rik. But it sounds like you're
coming along ok.

I suspect you'll be a little wobbly for a while until you get the
strength back in your lets, but I know you'll be happy to get those
casts off!
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Apr 27 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.