Assuming that is required, the following 493 results were found.
-
Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Strip HTML in MySQLhttps://www.joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html
used. How? There were a few functions out there. One called "strip_tags" crashed in the running of the query. The function that did work errored persistently complaining about the delimiter, create the function by running the following: SET GLOBAL...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This has taken me too long to figure out and I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being dynamically...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: en-GB
-
a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type: text/plain; charset=utf-8'); header('Content-Disposition: attachment;...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
}else{ $author_name_disp=ucfirst($author_name); } // output echo $author_name_disp; A lot of repetition so lets reduce that a touch: // default $author_name_disp=$author_name; // check and transform $delimiters=array(' ', '.'); foreach($delimiters as...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
the system has never heard of it. Why? To test the XET I created, I want to see what the resulting XML will look like so that my post-staging phase can be developed as it will know what the data and label fields look like. How? I had this in my training...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
quick to complete but if you've ever youtube'd the levels, there isn't another game so quick-paced and varied giving you that freedom of completing the game your way. The sountrack is November has come by the Gorillaz {youtube}h5a3RElr7Hs{/youtube}
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
I love technologies that replace conventional methods and thought processes. In this video, Sir J. Dyson demonstrates a new type of fan which uses a fraction of the energy of normal fans. In the UK, we may not need air conditioning as much as other...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
to [h]:mm:ss -- yields 1:00:00 0.04166667 =(ROUND(B5/0.07, 0)*0.5)/24 -- now format to [h]:mm:ss -- yields 1:00:00 Note that the first formula is converting person days into minutes and then dividing by 1440 (resulting in the decimal number: 0.04166667...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Expand > 10 px Fill this selection with another color (in the example below: dark grey) Add the brush with the same color to that layer...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
Personally I can sit there watching it without sound. Here's another video that shows how to build the camera:
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
hardware has to be the following notion from IBM: a 1976 research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be quite useful to permit users to 'take back' at least the immediately preceding command (by issuing some...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *