prepend data to field

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/

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!

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

less than a week? what happened, 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!

"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
news:f0qvbk$ssg$1@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.

Message-ID: <f0qnbg$ue5$1@news6.zwoll1.ov.home.nl> from 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/

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.
jstucklex@attglobal.net
==================