visitor

Thank you for this info Mr. Barand. If there is no RSS stream available, what other options are there? Do you know...?

Hi I would like to get automatic updates in db (i.e. prices and dates) of certain funds. This data ain't publicly available. So, instead of getting this data on a piece of paper by the provider and applying it manually into the db, I want to know if there is a better way on how to do this. Is it possible to get the data by RSS Stream directly (automatically) into certain fields of the database? Thank you visitor

So, I finally thought I have found some code to expand the textarea dynamically. But no... anyway, here's the javascript code to this textarea. If someone has got a code that works, please let me know. Thanks <tr> <td class="fieldset"> <div class="tbl_lbl">FUND STRATEGY</div> <div class="tbl_input"> <textarea id="fund_strategy" onkeyup="new do_resize(this);" cols="43" rows="1" name="fund_strategy"> <?php echo $arrayFund[0]['fund_strategy']?></textarea> </textarea> </div> </td> </tr> function do_resize(textbox) { var maxrows=5; var txt=textbox.value; var cols=textbox.cols; var arraytxt=textbox.split('\n'); var rows=arraytxt.length; for (i=0;imaxrows) textbox.rows=maxrows; else textbox.rows=rows; }

Thanks for the link... I am getting there slowly

Yes, I know... I am working on it, though. But still, even when I try to increase the textarea, it stays the same. I tried this <textarea width="300px" name="fund_strategy" id="fund_strategy"> and how can I get the text from database inside this textarea field?

Hi Data is entered directly into the database (phpMyAdmin). When this data then is then looked up on the website, it shows only a part of the first line as the table is too small. The textarea must be dynamic as texts vary in size. Does anyone have a good idea how this problem can be solved best? Dok2.doc <tr> <td input type="textarea" 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']?></textarea> </div></td> </tr> Thank you

I made it...! It works, I can't believe it! It was a struggle but the result is great! Thank you for your suggestions

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

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

Because it can be done both ways... - directly in the website - in the table of the database

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"

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.

No, the information is entered manually directly into the database table.

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

OK, thanks... I'll check with AJAX, then

Hi Is there a possibility in phpMyAdmin to enter information (i.e. name) into one field and get related data (i.e. address, birthday etc.) in eight other fields? If yes, could anyone explain how this can be done, please? Thanks visitor

OK, great! Thanks to both of you and especially for your description Pikachu2000. I really appreciate it visitor

No, of course not... the primary key is 1, but I would like in cust-id to show up i.e. xx.000'000 for the first customer, xx.000'001 for the next etc.

Hi I would like to have an ID entered in this format xx.000'000 what kind of type is probably best suited (INT, TEXT, VARCHAR?) any help is highly appreciated visitor

OK, great! Thanks to both of you and especially for your description spiderwell. I really appreciate it visitor

Hi I would like to add a 'welcome message' (Hello John Doe, etc.) after successful login. Can this be done best in php? Cheers, visitor

Great! Thank you very much cssfreakie, I really appreciate your help! visitor

Hi there I would like to label a button but so far I failed terribly. I tried the following... <table border="0" cellspacing="0" cellpadding="0"> <tr> <td style="background-image(url:round_corner.gif)" width="116px" height="21px" align="center"><b>Home</b></td> </tr> </table> <input type="image" src="round_corner.gif" width="116px" height="21px" value="Home" onclick='return verify();'/> Has anyone got an idea how this can be done properly? cheers, visitor [attachment deleted by admin]

Hi Guys I would like to have the error message (mandatory fields * are...) to show up only if one of those mandatory fields isn't filled out. Have you got an idea what's wrong with this script? Any help would be highly appreciated. Cheers, visitor <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="de-ch" lang="de-ch"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="Stylesheet" href="styles.css" /> </head> <body> <div id="main_cont"> <div id="title"> <img src="ZEIT8.jpg" alt="" /></div> <div id="content"> <?php> <span id="error">MANDATORY FIELDS * ARE: ISIN, CURRENCY, CUSTODY A/C, QUANTITY, T/D, V/D, SELLER, CUSTODIAN</span><br /><br /><script> function SetValues(id,number) { var Ids = new Array(); var Currency = new Array(); var Names = new Array(); Ids[1] = "1";Currency[1] = "USD";Names[1] = "FIDELITY ASIAN";Ids[2] = "2";Currency[2] = "GBP";Names[2] = "LEO SMALL PEARL";Ids[3] = "3";Currency[3] = "EUR";Names[3] = "VONTOBEL CLASSIC";Ids[4] = "4";Currency[4] = "JPY";Names[4] = "HSBC TECHNOLOGY";Ids[41] = "5";Currency[5] = "JPY";Names[5] = "OPPENHEIM EASTERN EUROPE";if(Ids[id]) if(number=='0'){ document.getElementById('Currency').value = Currency[id]; document.getElementById('Name').value = Names[id]; } if(id==0) if(number=='0'){ document.getElementById('Currency').value = 'Select ISIN'; document.getElementById('Name').value = 'Select ISIN'; } } function verify() { var message = ''; if(document.getElementById('Quantity').value) if(!(document.getElementById('Quantity').value == parseInt(document.getElementById('Quantity').value))) message = message + 'QUANTITY MUST BE NUMERIC!'; reZip = new RegExp(/(^\d{4}-\d{2}-\d{2}$)|(^$)/); if(!reZip.test(document.getElementById('Trade_Date').value)) message = message + '\nTRADE DATE FORMAT MUST BE YYYY-MM-DD !'; if(!reZip.test(document.getElementById('Settlement_Date').value)) message = message + '\nSETTLEMENT DATE FORMAT MUST BE YYYY-MM-DD !'; if(!message) document.createT.submit(); else { alert(message); return false;} } function switc(val) { document.getElementById('xxx').style.visibility = (val == 'switch') ? 'visible' : 'hidden'; if(val!='switch') document.getElementById('amount2').value='0'; return false; } </script> <form name="createT" method="post" action=""> <input type='hidden' name='type' value='purchase'/> <div> <fieldset> <legend>FUND DETAILS</legend> <table border=0> <tr> <td align="right"><span style='color:#FF0000'>ISIN*</span></td> <td> <select name='security1' onchange='SetValues(this.value,"0")'> <option value='0'> selection</option> <option value='1'>LU.000'000'000'0</option> <option value='2'>CH.111'111'111'1</option> <option value='3'>DE.222'222'222'2</option> <option value='4'>US.333'333'333'3</option> <option value='5'>KY.444'444'444'4</option> </select> </td> <td align="right"><span style='color:#FF0000'>CURRENCY*</span></td> <td><select name="currency" id="currency" class="dropdown"> <option value="">selection</option> <option value="1">USD</option> <option value='2'>EUR</option> <option value='3'>GBP</option> <option value='4'>JPY</option> <option value='5'>CHF</option> </select> </td> </tr> <tr> <td colspan="4"> <div class='notification'>IF ISIN IS NOT IN THE DATABASE, JUST ADD IT IN THE "REMARKS" FIELD</div> </td> </tr> <tr> <td align="right">FUND NAME</td> <td colspan="3"> <input class="norm" type="text" size="61" name="Name" id="Name" /></div> </td> </tr> <tr> <td align="right"><span style='color:#FF0000'>QUANTITY*</span></td> <td> <input class="norm" type="text" name="Quantity" id="Quantity" /></div> </td> <td><span style='color:#FF0000'>CUSTODY A/C*</span></td> <td><select name="client" id="client" class="dropdown"> <option value=""> selection</option> <option value="1">S1 (REG.)</option> <option value='2'>S2 (RESTR.)</option> <option value='3'>S3 (U.S.)</option> </select> </td> </tr> <tr> <td align="right"><span style='color:#FF0000'>TRADE DATE*</span></td> <td> <input class="norm" type="text" name="Trade_Date" id="Trade_Date" /></div> </td> <td align="right"><span style='color:#FF0000'>VALUE DATE*</span></td> <td> <input class="norm" type="text" name="Settlement_Date" id="Settlement_Date" /></div> </td> </table> </fieldset> </div> <br /> <div> <fieldset> <legend>SELLER DETAILS</legend> <table> <tr> <td align="right"><span style='color:#FF0000'>SELLER*</span></td> <td colspan="4"> <input class="norm" type="text" size="58" name="Partner" id="Partner" /></div> </td> </tr> <tr> <td align="right">BIC (SELLER)</td> <td> <input class="norm" type="text" name="BIC_Partner" id="BIC_Partner" /></div> </td> <td width="220px" align="right"> </td> </tr> <tr> <td align="right"><span style='color:#FF0000'>CUSTODIAN*</span></td> <td colspan="4"> <input class="norm" type="text" size="58" name="Custodian" id="Custodian" /></div> </td> </tr> <tr> <td align="right">BIC (CUSTODIAN)</td> <td> <input class="norm" type="text" name="Custodian_BIC" id="Custodian_BIC" /></div> </td> </tr> <tr> <td align="right">CLIENT A/C WITH CUST.</td> <td><input class="norm" type="text" name="client_ac_cust" id="client_ac_cust" value=""/></td> </tr> <tr> <td align="right">TRANSFER AGENT</td> <td colspan="4"> <input class="norm" type="text" size="58" name="TA_Name" id="TA_Name" /></div></td> </tr> <tr> <td align="right">BIC (TA)</td> <td><input class="norm" type="text" name="TA_BIC" id="TA_BIC" /></div></td> </tr> <tr> <td align="right">CUSTODIAN A/C WITH T/A</td> <td><input class="norm" type="text" name="cust_ac_ta" id="cust_ac_ta" value=""/></td> </tr> <tr> <td align="right">REMARKS</td> <td colspan="4"> <input class="norm" type="text" size="58" name="comment" id="comment" /></div></td> </tr> </table> </fieldset> </div> <br /> <div> <fieldset> <input style="float:center;" type="submit" value="GET FUND" name="button" onclick='return verify();'/> </fieldset> </div> <br /> <div> <fieldset> <legend>IMPORTANT</legend> <center>FIELDS MARKED WITH AN ASTERISK * ARE MANDATORY<br /> </fieldset> </div> <br /> <div> <fieldset> <legend>ORDER SUBMITTED</legend> <table> <tr> <td align="right">DATE</td> <td><input class="norm" type="text" name="date" id="date" value=""/></td> <td align="right">TIME</td> <td><input class="norm" type="text" name="time" id="time" /></td> </tr> </table> </fieldset> </div> </form> </div> ?> <body> </html>

Great! Thank you so much for this script... cheers, ozzo