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 empty is required, the following 50 results were found.

  1. Generate Academic Calendar using MySQLhttps://joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

    468 2012/2013 52 2013-07-08 I'll use this table to create the calendar. Query #1: Works from command-line but may generate "Empty Query 1065" SELECT calendar.WeekNumber AS AcademicWeek, DATE_FORMAT(calendar.StartDate, '\%e-\%b-\%y') AS Mon,...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  2. Quickly update all content in mySQL database replacing a stringhttps://joellipman.com/articles/else/database/mysql/quickly-update-all-content-replacing-a-string.html

    CONCAT('%',@stringtoFind,'%') OR `fulltext` LIKE CONCAT('%',@stringtoFind,'%') You might get some errors talking about some empty rows but don't be deceived as the update will have happened anyway. Other Searches Search and Replace a string in a mySQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  3. CSS keeping the footer at the bottomhttps://joellipman.com/articles/cms/website-development/css/css-keeping-the-footer-at-the-bottom.html

    } #content { position: relative; top: 0; width: 900px; margin: 0 auto; min-height: 500px; /* to stop footer coming up on empty pages */ background-image: url("../images/bg_contentbox.png"); /* semi transparent background */ } #footer { position:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB

  4. Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

    . " "; The key of the above array is the name of the variable you passed in your HTML form. If the above yields NO empty data (and size is not 0) then it was successful. If not, then either your system isn't accepting the file type you are trying to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  5. Convert Past Date to Time Ago in PHPhttps://joellipman.com/articles/cms/website-development/php/convert-past-date-to-time-ago-in-php.html

    plural/singular (should always be a positive number) $v_Str .= $a_UnitValues[$i]>1 ? 's' : ''; // only add to array if not empty/zero if($v_Str!='') $a_UnitPairs[] = $v_Str; } // take first item of array (round up to largest unit) $v_ReturnStr =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  6. MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    each sheet into a file each. And we want all the files generated to be created in the same folder. Move the Excel file to an empty folder of its own With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  7. Warning call_user_func: First argument is expected to be a valid callbackhttps://joellipman.com/articles/cms/joomla/warning-call-user-func-first-argument-is-expected-to-be-a-valid-callback.html

    .= call_user_func($block, $this, $mClasses); } And change it to: foreach($this->horizontalCookie[$row] as $block) { if(!empty($block)) { $block = str_replace('-', '', $block); $this->module_row1 .= call_user_func($block, $this, $mClasses); } }

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  8. Reminder on SSRS row separatorhttps://joellipman.com/component/content/article/reminder-on-ssrs-row-seperator.html?catid=75&Itemid=165

    room bookings. Each row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear between each day in the list, so I have: Monday 03/10/2011 Main Office 09:00 17:00 Notes Monday 03/10/2011...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  9. PHP - Remove newlines and spaces from StyleSheethttps://joellipman.com/articles/cms/website-development/php/php-remove-newlines-and-spaces-from-stylesheet.html

    "?a"); $v_AppStyleFormatted = str_replace($a_ReplaceFrom1, $a_ReplaceTo1, $v_AppStyleFormatted); // replace all spaces to empty and replace question marks back to spaces $a_ReplaceFrom2 = array(" ", "?"); $a_ReplaceTo2 = array("", " ");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *

  10. Select unique values in Microsoft Excel columnhttps://joellipman.com/component/content/article/select-distinct-values-in-microsoft-excel-column.html?catid=110&Itemid=165

    This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help sites: Office 2010: Select the data range to do this to. Click on the "Data" tab. Click on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 41 - 50 of 50