PHP-MYSQL question

[dadms]

I am trying to append to a field in a mysql database.

For example in field NOTES- I may have-
THIS IS A TEST

I then want to be able to add/append/update????-
TEST IS OVER

And in the DATABASE it would show-
THIS IS A TEST
TEST IS OVER

I currently use

$sql = "UPDATE logins SET notes='$notes' WHERE id='$id'";

but this replaces what I have in field already. Any suggestions?

Thanks

 

[predamarcel]

Probable you want:

$sql = "UPDATE logins SET notes=CONCAT(notes, '$notes') WHERE id='$id'";



___

http://marcel.4x4.ro/

____

 

[sleipnir214]

A query of the form

update foo set notes = concat(notes, ' bar') where pkid = 1;

will append to the field notes.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[DanLW]

Not sure of the exact syntax. Along the lines of:

Connect to database...
Extract current value of the 'notes' field
$sql = "SELECT notes FROM logins WHERE id='$id'";
$query_result = // result from query

append query result to $notes
$notes = $query_result . $notes

$notes should now read "THIS IS A TEST TEST IS OVER"

Update database using:
$sql = "UPDATE logins SET notes='$notes' WHERE id='$id'";

 

[dadms]

Thanks for all the suggestions. I took the easy route and went with:

$sql = "UPDATE logins SET notes=CONCAT(notes, '$notes') WHERE id='$id'";