PHP Implode array elements
If you are having 1 dimension array and you would like to use this type of array in you mysql query
you can use the PHP implode function.
--------------------------------
Example Array
--------------------------------
echo "<pre>";
print_r($yearSearch);Array
(
[0] =1979
[1] =1980
[2] =1981
[3] =1982
[4] =1983
[5] =1984
[6] =1985
[7] =1986
[8] =1987
Linux db2cc cannot open display
If you are having problem as mention below, you may try this.
—————————————————
Problem Scenario db2cc
—————————————————
db2inst1@ubuntu:/home/xyiry$ export DISPLAY=:0.0
db2inst1@ubuntu:/home/xyiry$ db2cc
No protocol specified
Error : Can not open display
db2inst1@ubuntu:/home/xyiry$
—————————————————
Problem Solving db2cc
—————————————————
Type in this command in terminal.
db2inst1@ubuntu:/home/xyiry$ xhost +
db2inst1@ubuntu:/home/xyiry$ su db2inst1
db2inst1@ubuntu:/home/xyiry$ export DISPLAY=:0.0
db2inst1@ubuntu:/home/xyiry$ db2cc
Hope it works…