The Leonard Lopate Show – The Rise and Fall of a Typesetter
David Silverman bought a typesetting company in Iowa, made 4 million dollars, and then lost it all. He tells his saga of failed entrepreneurship in his new book, Typo.
Typo: The Last American Typesetter or How I Made and Lost 4 Million Dollars
Excellent interview by Leonard Lopate on WNYC : http://www.wnyc.org/shows/lopate/episodes/2007/07/09/segments/81723
Web Standards Creativity: Innovations in Web Design with XHTML, CSS, and DOM Scripting
From the book’s description:
… we got together ten of the world’s most talented web designers to share their secrets with you. Web Standards Creativity is jam-packed with fresh, innovative design ideas. The topics range from essential CSS typography and grid design, effective styling for CMS-driven sites, and astonishing PNG transparency techniques, to DOM scripting magic for creating layouts that change depending on browser resolution and user preference, and better print layouts for web pages…
What’s with all the dead trees? Sometimes you can’t beat the feel of a book in your hand, or gracing your coffee table – as this gorgeous full color softcover is well equipped to do. Real world examples provide insight, instruction and most of all inspiration. The articles are well written and illustrated. If you need something to inspire you to start innovating with XHTML, CSS and DOM Scripting – this is the book! Highly recommended.
Web Standards Creativity: Innovations in Web Design with XHTML, CSS, and DOM Scripting
Sometimes you need a good clean logo of a major brand, for completely legit usage. Maybe the local Ford dealership is sponsoring a local event, and the organizers are having you create a flyer that needs the Ford logo on it. Calling Ford’s marketing department for clean artwork will probably get you nowhere, and chances are the dealership won’t know an EPS file from a hole in the ground. So what do you do?
Here’s a Web site stocked with clean vector artwork of major brands, all available for download : http://www.brandsoftheworld.com
I recently added a new page in WordPress to contain Google search results within the site. I did not want this page to appear in my top menu however which is automatically generated by the template. This page in the WordPress Codex shows how to work with the template tag “wp_list_pages” to exclude certain pages from being listed by id.
http://codex.wordpress.org/Template_Tags/wp_list_pages#Exclude_Pages_from_List
Use absolute positioning and negative margins to get that box centered vertically! You must declare the height of the DIV you are centering, as your negative top margin will be half of this value.
Example here : http://greystonbakery.com/
div#landing-wrapper {
margin-left:-324px;
margin-top: -222px;
position:absolute;
top: 50%;
left: 50%;
width:648px;
height:444px;
}
Needed to pull rows from a MySQL database, selecting by month, using the MONTH() and YEAR() functions to extract from the datetime stamp. Following returns all records for the month of January, 2007.
SELECT * FROM table WHERE MONTH(datetimefield) = '1' AND YEAR(datetimefield) = '2007'
Or for more detailed date range control, use the DATE() function to extract the date. Returns all records between two dates.
SELECT * FROM table WHERE DATE(datetimefield) BETWEEN 'YYYY-MM-DD' AND 'YYYY-MM-DD'
MySQL manual documentation of date and time functions here http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html.
