Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming which is required, the following 337 results were found.

  1. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more....

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  3. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    the website. If you are dissatisfied with our services or need another developer to take over, you can at any point control which server your website visitors will go to when they type your domain name. Important: You only need the domain name and no...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  4. Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other side of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  5. CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/cms/website-development/css/css-background-without-causing-scrollbars.html

    the clouds as another div layer, specified the width and height and specified it's left. It caused the horizontal scrollbar which is a bit annoying because you scroll to the right and theres nothing but some background image. Also the footer was at 100%...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  6. CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/cms/website-development/css/css-keeping-the-footer-at-the-bottom.html

    main content had a semi-transparent layer that overlapped it half-way. I managed to fix this by including a div push layer which clears both (even though i had clear:both on the css for my #right div layer). For some reason, it has a more forceful...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  7. Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/cms/website-development/css/three-boxes-two-roll-over-one-falls-out.html

    top row and the third would pop under these. As for MSIE, that was ok when maximized. How? You could do loads of code hacks which is what I tested but all for nothing because you always end up needing to specify a third of the width. Our template was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  8. Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/cms/website-development/js/pure-js-display-time-elapsed-remaining.html

    a note of it to not have to search elsewhere... This example specifically displays the time remaining on an access_token which is generated from an OAuth 2.0 process. I want to display to the user how much time is left before another access token will...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  9. Slideshow div layer through a windowhttps://www.joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

    If we have 100 slides then 100 slides of data will need to load at the same time per page. Terrible. Using AJAX (which will have to be Asynchronous JavaScript and xHTML. I'm not using XML, or is that AJAHtml? AJAH?), anyway, we can send each new info to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
  10. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    $display_excerpt=search_highlight($result_Content, $terms_rx)."..."; I like to include a "Did-you-mean" section which I also use for any AJAX suggestion feature (be flexible with us as some customers have asked how does it get that word and why is it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  11. htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/cms/website-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    http://www.mysite.com/blog/videos/2010/january/21.html // sends index.php?myFolder=blog/videos/2010/january&myFiles=21 Which, hopefully, the PHP file will handle as: var $site_structure_string = $_GET['myFolder']; $site_structure_string =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  12. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    in diamond symbols and how I solved it in my case. Why? My company has started using international country and region names which include foreign characters. When we copy and paste their content into our website, our webpages display a question mark...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  13. MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/else/database/mysql/mysql-day-of-week-ending-on-friday.html

    Saturday. Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the following Sunday. The solution below is for the opposite, where the week starts on the previous...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. SQL: Use CASE for Relevance columnhttps://www.joellipman.com/articles/else/database/mysql/sql-use-case-for-relevance-column.html

    adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized)...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  15. MySQL Updating a database table from another tablehttps://www.joellipman.com/articles/else/database/mysql/mysql-updating-a-database-table-from-another-table.html

    on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written because it took me...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  16. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://www.joellipman.com/articles/cms/website-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

    downloaded file into memory with simplexml_load_string(). I get the above error when it is attempting to load an XML feed which is mostly in Spanish and breaks at the following XML node: 2 -> yields issue: PHP Warning: simplexml_load_string(): 2 in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  17. SITS: Export field code and namehttps://www.joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    the chevrons ("»") next to the field to apply this to Enter the dictionary code, the entity code and then the inner SRL text which should be |, if you try to apply you should be prompted to convert to use gold characters: Test the XET export and you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  18. Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

    PHP code to work in earlier PHP versions. - Fixed bug: could not see Hebrew text. - Fixed bug: refer to $fulltext variable which is now obsolete. - Date Uploaded: Mon, 25th Oct 2010 1.2.1 - Removed some word OTT extraction functions (eg. applet, map,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  19. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    Date: no, alongside, popup, both - Parameter: Display Hit Counter: no, alongside, popup, both - Parameter: Specify Group(s) which can refresh thumbnails - Parameter: Description Length - Parameter: Image Rounded Corners (latest browsers only) -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  20. Xero API: Send Multiple Invoiceshttps://www.joellipman.com/articles/else/fintech/xero/xero-send-multiple-invoices.html

    got stumped by the same issue: How to send multiple invoices to Xero in one API call? Why? Our use-case is in Zoho Deluge which couldn't generate more than 5 invoices in a scheduled task because Xero only allows 5 concurrent connections at one time......

    • Type: Article
    • Author: Joel Lipman
    • Category: Xero
    • Language: *
Results 301 - 320 of 337