This is the new home of the egghelp.org community forum.
All data has been migrated (including user logins/passwords) to a new phpBB version.


For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.

text decoration problem, when getting text from a mysql db

Old posts that have not been replied to for several years.
Locked
d
diarmuid

text decoration problem, when getting text from a mysql db

Post by diarmuid »

hi all,

i'm having a little issue getting text decoration to work, here's my situation.

i'm storing text in a mysql db, im retreiving that info from the db, and storing it in a variable called $row. that's all fine and dandy... here's the problem.

this is what $row looks like:
1 op_msg {\0037this is op_msg}

this is how $row is set:
set row [lindex [mysqlsel $sqlhand "SELECT * FROM `$db(table)` WHERE id LIKE '1'" -list] 0]

when i try and output by doing: putquick "NOTICE $nick: $row" it won't show the colour that \0037 should return (orange), instead it just outputs "\0037this is op_msg"

how can i make it treat the \0037 as a colour code in my output??
User avatar
user
 
Posts: 1452
Joined: Tue Mar 18, 2003 9:58 pm
Location: Norway

Post by user »

What you want is backslash substitution. Try 'subst' :) (-nocommands -novariables)
Have you ever read "The Manual"?
d
diarmuid

Post by diarmuid »

thx alot, you're a life saver ;) :mrgreen: :mrgreen:
Locked