So far, I'm only working on the first 2 columns, Placeholder and English Text.

//Placeholder
$query_ph = "SELECT ph_name from placeholder";
$result_ph  = mysql_query($query_ph) or die('Query failed:'.mysql_error());

//English Text
$query_en = "SELECT text from content WHERE lan_id=1";
$result_en = mysql_query($query_en) or die('Query failed:'.mysql_error());
?>

  1. curl options

    Date: 12/11/06 (PHP Community)    Keywords: html, asp

    i use curl to talk to our local mls system (EXCITING!). this is the relevant part of the function i use to, in this case, perform a search:



    when i run a script that uses this function, i get


    # Netscape HTTP Cookie File
    # http://www.netscape.com/newsref/std/cookie_spec.html
    # This file was generated by libcurl! Edit at your own risk.

    rets15.raprets.com FALSE / FALSE 0 RETS-Session-ID blah1019181817161514131211zzzzz

    USEFUL OUTPUT


    i know this is really nitpicky, but is there anyway to suppress the, "Netscape HTTP Cookie File," stuff (while still using the cookie i've generated)? i'm not echo'ing anything ever, it just spits that out to the console everytime the function fires... and uh, i don't like it.

    Source: http://community.livejournal.com/php/520302.html

  2. Anchor tags and iFrames

    Date: 12/11/06 (Web Development)    Keywords: php, html, java, google

    Hey guys,


    My question is about iFrames. But let me backtrack and tell you about the kind of thing I'm trying to implement.

    I'm actually using an iFrame to embed a blog to an ordinary HTML page. When the user clicks on "read comments," the php code fetches the site_url + #anchor. Ok? Now, this was fine in theory until I tried it out, and turns out that using URL + anchor in an iframe scrolled the PARENT window down, as well as the iFrame.

    So, I googled around and found this script, which uses offSetTop to determine how many pixels the element is off the top, and then sets the scroller to that location thanks to scrollTop. This looks like just what I need actually, and with some modifications, it might work, but when it comes down to it, this script displays navigation buttons on the parent page (mine shouldn't do that) and also the buttons are generated by the iframe.


    < script type="text/javascript" >
    < !--

    function goAnchor(id){
    anchorPos = window.frames['anchor_iframe'].document.getElementById(id).offsetTop;
    window.frames['anchor_iframe'].document.body.scrollTop = anchorPos;

    }

    // -- >

    As a way of thinking myself out of this box, I figured that I could perhaps...make PHP embed the scrollTop value in the URL...(which is probably not feasible since scrollTop is DOM property, not HTML) and my second idea is using PHP to put out a few lines of JavaScript that scrolls the window after it has been loaded, and while I sense this might work, I wonder if there is a standard way of getting around the problem, which is the unwanted scrolling of the parent window to the anchor tag of the embedded iFrame.

    Makes sense?

    Sorry I can't provide a link to this implementation, since I'm working on it locally and can't take it live right now.

    Oh...plus..do you know...if there is any way of fetching variable values from inside an iframe for use by the parent tag? Not DOM properties, mind you, but like some JS variable.

    Source: http://community.livejournal.com/webdev/375424.html

  3. mysql podcasts!

    Date: 12/14/06 (MySQL Communtiy)    Keywords: php, mysql, browser, html, sql, web

    I realized I haven't told Livejournal about the MySQL Podcast that's been produced. The third episode has been published -- see http://www.technocation.org to subscribe or search for "mysql" or "oursql" on your favorite site to find podcasts, including itunes. Episode 0 and Episode 1 are still available.

    Episode 2 is here! It's a bit late due to a computer crash and the fact that I sprained my ankle, but I think it's worth waiting for. Particularly since this week's feature is everyone's favorite -- performance tips!


    It's best to subscribe to the podcast by clicking the "podcast" graphic at http://www.technocation.org , or searching for "mysql" in your favorite podcast directory (including iTunes). But if you want to play episode 2 in your browser, visit http://technocation.org/index.php?option=com_content&task=view&id=22&Itemid=29

    Please consider promoting the show -- we have a 40 second promo ready for download at:

    http://www.technocation.org/podcasts/oursql/OurSQLpromo1.mp3

    Show Notes:
    News

    http://www.mysqlconf.com/

    Free Survey, win a free pass

    http://www.zoomerang.com/recipient/survey-intro.zgi?p=WEB225WZRG2XU7

    You can now find this podcast, OurSQL, on many podcast sites including:


    http://www.itunes.com

    http://www.podcastalley.com

    http://www.podfeed.net

    http://www.podcastblaster.com


    just search for "mysql" on any of those sites and you'll find the podcast. You can also find it at:


    http://feeds.feedburner.com/oursql


    Learning Resource

    Promo

    http://www.tech-in-sight.com/

    Feature

    Peter Zaitsev's blog post about count for InnoDB tables:
    http://www.mysqlperformanceblog.com/2006/12/01/count-for-innodb-tables/

    Acknowledgements/Sponsors

    http://www.technocation.org

    http://music.podshow.com

    http://www.russellwolff.com

    http://www.smallfishadventures.com/Home.html "The Thank you song" -- Smallfish




    You can Direct download oursql podcasts at:
    http://technocation.org/podcasts/oursql/

    If you have any feedback about this podcast, or want to suggest topics to cover in future podcasts, please email

    podcast@technocation.org

    You can also:

    Call the comment line at +1 617-674-2369

    Or use Odeo to leave a voice mail through your computer:
    http://odeo.com/sendmeamessage/Sheeri

    Or use the Technocation forums:
    http://tinyurl.com/sc6qw

    Source: http://community.livejournal.com/mysql/107360.html

  4. Downloading Jumpcut videos

    Date: 12/14/06 (Computer Help)    Keywords: html

    Does anyone know how to download streaming flash videos on Jumpcut?

    I was trying to make a video, and both Premiere and Windows Movie Maker were giving me issues. So I finally found Jumpcut and got my movie made. But now it's stuck there!

    It's a flash file, but using Video Downloader with FireFox isn't working. I get three different things to download, one an HTML file and two "jump.swf" files that don't play anything.

    I want to have a copy of the video on my computer and upload it to YouTube as well, so can anybody help?

    Cross-posted to the one without the underscore.

    Source: http://community.livejournal.com/computer_help/723653.html

  5. html email

    Date: 12/16/06 (WebDesign)    Keywords: css, html

    Hey folks, I'm stumped and need your help.

    I'm working on an html email which has a background image. Apparently gmail doesn't play nice with the css for backgrounds so I need to find a way around this. I've tried going back to using html to just format the background, but I can't for the life of me figure out how to get the background to not tile.

    There had to be a way to do this back in the days before css right?? Does anybody remember how to do this?

    Source: http://community.livejournal.com/webdesign/1195887.html

  6. Layout help

    Date: 12/17/06 (HTML Help)    Keywords: html, asp, security

    I found some LiveJournal layouts that I adore...the only problem is that I like certain aspects of each of those layouts.



    • I like the layout of this one

    • The background of this one

    • And, just to make things more complicated, I wanted to fit this banner in somewhere


    So, I fiddled with the overrides, using W3Schools as my security blanket because I am by no means an HTML expert. I also used '[info]'overridehelp to help with fitting in my header, using both this, this and this.

    After fiddling for hours, my journal is a mess. I have a couple questions:


    • Can these layouts even be combined?

    • If so...


      • How can I make the tabs fit below the banner?

      • How can I move the default icon to be in line with the sidebar?

      • How can I move the sidebar?

      • How can I center the entries and the sidebar?





    Thank you!
  7. Source: http://community.livejournal.com/htmlhelp/2374528.html

  8. What is a rock solid PHP/HTML text editor?

    Date: 12/19/06 (Web Development)    Keywords: php, software, html

    My Dreamweaver just went kaput, and I cannot figure out how to fix it. OH WELL. It was a bloated piece of software anyway, and I oinly used the text editor.

    What would be a good replacement text editor for using HTML and PHP? I just need something that does color encoding and numbers my lines of code for me. Oh, and I would love it to be free. Come on, I know there are some well respected text editors out there that I don't know about.

    Source: http://community.livejournal.com/webdev/377319.html

  9. MySQL Database Podcast!

    Date: 12/19/06 (MySQL Communtiy)    Keywords: php, mysql, software, html, sql, java, spam, microsoft

    Episode 3 is here!

    If folks have ideas or suggestions for content, please let me know.



    You can Direct download all the oursql podcasts at:
    http://technocation.org/podcasts/oursql/

    Direct play this edition at:

    http://tinyurl.com/yy7pgz



    News

    Download MySQL Turbo Manager Free Edition at: http://www.mentattech.com/themes/mentat/download.html



    Wireless providers prefer MySQL over Oracle, Microsoft SQL Server over both:

    http://www.crn.com/sections/breakingnews/breakingnews.jhtml?articleId=196700062


    Learning Resource

    Artful Software's list of common queries. They also have an interesting e-book available, called "Get it Done with MySQL 5.0".

    http://www.artfulsoftware.com/queries.php


    DATEDIFF(), DAYOFWEEK() functions

    http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

    Promo

    This week’s promotion comes from Geek Fu at http://www.geekfuactiongrip.com



    Feature

    Concurrency and Isolation Levels
    http://sheeri.net/index.php?p=123



    Acknowledgements

    http://www.technocation.org

    http://music.podshow.com

    http://www.russellwolff.com

    http://www.smallfishadventures.com/Home.html "The Thank you song" -- Smallfish


    Feedback

    If you have any feedback about this podcast, or want to suggest topics to cover in future podcasts, please email

    podcast@technocation.org This email address is being protected from spam bots, you need Javascript enabled to view it

    You can also:

    Call the comment line at +1 617-674-2369

    Or use Odeo to leave a voice mail through your computer:
    http://odeo.com/sendmeamessage/Sheeri

    Or use the Technocation forums:
    http://tinyurl.com/sc6qw

    Source: http://community.livejournal.com/mysql/108124.html

  10. Bad Code, No Biscuit.

    Date: 12/21/06 (HTML Help)    Keywords: html

    I humbly beg for some form of assistance from you kind and gentle people. I was given some code by an acquaintance to put a grey background around the icons I wanted to display. I posted it to my LJ for future reference here and tried to alter it a little bit to better suit my needs. Apparently I changed something that I shouldn't have or didn't change something that I should have when I altered it. I tried not to mess about with it too much since I'm not HTML savvy, but I would really like some help figuring out what I did wrong so my LJ will load right. Could someone take a look at the code and see what's wrong.

    The original code can be found in the comments here, though I'd love to know how he made the little box the code came in but I'm a bit afraid to ask. :)



    SAMPLE:




    6:



    ##. ##. ##. ##. ##. ##.


    5:



    ##. ##. ##. ##. ##.


    4:



    ##. ##. ##. ##.


    3:



    ##. ##. ##.


    2:



    ##. ##.


    1:



    ##.


    ORIGINAL CODE:



    001 002 003 004 005
    006 007 008 009 010


    Source: http://community.livejournal.com/htmlhelp/2376246.html

  11. IE hates Background Colors

    Date: 12/21/06 (Web Development)    Keywords: css, html

    I decided to take a crack and converting my nice tables layout into a div one. And, naturally, I'm running into problems. Take a peek at the following page in IE 6 and FF:

    http://www.kriona.net/dml/ie/
    http://www.kriona.net/dml/ie/css.css

    Putting a background color on the "main" div is what causes this - when removed, Lorem Ipsum shows up great. Question is... why? And how can I fix it? I discovered that I can, instead of specifying a color, make the background a 1x1 pixel image of the appropriate color, and IE does not freak out about this. So why is it going crazy about a background color, but not an image?

    Also, the HTML validates, and I tried a different doctype, to no avail.

    Source: http://community.livejournal.com/webdev/379135.html

  12. Nested Loops??

    Date: 12/23/06 (PHP Community)    Keywords: php, mysql, html, sql

    Hi everyone, I'm a bit confused with PHP While Loops. =/

    Currently, I want to echo a table that has 4 columns, "Placeholder (ph_name)", "English Text (text)", Foreign Text (text area)", "Action (save)". 

    When I view the page, the table cells are all jumbled up.

    the html codes should look like that:

ph_nametexttext areasave

 
// Get each row of data on each iteration until there are no more rows

while($row_ph = mysql_fetch_array($result_ph)){
echo "";
echo "";

          while ($row_en = mysql_fetch_array($result_en)){
               echo "";
}
}
?>
PlaceholderEnglish TextForeign TextAction
";
echo $row_ph['ph_name'];
echo "
";
               echo $row_en['text'];
               echo "


How should I nest the loops? 
Thanks! (:

x-posted to '[info]'php_mysql

Source: http://community.livejournal.com/php/525071.html

  • wefeelfine screensaver?

    Date: 12/29/06 (Computer Geeks)    Keywords: programming, html, java, web

    i am in love with www.wefeelfine.org, and ever since i fell in love with it i've thought it would make a spectacular screensaver, but i can't seem to figure out a feasible way to do so

    there are several programs that allow you to use a website as a screensaver but the problem is that once the site is loaded java says something along the lines of "please click on this applet to focus" - which means that nothing displays and the purpose is defeated

    does anybody have any ideas of how to get around this? or how i could get some sort of wefeelfine.org screensaver?

    the author wishes for the same thing:

    Unfortunately, the "please click here to focus" is a property of a java applet and not something we programmed in.
    Sorry about that!
    Sep


    On 12/29/06, Jamie Martin wrote:
    Thanks for your quick response!

    Is there a way for the code to be modified to remove the "please click
    here to focus" part? To where it just automatically goes into the
    Movements?

    You have wefeelfine_pc.html and I assume wefeelfine_mac.html, it could be
    wefeelfine_noclick.html or something like that?

    On Thu, 28 Dec 2006 19:19:23 -0700, Sep Kamvar wrote:

    > Hi Jamie,
    >
    > I'd love it if somebody were to make a screensaver.
    > One way to do this is to, write a script that each day downloads the
    > montages:
    > the pattern is:
    > http://www.wefeelfine.org/data/images/2006/12/05/*montage.jpg
    >
    > And then make a screensaver that cycles through the montages that have
    > been
    > downloaded. As far as I know, there are screensavers that will take a
    > group
    > of images and will make a screensaver that cycles through them.
    >
    > Let me know if you end up making one. I'd love one for myself :)
    >
    > Sep
    >
    > On 12/28/06, Jamie Martin wrote:
    >>
    >> This would be an amazing amazing screensaver, has there been anybody
    >> who's
    >> tried to do that?
    >>
    >> I have a program that will use a URL as a screensaver but when I put in
    >> http://www.wefeelfine.org/wefeelfine_pc.html it doesn't work because it
    >> says "please click to activate this control" within the applet.
    >>
    >> Any ideas would be GREATLY appreciated. Thanks. :)


    so yes, if you or and of your programming friends have any ideas tha'd be cool.

    otherwise go enjoy www.wefeelfine.org, it's neat

    edit: submitted to digg, if you wouldn't mind digging this, i think maybe we could get help with that kind of exposure, thanks! :]

    Source: http://community.livejournal.com/computergeeks/1016395.html

  • wefeelfine screensaver?

    Date: 12/29/06 (WebDesign)    Keywords: programming, html, java, web

    i am in love with www.wefeelfine.org, and ever since i fell in love with it i've thought it would make a spectacular screensaver, but i can't seem to figure out a feasible way to do so

    there are several programs that allow you to use a website as a screensaver but the problem is that once the site is loaded java says something along the lines of "please click on this applet to focus" - which means that nothing displays and the purpose is defeated

    does anybody have any ideas of how to get around this? or how i could get some sort of wefeelfine.org screensaver?

    the author wishes for the same thing:

    Unfortunately, the "please click here to focus" is a property of a java applet and not something we programmed in.
    Sorry about that!
    Sep


    On 12/29/06, Jamie Martin wrote:
    Thanks for your quick response!

    Is there a way for the code to be modified to remove the "please click
    here to focus" part? To where it just automatically goes into the
    Movements?

    You have wefeelfine_pc.html and I assume wefeelfine_mac.html, it could be
    wefeelfine_noclick.html or something like that?

    On Thu, 28 Dec 2006 19:19:23 -0700, Sep Kamvar wrote:

    > Hi Jamie,
    >
    > I'd love it if somebody were to make a screensaver.
    > One way to do this is to, write a script that each day downloads the
    > montages:
    > the pattern is:
    > http://www.wefeelfine.org/data/images/2006/12/05/*montage.jpg
    >
    > And then make a screensaver that cycles through the montages that have
    > been
    > downloaded. As far as I know, there are screensavers that will take a
    > group
    > of images and will make a screensaver that cycles through them.
    >
    > Let me know if you end up making one. I'd love one for myself :)
    >
    > Sep
    >
    > On 12/28/06, Jamie Martin wrote:
    >>
    >> This would be an amazing amazing screensaver, has there been anybody
    >> who's
    >> tried to do that?
    >>
    >> I have a program that will use a URL as a screensaver but when I put in
    >> http://www.wefeelfine.org/wefeelfine_pc.html it doesn't work because it
    >> says "please click to activate this control" within the applet.
    >>
    >> Any ideas would be GREATLY appreciated. Thanks. :)


    so yes, if you or and of your programming friends have any ideas tha'd be cool.

    otherwise go enjoy www.wefeelfine.org, it's neat

    edit: submitted to digg, if you wouldn't mind digging this, i think maybe we could get help with that kind of exposure, thanks! :]

    Source: http://community.livejournal.com/webdesign/1197907.html

  • Faux graphic security for forms

    Date: 12/30/06 (Javascript Community)    Keywords: css, html, java, security, spam

    I have an old site thats getting spammed so I created this faux graphic security script
    First: create several of those graphics with numbers+letter strings (this example uses 5)
    This script hides the form (with CSS) until the correct value entered
    if anything, it will slow them down and should block some bots.
    Sorry the formatting is all jacked up - its a montage of old script an new :)


    JAVASCRIPT IN EXTERNAL FILE sk.js

    //faux graphic security

    title = new Array(5);
    title[0] = 'securitykey00.gif'
    title[1] = 'securitykey01.gif'
    title[2] = 'securitykey02.gif'
    title[3] = 'securitykey03.gif'
    title[4] = 'securitykey04.gif'

    index = Math.floor(Math.random() * title.length);

    document.write("Please enter number to continue to add listing.");
    document.write("
    ");
    document.write("");
    document.write("");
    document.write("");
    document.write("
    ");



    function compareVal(location)
    {
    title = new Array(5);
    title[0] = 'a3f67j9L';
    title[1] = 'K1yp97E';
    title[2] = 'Ww253Gh';
    title[3] = '6K6k6K2';
    title[4] = 'wKrP738';

    value = document.getElementById("testvalue").value;

    if(title[location] == value)
    {
    document.getElementById("form").style.display = "inline";
    document.getElementById("security").style.display = "none";
    } else {
    alert("Please enter the correct value.");
    }

    //alert(location +" - "+value);
    }

    HTML AND CSS





    ***put the form here***

    Source: http://community.livejournal.com/javascript/122818.html

  • .shtml and .php

    Date: 12/30/06 (PHP Community)    Keywords: php, html, web

    I have this include .htm inside my .shtml
    this way I just have to update this one file for my web site at the top.
    It is my current count of my business cards
    www.cardeologist.com
    Anyways, on my pages with the .php file it won't work.
    Is there a way to get it to work?
    Example it works on www.cardeologist.com/index.shtml
    but it won't work on www.cardeologist.com/contact.php

    Source: http://community.livejournal.com/php/527345.html

  • Graphically Challanged!

    Date: 12/30/06 (HTML Help)    Keywords: html

    I NEED HELP!
    Honestly, I am so graphically challenged it's driving me up the wall! Here is my dilemma:

    I need a gif title bar that doesn't look like ass.

    Here is what I have:



    Here is how it looks when it's on the site:



    I know that a .png is the best file to get the lovely transparency with. However, I have to save it as a .gif to get the animation. Does anyone know how to get the .gif to look nice without that ugly-ass white boarder around it? Is there any suggestions on how to get this to work? I am desperate for anybody's help with this. I just spent six hours learning how to get a video in a gif and making the design, and now it's all bleh. I would really appreciate any help. I'm feeling tired and frustrated.

    And since I'm making a post, in coding, what is it called (or what is the coding) to get your url to stay fixed? What I mean is, when someone goes to your site (ie. www.frozentears.org) and clicks on a page the address bar changes to (www.frozentears.org/page.html) how does one get their url to stay (www.frozentears.org) in the address bar regardless of the link they click on?

    Anyway. I'm desperate for your help.
    THANK YOU ALL WHO TAKE THE TIME TO READ THIS!!!!
    *HUGS*

    Source: http://community.livejournal.com/htmlhelp/2379292.html

  • Fun game

    Date: 01/02/07 (Javascript Community)    Keywords: php, mysql, html, sql, java, spam

    I must have a bot watching my site, here is an example
    http://www.tfcdesign.com/spilledink/classifieds/sifc002n.html

    When I clear out their spam, it fills up immediately. Its kinda fun. Right now I have a javascrip that redirects their IP shows up. Apparrently JS doesnt work.

    The scripts are all perl and I havent used perl in over 6 years :) This site has been self maintaining since 1996.

    So, now I get to try and beat the bot.

    I've redone the site in PHP and MYSQL here
    http://www.spilledink.com/classifieds/electronics.php

    so it isn't a big deal. I havent shut down the old site because I make money from both.

    Eventually, the new site will be like Craigslist requiring a valid email and email validation. For this site I think I'll have to use PERL to kick this guy. ... or maybe just submit the form with javascript.

    Is there a way to tell if a specific visitor has javascript enabled? I'll have to see if PERL can do this.

    Source: http://community.livejournal.com/javascript/122894.html

  • flash links

    Date: 01/02/07 (WebDesign)    Keywords: html

    im building an html site, but my four major links are flash elements. the tabs slide in and out.
    screen cap here: http://img.photobucket.com/albums/v11/llllxstarxllll/Picture2.png

    so after a lot of trouble and bad internet tutorials i figured out how to get them to slide in and out on a roll over. but now i cant figure out how to make them links. i thought this was something achieveable in dreamweaver but it looks like i have to do it with action script?

    so, im confused and if anyone can help me out that would be fantastic.

    Source: http://community.livejournal.com/webdesign/1199639.html

  • Argh.

    Date: 01/03/07 (HTML Help)    Keywords: html

    Well I was just changing up my journal a little bit. I used to be pretty good with HTML but I sorta stopped using it and now I just have a few problems with my overrides.
    My layout's simple, I have generator.
    Problems:
    My fonts for my top links aren't changing (check my codes).
    My font for the entire page isn't changing to Schindler.


    GLOBAL_HEAD<=





    <=GLOBAL_HEAD

    FRIENDS_WEBSITE<=

    http://www.livejournal.com/userinfo.bml?user=angerisagift09">I'll make ithttp://www.livejournal.com/users/angerisagift09/friends"> to the moonhttp://www.livejournal.com/users/angerisagift09/calendar"> if I have to http://www.myspace.com/angerisagift09"> Crawl.
    <=FRIENDS_WEBSITE

    FRIENDS_TALK_LINKS<=


    %%readlink%%Say something.


    <=FRIENDS_TALK_LINKS

    LASTN_TALK_READLINK=>%%messagecount%%Comment%%mc-plural-s%%|

    FRIENDS_TALK_READLINK=>%%messagecount%%Comment%%mc-plural-s%%|

    LASTN_WEBSITE<=

    http://www.livejournal.com/userinfo.bml?user=angerisagift09">I'll make ithttp://www.livejournal.com/users/angerisagift09/friends"> to the moonhttp://www.livejournal.com/users/angerisagift09/calendar"> if I have to http://www.myspace.com/angerisagift09"> Crawl.
    <=LASTN_WEBSITE

    LASTN_TALK_LINKS<=


    %%readlink%%Say something.


    <=LASTN_TALK_LINKS

    Source: http://community.livejournal.com/htmlhelp/2380534.html

  • Batch Edit?

    Date: 01/03/07 (WebDesign)    Keywords: html

    Is it possible to batch edit a series of html files?

    I have about 60 pages that a small snippet of code as was wondering if there was a better way that pasting and saving, pasting and saving, etc etc.

    Thanks all.

    Source: http://community.livejournal.com/webdesign/1201528.html

  • Previous page  ||  Next page


    antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home