Summary Everybody needs a contacts table sooner or later. There is nothing that special about this one, but it is a place to start. Mostly likely, you will need to add and/or subtract field names. The straight SQL files are linked below, including the three look-up tables referenced in the contacts table. There is also…
Summary Here is a “quick and dirty” way to get a drop-down box in an HTML page to show the latest values from a MySQL database. Notice that there is a significant lack of error-handling. It sure did help clean up my HTML form, though. Assumptions: You already have a mysql connection object open and a MySQL database…
Problem: I could not get my responsive Adsense unit (from Google) to show up in the “banner” position module while using the Joomla Protostar template. When I put the same code in a different module position, it showed up immediately after refreshing the page. Possible Solution: After wrapping the Adsense code in a paragraph tag that was…
The MySQL data-types table in Open Document format (much better for printing). Type {storage} Name Range Attributes Default Numeric{1 byte} TINYINT[(M)] -128 TO 127[0 to 255 if UNSIGNED] AUTO_INCREMENTUNSIGNED, ZEROFILL,SERIAL DEFAULT VALUE NULL[0 if NOT NULL] Numeric{2 bytes} SMALLINT[(M)] -32,768 to 32,767[0 to 65,535] AUTO_INCREMENT,UNSIGNED, ZEROFILL,SERIAL DEFAULT VALUE NULL[0 if NOT NULL] Numeric{3 bytes} MEDIUMINT[(M)] -8,388,608 to 8,388,607[0 to 16,777,215] AUTO_INCREMENT,UNSIGNED,…
Replacement of rotten steps project. My main goal was to open up the boxed-in area under the steps and provide adequate drainage and ventilation. I used new cedar wood for the steps and kept most of the design the same. The pre-cut staircase supports from the big-box stores would not have fit in the existing area…
This was a “by request” birdhouse for a local land trust. One requirement was that the birdhouse would be used to hold the solar panel which powered a pump in a bird fountain. The next request was to include three units instead of one to observe if more than one house might be used at…
This photo series shows how to create a small patio area with good drainage. A technique for a surrounding Zen rock garden is also shown.
Fieldstone pavilion made over several summers. Just about all of the work done by hand in the woods. Here is some captions that used to go along with the slideshow: The final product. Bonfire ready | Had help from some machinery to dig channels for the walls | Then I squared out the holes for the…