php/mysql: store variables in mysql

[abahaedini]

hi there I define a fixed varibale like this

define('CODE', '123');  echo "result ==> ".CODE;  

result ==> 123 it's ok...but when I store the CODE in mysql and then fetch it dosn't worki get just this result: result ==> CODEbut I want this result:result ==> 123 is there any way to do it?

[birbal]

it seems like you are using CODE constant (right word is constant not fixed variable) in string context. showing the code will be helpfull

[dmllc]

what datatype is the column where 123 is pulled from? your code has it in a string, but more than likely it is stored in mysql as an int

[php_developer]

I think you must retrive the value of CODE in some variable like: $code = CODE; and then use $code in your mysql query like:insert into table (`code`) values ('$code').. May be this will help u...