Forum Moderators: coopster

Message Too Old, No Replies

Inserting a row of characters in text field automatically

         

Shaman13

3:08 pm on Jun 16, 2005 (gmt 0)

10+ Year Member



Good Day to All! Hoping someone can help with this simple problem. I am inserting text into a text field. Because there may be a number of entries made sequentially I want to automatically insert a line of characters such as ****** or ------------- automatically between rows to make the output more legible. Here is what I have so far. I want to insert the line after SUMMARY='***{$_SESSION['date']}-{$_SESSION['valid_user']}/{$_SESSION['SNUM']}\n{$_POST['SUMMARY']}
I want the line of characters to occur after {$_POST['SUMMARY']}
Here is the full code.
As always all suggestions are really appreciated!
Have a Great Day!
---------------------------------------
mysql_query("UPDATE _clientsw_cases SET CLNAME='{$_POST['CLNAME']}',CFNAME='{$_POST['CFNAME']}',
PCODE='{$_POST['PCODE']}',HANDICAPPED='{$_POST['HANDICAPPED']}',CPHONE='{$_POST['CPHONE']}',PHONEREF='{$_POST['PHONEREF']}',
SUMMARY='***{$_SESSION['date']}-{$_SESSION['valid_user']}/{$_SESSION['SNUM']}\n{$_POST['SUMMARY']}',GOODSTORY='{$_POST['GOODSTORY']}',PACKET='{$_POST['PACKET']}',
SPROGRAM='{$_POST['SPROGRAM']}',TRANSFER='{$_POST['TRANSFER']}',COCOUNSEL='{$_POST['COCOUNSEL']}',
CLINICNUM='{$_POST['CLINICNUM']}',PHELPED='{$_POST['PHELPED']}',PRIORITY='{$_POST['PRIORITY']}',
COPEN='{$_POST['COPEN']}',MAJOR='{$_POST['MAJOR']}',IMPACT='{$_POST['IMPACT']}',CLASSACT='{$_POST['CLASSACT']}',
SPCODE1='{$_POST['SPCODE1']}',SPCODE2='{$_POST['SPCODE2']}',SPCODE3='{$_POST['SPCODE3']}',SNUM='{$_POST['SNUM']}',
OFFICENUM='{$_POST['OFFICENUM']}',FUNDSNUM='{$_POST['FUNDSNUM']}',OCOUNSEL='{$_POST['OCOUNSEL']}',
FORUM='{$_POST['FORUM']}',SPECPCODE='{$_POST['SPECPCODE']}',CPHONE1='{$_POST['CPHONE1']}',PHONEREF1='{$_POST['PHONEREF1']}',
CPHONE2='{$_POST['CPHONE2']}',PHONEREF2='{$_POST['PHONEREF2']}' WHERE CASENUM='{$_POST['CASENUM']}'");
$message = '<font color="#FF0000"size="4"> Case Successfully Edited</font>';

coopersita

4:12 pm on Jun 16, 2005 (gmt 0)

10+ Year Member



You want to include the line of ***** into your database as part of the update? or just show that when you are doing a select and outputting (x)html?

Shaman13

4:21 pm on Jun 16, 2005 (gmt 0)

10+ Year Member



I want to insert a line of ************* into the database. Thanks

coopersita

6:35 pm on Jun 16, 2005 (gmt 0)

10+ Year Member



How about insterting an <hr> or <hr /> a the end of your summary? That way when you pull it out of the database it will add a horizontal line at the end of the record.

I may be misunderstanding you question, though...

SUMMARY='***{$_SESSION['date']}-{$_SESSION['valid_user']}/{$_SESSION['SNUM']}\n{$_POST['SUMMARY']}<hr>',GOODSTORY='{$_POST['GOODSTORY']}',PACKET='{$_POST['PACKET']}',