[tommyc325]

i was wondering if this is possible.........

i want to be able for a user to fill out a form and when he submits it instead of adding, updating a record i want it to add to a record i already have into the db.

Example:

db record: Hello how are you.

Adding into db record: Hello how are you., Im good thanks.


Please help.

[nova912]

look up UPDATE syntax in MySQL.

[odi]

when you want to update a record you need to identify it, ether by text or an ID.

If you want to do something like a reply (from your example) you can easily add a new record but define that the new record is a reply (this is done with a relation, if you need more information, ask).

If you want a concrete example it would be useful to give us more information about your table structure and the problem you're trying to solve

[tommyc325]

yea the relation seems like what i want

[mab]

If you literally want to concatenate additional information onto a record in an UPDATE, take a look at the mysql CONCAT and CONCAT_WS functions.

[odi]

if you want a relation for let's say a forum, you have a parent record (i.e. the first post in a thread).
All of the following records are childs. In the most basic way I can think of you need 3 collums:

-ID
-text
-parent-ID

now, for the first record you add the ID in the parent-id field as well (you can use the insert_id() function to gather the id of the just inserted record).

If a user posts a reply, you need to know on which ID he is replying (can be done using a hidden input-field):

Code:

<input type="hidden" name="parent" value="3" />

you must add something like that to your form, don't forget to set the correct value (instead of "3" you must enter the actual ID).

Then, you enter a new record and set the parent ID.

At the end you can do something like:

Code:

select text from my_table where parent='3'

to show all posts to a certain thread.

your db-records would look like that:

Code:

mysql> select * from my_table;
+----+----------------------------------+--------+
| id | text                             | parent |
+----+----------------------------------+--------+
|  1 | hello there                      |      1 |
|  2 | nice to see you                  |      1 |
|  3 | yeah, really nice                |      1 |
|  4 | I start a new thread             |      4 |
|  5 | I answer you                     |      4 |
|  6 | i ansert the first thread again! |      1 |
+----+----------------------------------+--------+

I hope that was somehow understandable...

[Nico]

Topic moved to database.

[tommyc325]

THank you very much everyone.