The detritus of a Button Monkey

Archive for March, 2007

31 Mar

Problems with MAX() and MIN() with MySQL

I have been playing around with some data manipulation and performing some basic stats on the data. I used this SELECT statement as a starting point: SELECT Round(STDDEV(Result),2), Round(AVG(Result),2), COUNT(Result), Round(MIN(Result),1), Round(MAX(Result),1) This allowed me get the standard deviation, mean and number of results. The Round refers to rounding the result and the number is […]

31 Mar

Selecting data from MySQL according to month

I have had reason to select data from a table 0f 8,000 rows according to month. What I wanted to do was create a dynamic page where I could have a drop down box for months and years and then provide data based on the options. The problem I initially had was to get my […]

29 Mar

Generating dynamic images with php & GD

I have been playing around with generating images using php. The end goal is produce graphs generated from data pulled from a MySQL database. I will post more later but here are some of the problems that I have resolved so far: Unable to generate an image or getting an error like: The image “http://localhost/button.php” […]

27 Mar

Pearls of wisdom

http://www.lucidcafe.com/library/pearls.html

27 Mar

Brave man part 2

This was doing the rounds on the local Lug: http://newsbiscuit.com/article/courage-award-for-man-who-threw-out-old-computer-cables

25 Mar

Stargate news for J & F

Saw this and thought of you two…. http://www.gateworld.net/news/2007/03/third_series_is_istargate_univer.shtml

25 Mar

OpensourceHowto.org

Saw this on the local LUG mailing list and thought it deserved wider attention.http://www.opensourcehowto.org/

23 Mar

Gonzo Stunt Game!!!!

http://muppets.go.com/games/muppets-flyinggonzo.html

22 Mar

More optical illusions

http://www.scientificpsychic.com/graphics/

22 Mar

Retaining a value in a form in php

The standard construction of an input box is like this: <INPUT type=”text” name=”name” size=”5″  maxlength=”5″> The various components being fairly obvious, size being the length of the screen box and max length referring to the length of input that can be stored.  When the page is submitted and validated, the values are lost if validation […]

© 2019 The detritus of a Button Monkey | Entries (RSS) and Comments (RSS)

Design by Your Index - Powered By Wordpress