visitor Posted December 19, 2012 Share Posted December 19, 2012 Hi I hope someone can help me... how can I get a line-break directly in the phpMyAdmin database in a text field. Please see the example below... LONG-TERM CAPITAL APPRECIATION COMBINED WITH CAPITAL<br />PRESERVATION.<br /><br /> AIM AT RETURNS WITH LOWER VOLATILITY THAN EQUITIES AND<br /> A LOW CORRELATION WITH EQUITY AND BOND MARKETS. I know it doesn't work with <br />. This is just to show you where I would like to have them placed directly in the text field of the table. <tr> <td class="fieldset"><div class="tbl_lbl">FUND STRATEGY</div> <div class="tbl_input"> <input size="57" name="fund_strategy" id="fund_strategy" value="<?php echo $arrayFund[0]['fund_strategy']?>"> </div></td> </tr> Thank you visitor Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/ Share on other sites More sharing options...
Pikachu2000 Posted December 19, 2012 Share Posted December 19, 2012 If you're using a form to get the value into the database, use a textarea instead of type="text" so linefeeds are preserved. Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/#findComment-1400477 Share on other sites More sharing options...
visitor Posted December 19, 2012 Author Share Posted December 19, 2012 No, the information is entered manually directly into the database table. Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/#findComment-1400491 Share on other sites More sharing options...
Jessica Posted December 19, 2012 Share Posted December 19, 2012 Hit the return key or type a <br>, depends if you want br or \r\n Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/#findComment-1400497 Share on other sites More sharing options...
visitor Posted December 20, 2012 Author Share Posted December 20, 2012 Hi Jessica No, even with <br> and/or "\r\n" it shows only the one line below... LONG-TERM CAPITAL APPRECIATION COMBINED WITH CAPITAL* *it is cut after 'capital'. The word 'preservation' is not shown as there is no space left. ...but thanks for your suggestion. I appreciate it. I would need the text to show up like this... LONG-TERM CAPITAL APPRECIATION COMBINED WITH CAPITAL<br> PRESERVATION. AIM AT RETURNS WITH LOWER VOLATILITY THAN EQUITIES AND<br> A LOW CORRELATION WITH EQUITY AND BOND MARKETS. TO MANAGE THE FUND SO THAT IT IS ABLE TO ADAPT TO CHAN-<br> GING MARKET CONDITIONS AT ALL TIMES AND ESPECIALLY TO<br> PRESERVE LIQUIDITY. TO IDENTIFY OPPORTUNITIES FOR BOTH LONG AND SHORT<br> POSITIONS WITH A VIEW TO GENERATING ALPHA FROM BOTH. TO KEEP A LOW NET EXPOSURE IN ORDER TO REDUCE EXPO-<br> SURE TO MARKET MOVEMENTS. Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/#findComment-1400528 Share on other sites More sharing options...
Jessica Posted December 20, 2012 Share Posted December 20, 2012 PhpMyAdmin will only show a certain amount unless you export it. Or your column is too small. Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/#findComment-1400535 Share on other sites More sharing options...
visitor Posted December 20, 2012 Author Share Posted December 20, 2012 So, to make it work as you suggested before, I have to do this, right? LONG-TERM CAPITAL APPRECIATION COMBINED WITH CAPITAL<br> PRESERVATION."\r\n" AIM AT RETURNS WITH LOWER VOLATILITY THAN EQUITIES AND<br> A LOW CORRELATION WITH EQUITY AND BOND MARKETS."\r\n" TO MANAGE THE FUND SO THAT IT IS ABLE TO ADAPT TO CHAN-<br> GING MARKET CONDITIONS AT ALL TIMES AND ESPECIALLY TO<br> PRESERVE LIQUIDITY."\r\n" Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/#findComment-1400538 Share on other sites More sharing options...
Pikachu2000 Posted December 20, 2012 Share Posted December 20, 2012 Why are you trying to echo it into an <input> field, anyhow? Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/#findComment-1400539 Share on other sites More sharing options...
visitor Posted December 20, 2012 Author Share Posted December 20, 2012 Because it can be done both ways... - directly in the website - in the table of the database Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/#findComment-1400540 Share on other sites More sharing options...
visitor Posted December 20, 2012 Author Share Posted December 20, 2012 How can I increase the size (height) of the 'fund strategy' field? Maybe that way this issue can be solved. Please view the attachment... about field size.doc Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/#findComment-1400541 Share on other sites More sharing options...
Jessica Posted December 20, 2012 Share Posted December 20, 2012 If you're using a form to get the value into the database, use a textarea instead of type="text" so linefeeds are preserved. Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/#findComment-1400607 Share on other sites More sharing options...
visitor Posted December 20, 2012 Author Share Posted December 20, 2012 This is an impossible task. It can't be done! I tried all that you suggested (ie. <br />, "\r\n", textarea) but it still doesn't work. Thanks for your help, anyway Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/#findComment-1400625 Share on other sites More sharing options...
visitor Posted December 20, 2012 Author Share Posted December 20, 2012 I made it...! It works, I can't believe it! It was a struggle but the result is great! Thank you for your suggestions Quote Link to comment https://forums.phpfreaks.com/topic/272185-phpmyadmin/#findComment-1400634 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.