MySQL Syntax Needed

vortex

Hi I'll try and make this short and simple

I am trying to update the contents of a field, I want to leave the contents that already exists in the field and add the additional data via a simple submit
form e.g.

"name A" already exists in the field.

form is submitted and the field was filled out as "name B".

so the data I want in the field is as follows "name A, name B".

Any idea how/if this can be done ? all sugestions are welcome, I think its something like an "ALTER" or "ADD" command but I really am not too sure.

Thanx

brandonschnell

depends on if you know the id of the record to modify. use the sql UPDATE command like so:

UPDATE table set name = 'B' where id = $id;

vortex

Doesnt the UPDATE command add info to a field but replace what was there before it , there fore erasing the previous data ?

or have I just made myself look like a complete ass ?

Thanx 🙂

brandonschnell

1) update only modifies the specified columns. if a column isn't specified or the value hasn't changed then nothing is modified.

http://www.mysql.com/doc/U/P/UPDATE.html

2) nope.

vortex

Ok cheers for the help m8 🙂

Anon

www.sqlcourse.com

Since you want to keep the current column contents but add a little info on it, you may need to use a select query to get the data from that field.

If you stick it in $keep then:

$update_value = $keep . ", " .$newvalue;

The query will look like:

update table_name set col_name='$update_value' where $condition

It may add an extra query, however it does work. If it can be done using only one query, I don't know how 😉