HTML - Database Text Losing Formating
Greeings all. First time poster, hopefully this forum is a good starting point for this question.
I am using a PHP script to upload some text to a MySQL database-field type is varchar. When the text is retrieved, it is displayed to the right of a embedded html video player. Retrieving the text and video, I also use a PHP script. But then I switch to "html mode" to display the video and text. In "html mode" I use a single row, 2 column table to display the video and text. What is happening is that the text is losing its line breaks. That is it is coming out as one long string of text. Since the text can be up to 1000 characters, that is one long string of text to no have any line breaks! Maybe it is something with the way MySQL stores the data. But if anyone has any thoughts on how to preserve the line breaks, I sure would appreciate it. Thanks. ~Robert Similar TutorialsHello Everyone, I know it's been forever since I made a post, but I ran into something I can't figure out on my own and I am hoping that someone here might be able to give me a hand. I recently spoke with a potential client that wants to copy a feature on another website: http://batchgeo.com/ as you can see, on batchgeo.com the end user can paste data from excel into the textarea field, then when the user clicks out of the textarea, it formats the data to look like it is in a table. Does anyone know how they are doing this? Thanks in advance for any help. -A Is there a CSS command hello ! I have a text fields and i want to display there a record of my database. the problem is that my sql record is not plain text,but has html formating. So when i display the data to the text field, it changes the appearance of my web page!! i have to find a way to display that html text as plain text and not as html code! can anybody help me please? thanks!! Hello, I am designing a new layout for my myspace using an overlay. What this means is I had to put all the links back in, and put in everythign by hand because I was more or less bypassing myspace's built in tools. The only problem I have is that now I have my code put in place and it displays everything fine except that it is all shifted to one side just a little bit so I have this ugly white bar that runs up the left side because all the code is shifted just a little bit to the right, and some of the original page is showing under the overlay. I do not know if this means I need to shift the overlay to the left or the code that I put in for my layout. Either way I coudl use some help in figuring this out Also, right now I have the background color set on the whole page as black. When I take out the style code that does that it shows white on the edges and shows how the content is shifted. Here is a link to the myspace page I am using to test the code http://profile.myspace.com/index.cfm...3-ee1f6161935a And attached is my code I am needing to place my paragraph alongside my title.. I am using the following code..
Code: <div align="justify"><strong><font color="#306">TopicHere</font></strong><br />TextHere</div> The above is not giving me what I need, What I need is shown here .. What I need is here Thank You for your help David I have a table with images and the table is well formated but after the table ends the contents are displayed beside it . The contents should display below the table... why is this?? What should i do to bring the contents below table?? Thanks hi ppl I'm formatting a table and i need some pro help. http://doyouwantfreecash.blogspot.com opening it in firefox2 everything looks aligned, but opening it in ie6 it gets messed up.. HTML Code: <p align="center"> <table align="center" background="http://img413.imageshack.us/img413/6695/tablebgpa5.png" border="1" cellpadding="0" cellspacing="0" width="809"><tbody><tr valign="bottom"><td height="72">re-building</td></tr><tr><td height="25"> </td></tr><tr><td height="60"><table align="center" border="1" cellpadding="0" cellspacing="0" width="750"><tbody><tr><td> <span style="font-family:tahoma;font-size:78%;">Get Paid To</span></td><td> <span style="font-family:tahoma;font-size:78%;">Get Paid To View Ads</span></td><td> <span style="font-family:tahoma;font-size:78%;">Get Paid To Read Emails</span></td><td> <span style="font-family:tahoma;font-size:78%;">Get Paid To Play Games</span></td></tr><tr><td><form name="gpt"><select name="gpt" onchange="textValueGpt()" style="font-size: 12px; color: rgb(0, 0, 0); font-family: verdana; background-color: rgb(255, 255, 255);"><option>- Select -</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=1" id="Great for it's 1c, 0.5c emails and Sign Ups.">DonkeyMails</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=2" id="Lots of 2c, 1c and 0.5c emails everyday! Paid To Sign Up, Paid To Promote and much more. Great website!">H.AdvertiserPro</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=3" id="Great for advertising, with a allot of 0.5c, 1c emails and point emails everyday.">YouRoMail</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=4" id="Lots of daily paid emails worth 0.5c and offer emails worth up to 50c per offer! $3 payout.">Gain Mail</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=5" id="Very good PTC section, with a few 2c, 1c and 0.5c emails per week.">MinuteGold</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=6" id="A few daily emails worth 0.2c and 0.5c, and offer emails worth up to 50c each!">ECashClicks</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=7" id="A few daily emails worth 0.5c and 1c.">AdSentive</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=8" id="A few regular emails everyday.">GetPaidMail</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=9" id="Great Sign-Up section, and weekly emails worth up to 2c.">BGPayMail</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=10" id="Very good promoting section, good paid daily emails and more. * Portuguese">Sr. Clique*</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=11" id="Daily emails worth up to 3c, everyday! And much more. * Portuguese">PubliPT*</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=36" id="Lots of daily emails; 0.5c up to 2c.">CrocCash</option></select><input name="testbutton" value="Visit" onclick="window.open(document.gpt.gpt.options[document.gpt.gpt.selectedIndex].value)" type="button"> </form></td><td><form name="ptc"><select name="ptc" onchange="textValuePtc()" style="font-size: 12px; color: rgb(0, 0, 0); font-family: verdana; background-color: rgb(255, 255, 255);"><option>- Select -</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=12" id="Solid website that has been around for along time, with lots of new 1c and 2c ads everyday.">Clixsense</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=13" id="Solid, great website, with allot of 1 cent ads everyday!">WordLinx</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=15" id="Loads of 0.3c ads everyday!">LinkGrand</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=16" id="Currently having some problems with payments.">M.F.M.O.</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=17" id="Top website, with allot of new ads everyday, from 0.15c to 1c per ads.">AdBux</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=18" id="A bunch of 1c and 0.5c ads along the week.">ClixMedia</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=19" id="Allot of 0.3c, 0.5c ads everyday.">DreamClix</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=20" id="Solid website with a few new 0.15c and 1c ads everyday.">AdverCash</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=21" id="Solid website with a few new 0.15c and 1c ads everyday.">TitanClicks</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=22" id="Honest website with a few new 0.5c and 0.15c ads everyday.">AdBuddy</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=23" id="Lots of 0.5c ads. Earn 30% off referrals' earnings. Honest webmaster.">SuzieQLinks</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=24" id="Lots of 0.25c ads everyday. Earn 100% from referral activities.">ADfez</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=25" id="Lots of 1c, 0.75c, 0.50c and 0.25c ads everyday! Great website.">MomsFavClicks</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=26" id="A few 0.3c ads, 0.15c per referral clicks. Long time maintained website. ">PayClicks</option></select><input name="testbutton" value="Visit" onclick="window.open(document.ptc.ptc.options[document.ptc.ptc.selectedIndex].value);" type="button"></form></td><td><form name="ptr"><select name="ptr" onchange="textValuePtr()" style="font-size: 12px; color: rgb(0, 0, 0); font-family: verdana; background-color: rgb(255, 255, 255);"><option>- Select -</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=27" id="A bunch of 0.5c, 0.8c and 1c emails everyday. $1 payout.">APairOf</option></select><input name="testbutton" value="Visit" onclick="window.open(document.ptr.ptr.options[document.ptr.ptr.selectedIndex].value);" type="button"></form></td><td><form name="games"><select name="games" onchange="textValueGames()" style="font-size: 12px; color: rgb(0, 0, 0); font-family: verdana; background-color: rgb(255, 255, 255);"><option>- Select -</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=28" id="Compete against an opponent, on a 'double your bet' basis. Make it to the final level and earn millions!">Moola</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=29" id="Great website with a few fun simple games, rewarded with very good prizes!">Prizee</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=30" id="Play for money prizes.">PimpsLord</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=31" id="Compete in a wide range of simple games, for huge money prizes, everyday!">WorldWinner</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=32" id="Explore the surface of Mars, gather Martian dollars, and trade them in for real cash!">Exodus3000</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=33" id="Make war with other players, and fight for money!">WealthWars</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=34" id="Win big money playing these awesome games.">BigPoint</option><option value="http://ricmar21.100webspace.net/ccount/click.php?id=35" id="Pick a number. Roll the roulette. Win!">Net Winner</option></select><input name="testbutton" value="Visit" onclick="window.open(document.games.games.options[document.games.games.selectedIndex].value);" type="button"></form></td></tr></tbody></table></td></tr><tr><td height="15"> </td></tr><tr><td height="25"><table border="1" cellpadding="0" cellspacing="0" width="809"><tbody><tr><td width="15"> </td><td width="494"><form name="textBoxForm"><input name="testtext" value="" size="105" maxlength="105" style="border: 0pt none ; background-color: rgb(204, 204, 204); font-family: tahoma; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;" type="text"></form></td><td width="300"> </td></tr></tbody></table></td></tr><tr><td height="21"> </td></tr><tr><td height="25"><table border="1" cellpadding="0" cellspacing="0" width="809"><tbody><tr><td width="15"> </td><td align="left"><span style="font-family:verdana, arial;font-size:78%;"><a href="http://doyouwantfreecash.blogspot.com/2007/09/new-high-rewarding-sites.html" title="Browse through a selection of new, high paying, link hoarding PTC websites">:: new ptc websites ::</a></span></td></tr></tbody></table></td></tr><tr><td height="187"> </td></tr></tbody></table></p> any idea what the "bug" might be? thanks ric hello everyone! I'm trying to edit a notification email for my blog and have most of it completed; however the only problem I'm having is that there is a gap between the menu-bg-2.png and the top of the table which I cannot get rid of. I'd like the table to be butted-up against menu-bg-2.png. When testing the html in firefox, it seems fine, but within an email the gap appears. Can anyone help? (FYI, I have no prior HTML experience or education...) Code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <style type="text/css"> <!-- .style1 {font-family: "Trebuchet MS"} a:active { outline: none; text-decoration: none; } :focus { -moz-outline-style: none; } .header { position: relative; left: 0px; } .navigation { position: relative; top: 10px; left: 0px; } .footer { position: relative; left: 0px; top: -2px; height: 31px; } .footer2 { position: relative; left: 0px; top: 40px; } body { width: 960px; } a:link { text-decoration: none; } a:visited { text-decoration: none; } a:hover { text-decoration: none; } --> </style> </head> <body> <div class="header"> <a href="http://www.photocs.net/" title="Photo CS, L.L.C." target="_blank"> <img src="http://www.photocs.net/blog/wp-content/uploads/2011/05/logo3.png"></a> </div> <div class="navigation"> <a href="http://www.photocs.net/" title="Photo CS, L.L.C." target="_blank"> <img src="http://www.photocs.net/blog/wp-content/themes/DeepFocus/images/menu-bg-2.png"></a> </div> <table frame="void" width="960px" border="0" cellpadding="20px" cellspacing="0px" valign="top"> <tr> <td bgcolor="333333"><font color="#CCCCCC" face="Verdana, Arial, Helvetica, sans-serif">Hello my photo fans!<br /><br />I've just published a new blog post that you'll be interested in checking out; click <a href="@@permalink" target="_blank">here</a> to go straight to the images.<br /><br />You subscribed to these email notices regarding new posts to my photoblog. If you want to change your settings or unsubscribe, please do it <a href="@@conf_url" target="_blank">here</a>.<br /><br />I hope you enjoy my new images, and, until next time!<br /></font></td> </tr> <tr> <td class="none" style="cursor:pointer" onclick="window.location.href='http://www.photocs.net/info/about/'" background="http://www.photocs.net/blog/wp-content/plugins/post-notification/en_US/signature.png" bgcolor="#333333" width="960px" height="60px"></td> </tr> </table> <div class="footer"> <img src="http://www.photocs.net/blog/wp-content/themes/DeepFocus/images/featured-bottom-shadow.png" width="960" height="31" /> </div> <div class="footer2"> <a href="https://www.facebook.com/pages/Constantino-Schillebeeckx-Photography/121881317862617" title="Index" target="_blank"> <img src="http://www.photocs.net/blog/wp-content/uploads/2011/04/facebook-150x150.png"></a> <a href="https://twitter.com/#!/photo_cs" title="Index" target="_blank"> <img src="http://www.photocs.net/blog/wp-content/uploads/2011/04/twitter-150x150.png" hspace="50"></a> <a href="http://feeds.feedburner.com/StLouisFreelancePhoto" title="Index" target="_blank"> <img src="http://www.photocs.net/blog/wp-content/uploads/2011/04/rss-150x150.png"></a> </div> </body> </html> So I haven't done a site in some time, but I still got the very basic basics memorized. To guide me through my born-again virginity I tried a pre-built free web site. Everything was working great. I'd preview through Dreamweaver and the very basic site looked just fine. I now upload the site to the world wide web and parts of the HTML/CSS are not translating properly (in fact there are parts missing that should be there???). The first problem occurs in the section of the CSS called "PAGE". "Page" has a repeater called "img04" and "Page .bgtop" non-repeater called "img03_blue". "page . bgtop - img_03..." doesn't show up - but in preview it did. Any ideas on what's going on? Second, in the area tagged "MENU A" in the CSS the static background image called "img07_blue" doesn't show - again, in the preview it did, now nothing on the web. I assume its a similar issue to issue 1, but I don't know? This is for a web site my wife needs so any help would be greatly appreciated. I have attached the site for reference. Thanks, J Worked Out Hello I am creating a table of contents using the <p> tag for each title. Each title is clickable and takes you to a section of the website relative to the title clicked. My problem is that I want everything to line up nicely and this is problematic using the <p> tag - for example: ARTICLE 1 - BLAH BLAH BLAH BLAH ARTICLE 10 - BLAH BLAH BLAH BLAH I want to look like this. (Actually scratch that this forum suffers the same problem I get when trying it on my own site, but you can comprehend what I'm talking about =] ). I realize there are cheap fixes such as just adding a bunch of spaces and what not but it still doesn't work. I could explain why but just trust me it doesn't work. My idea was to just use a table with 2 columns: 1 column = ARTICLE # - 2 column = BLAH BLAH BLAH however I can't extend a clickable title across 2 columns. Also I should note that I'm using DRUPAL. Thanks for your time. Guys, Please help me. Following website www.blaizekitchens.co.uk Looks fine in Mozilla But goes horribly wrong in iexplorer Can't work out what the hell is causing this! Can someone please point me in the right direction Cheers Damon Hi, I am having a problem with the formating of a search box inside a table. All I want is for the text field and submit button to sit exactly in the middle (vertically aligned) inside the table with an equal space above and below (table background is dark colour so very noticeable) In Dreamweaver, it looks fine until published - then there is a large gap below the text field and submit button but small space above. I basically am trying to get the space below the same as the one above. Take a look at the code to see what I mean. <style type="text/css"> <!-- .style2 { font-family: Arial, Helvetica, sans-serif; font-weight: bold; color: #FFFFFF; font-size: 12px; } --> </style> <table width="540" border="0"> <tr> <td width="534" height="26" bgcolor="#666666"><form action="http://www.soundscalpel.com/search.php" method="get" name="form1" target="_blank" id="form1"> <label for="textfield"></label> <div align="right"> <span class="style2">Search for Sound Effects </span> <input type="text" name="q" id="q" /> <input type="submit" value="Submit" /> </div> </form> </td> </tr> </table> Hope someone can help Thanks Hi All, I am new to this forum and is expecting an answer for this question. I have implemented a facebook type search to the database which displays the familiar text saved in the database when I type some text in the database. My issue is after I have used the search box for a couple of time the text box starts displaying a similar dropdown from its history which hides my database search. Does anyone know how to disable it using html or css. See the attached Image if my question is not clear. http://www.htmlforums.com/attachment...1&d=1306715905 I have several websites that I maintain and update. A lot of them are just textual changes and I would think my customers can do these themselves by editing a simple .txt file. I was hoping my choices are avalable so that I can just insert this tag into my web pages and then give them login info to their edit page or show them how to upload the .txt file. I hope this is an easy one with several answers. Is it possible these tags could discipline your rankings in the search engines? Thanks, Jason here is the (ineffective) code currently: <img style="float: left; width: 169px; height: 73px;" src="img/logo1.png" alt="" /> <h1 style="text-align: center;">random text</h1> the image shifts the left margin such that the text is centered as though the page width was 169px less than it really is. i'm not debating the code itself; the code above behaves as its meant to. aka no surprises. i just cant figure out the appropriate code to center the text across the entire real width of the page as though there was no image. i've tried div tags & all the things google hunting advised. no luck. other than finding this forum, which seems like it'll be a boon! thanx in advance for advise/comments/feedback/help. i have a lot of text files(2-400) all have quite alot of text inside them so is there some software that can help me convert it all into html pages?? somthing that i am doing right now is: copied all of my text files pasted them into other location and editing each file and giving extention html/htm. now can u tell somthing better?? all the files will open in same frame(obviously one at a time), all have styling n everything same. Hi Can any one help. I have this form the user is ask to input a message and a number. I want to be able to add a line of text to the message, which the user can not delete. But is sent joined to the message. ie User input Message = "Hi Just would like to share this site with you" with added text: Message "Hi Just would like to share this site with you" + "mydomain.com" Can anyone help? =========================================== Here is my form so far <script language="javascript" type="text/javascript"> function limitText(limitField, limitCount, limitNum) { if (limitField.value.length > limitNum) { limitField.value = limitField.value.substring(0, limitNum); } else { limitCount.value = limitNum - limitField.value.length; } } </script> <html> <body> <form action="stext.php" method="POST" name="number" id="number" style="width: 384; height: 372; "> <input name="number" type="text" id="number" style="position: absolute; left: 123; top: 287; color: #FFFFFF; width: 154px; border: 1px solid #ACC61B; background-color: #000000" size="20" tabindex="2"><p style="margin-top: 0; margin-bottom: 0"> <textarea name="message" cols="17" rows="1" id="message" onKeyDown="limitText(message,countdown,140);" onKeyUp="limitText(message,countdown,140);" style="position: absolute; left: 120; top: 105; width: 162px; height: 154px; color: #FFFFFF; font-family: Agency FB; font-size: 14pt; border: 1px solid #ACC61B; background-color: #000000" tabindex="1"></textarea> <br> </td> <input name="Submit" type="submit" id="Submit" value="!" style="position: absolute; left: 121; top: 329; color: #D95503; width: 157px; height: 23px; border: 1px solid #D95503; background-color: #D95503" tabindex="3"></p></form> <p style="margin-top: 0; margin-bottom: 0"><font size="4" face="Agency FB">Maximum characters: 140. You have <input readonly type="text" name="countdown" size="3" value="140"> characters left.</font> </font></p> <p style="margin-top: 0; margin-bottom: 0">nmgnm,</p> </body> How do I Link text in a div, h1, h2, p to an external text file or xml file - I don't really know how to ask the question. I think I need an xml file that can be easily edited by a user saved to the server to update an xhtml page text without the user getting bogged down in html. I don't want to use joomla or cms. <Any ideas />? Best wishes, mas Hi, this is appleguy.......6142! I was wondering how to make a text box display something somewhere else for example (This does not work)---- ------------------------------------------------------------------ [page1.html] (Pretend this is a text box)>>> [Text Text Text...] [page2.html] -This is the text displayed in the text box->>>Text Text Text... HOW DO I DO THAT PLEASE HELP!! |