31 Mar
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 [...]
Posted in Coding, Project, Work by: dapo
No Comments
31 Mar
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 [...]
Posted in Coding, Project, Work by: dapo
No Comments
29 Mar
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” [...]
Posted in Coding, Linux, Project, Work by: dapo
No Comments
27 Mar
http://www.lucidcafe.com/library/pearls.html
Posted in Funny, Tips by: dapo
No Comments
27 Mar
This was doing the rounds on the local Lug: http://newsbiscuit.com/article/courage-award-for-man-who-threw-out-old-computer-cables
Posted in BBLUG, Funny by: dapo
No Comments
25 Mar
Saw this and thought of you two…. http://www.gateworld.net/news/2007/03/third_series_is_istargate_univer.shtml
Posted in Else by: dapo
No Comments
25 Mar
Saw this on the local LUG mailing list and thought it deserved wider attention.http://www.opensourcehowto.org/
Posted in BBLUG, Linux by: dapo
No Comments
23 Mar
http://muppets.go.com/games/muppets-flyinggonzo.html
Posted in Funny by: dapo
No Comments
22 Mar
http://www.scientificpsychic.com/graphics/
Posted in Stumble by: dapo
No Comments
22 Mar
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 [...]
Posted in Coding, Project by: dapo
No Comments