{"id":3047,"date":"2010-07-06T21:01:20","date_gmt":"2010-07-07T01:01:20","guid":{"rendered":"http:\/\/www.andysowards.com\/blog\/tech\/links-for-2010-07-06\/"},"modified":"2010-07-06T21:01:20","modified_gmt":"2010-07-07T01:01:20","slug":"links-for-2010-07-06","status":"publish","type":"post","link":"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/","title":{"rendered":"links for 2010-07-06"},"content":{"rendered":"<ul class=\"delicious\">\n<li>\n<div class=\"delicious-link\"><a href=\"http:\/\/net.tutsplus.com\/tutorials\/databases\/quick-tip-working-with-mysql-and-inner-join\/\">Quick Tip: Working with MySQL and INNER JOIN | Nettuts+<\/a><\/div>\n<div class=\"delicious-extended\">One of the most helpful functions of MySQL<\/div>\n<div class=\"delicious-tags\">(tags: <a href=\"http:\/\/delicious.com\/andysowards\/database\">database<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/howto\">howto<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/mysql\">mysql<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/nettuts\">nettuts<\/a>)<\/div>\n<\/li>\n<li>\n<div class=\"delicious-link\"><a href=\"http:\/\/net.tutsplus.com\/tutorials\/php\/increase-productivity-by-creating-php-helper-functions\/\">Increase Productivity by Creating PHP Helper Functions | Nettuts+<\/a><\/div>\n<div class=\"delicious-extended\">Everyone should be doing this &#8211; most programmers I know do it without even knowing it<\/div>\n<div class=\"delicious-tags\">(tags: <a href=\"http:\/\/delicious.com\/andysowards\/email\">email<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/helper\">helper<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/helpers\">helpers<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/toread\">toread<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/function\">function<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/functions\">functions<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/nettuts\">nettuts<\/a>)<\/div>\n<\/li>\n<li>\n<div class=\"delicious-link\"><a href=\"http:\/\/net.tutsplus.com\/articles\/web-roundups\/inspiration-the-top-35-musician-web-designs\/\">Inspiration: The Top 36 Musician Web Designs | Nettuts+<\/a><\/div>\n<div class=\"delicious-extended\">these rock (no pun intended)<\/div>\n<div class=\"delicious-tags\">(tags: <a href=\"http:\/\/delicious.com\/andysowards\/webdesign\">webdesign<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/musician\">musician<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/design\">design<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/inspiration\">inspiration<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/inspirations\">inspirations<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/music\">music<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/nettuts\">nettuts<\/a>)<\/div>\n<\/li>\n<li>\n<div class=\"delicious-link\"><a href=\"http:\/\/gizmodo.com\/5580240\/icon-phone-pares-the-humble-home-phone-right-down\">Icon Phone Pares the Humble Home Phone Right Down<\/a><\/div>\n<div class=\"delicious-extended\">Cool!!!!<\/div>\n<div class=\"delicious-tags\">(tags: <a href=\"http:\/\/delicious.com\/andysowards\/phones\">phones<\/a>)<\/div>\n<\/li>\n<li>\n<div class=\"delicious-link\"><a href=\"http:\/\/gizmodo.com\/5580588\/sht-my-kids-ruined-tech-edition\">Sh*t My Kids Ruined: Tech Edition<\/a><\/div>\n<div class=\"delicious-extended\">LOL Wow my kids aren&#039;t that bad<\/div>\n<\/li>\n<li>\n<div class=\"delicious-link\"><a href=\"http:\/\/www.impressivewebs.com\/ie-only-styles\/\">IE-only Styles: Where Should They Be Placed?<\/a><\/div>\n<div class=\"delicious-extended\">some good tips on standardizing your IE only stylesheets<\/div>\n<div class=\"delicious-tags\">(tags: <a href=\"http:\/\/delicious.com\/andysowards\/css3\">css3<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/hacks\">hacks<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/ie\">ie<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/ie6\">ie6<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/internetexplorer\">internetexplorer<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/tutorial\">tutorial<\/a>)<\/div>\n<\/li>\n<li>\n<div class=\"delicious-link\"><a href=\"http:\/\/www.smashingmagazine.com\/2010\/07\/06\/the-evolution-of-the-logo\/\">The Evolution of The Logo &#8211; Smashing Magazine<\/a><\/div>\n<div class=\"delicious-extended\">I always love watching how things change over time, especially logos<\/div>\n<div class=\"delicious-tags\">(tags: <a href=\"http:\/\/delicious.com\/andysowards\/design\">design<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/academic\">academic<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/article\">article<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/articles\">articles<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/brand\">brand<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/branding\">branding<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/brands\">brands<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/cool\">cool<\/a>)<\/div>\n<\/li>\n<li>\n<div class=\"delicious-link\"><a href=\"http:\/\/designshack.co.uk\/articles\/interviews\/quoterobot-freelance-job-quoting-made-easy\">QuoteRobot: Freelance Job Quoting Made Easy | Design Shack<\/a><\/div>\n<div class=\"delicious-extended\">Wow, this might be hella awesome. Quoting really does take a lot of time, for good quotes that is.<\/div>\n<div class=\"delicious-tags\">(tags: <a href=\"http:\/\/delicious.com\/andysowards\/business\">business<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/businesstools\">businesstools<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/invoicing\">invoicing<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/software\">software<\/a>)<\/div>\n<\/li>\n<li>\n<div class=\"delicious-link\"><a href=\"http:\/\/net.tutsplus.com\/tutorials\/databases\/introduction-to-mysql-views\/\">An Introduction to MySQL 5: Views | Nettuts+<\/a><\/div>\n<div class=\"delicious-extended\">Good intro to MySQL 5<\/div>\n<div class=\"delicious-tags\">(tags: <a href=\"http:\/\/delicious.com\/andysowards\/database\">database<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/development\">development<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/guide\">guide<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/programming\">programming<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/mysql\">mysql<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/introduction\">introduction<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/webdev\">webdev<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/tutorial\">tutorial<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/tips\">tips<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/sql\">sql<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/reference\">reference<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/views\">views<\/a>)<\/div>\n<\/li>\n<li>\n<div class=\"delicious-link\"><a href=\"http:\/\/carsonified.com\/blog\/business\/fred-wilson-on-10-ways-to-be-your-own-boss\/\">Fred Wilson on 10 Ways to Be Your Own Boss | Carsonified<\/a><\/div>\n<div class=\"delicious-extended\">Great video on Being your own boss<\/div>\n<div class=\"delicious-tags\">(tags: <a href=\"http:\/\/delicious.com\/andysowards\/articles\">articles<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/business\">business<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/career\">career<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/entrepreneurship\">entrepreneurship<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/freelance\">freelance<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/productivity\">productivity<\/a>)<\/div>\n<\/li>\n<li>\n<div class=\"delicious-link\"><a href=\"http:\/\/www.smashingmagazine.com\/2010\/07\/04\/add-music-to-your-workflow-to-improve-results\/\">Add Music To Your Workflow To Improve Results &#8211; Smashing Magazine<\/a><\/div>\n<div class=\"delicious-extended\">yeah I would probably never be creative without music \ud83d\ude42<\/div>\n<div class=\"delicious-tags\">(tags: <a href=\"http:\/\/delicious.com\/andysowards\/inspiration\">inspiration<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/marketing%2C\">marketing,<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/socialnetworking\">socialnetworking<\/a> <a href=\"http:\/\/delicious.com\/andysowards\/lifehacks\">lifehacks<\/a>)<\/div>\n<\/li>\n<li>\n<div class=\"delicious-link\"><a href=\"https:\/\/www.andysowards.com\/blog\/tech\/links-for-2010-07-05\/\">links for 2010-07-05 | AndySowards.com :: Daily Professional Web Design, Development, Programming Freelancer, Hacks, Downloads, Math and being a Web 2.0 Hipster?<\/a><\/div>\n<div class=\"delicious-extended\">ZURB \u2013 New way of UX Research = Remote. Learn from Nate Bolt. good read on UX Research<\/div>\n<div class=\"delicious-tags\">(tags: <a href=\"http:\/\/delicious.com\/andysowards\/ping.fm\">ping.fm<\/a>)<\/div>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Quick Tip: Working with MySQL and INNER JOIN | Nettuts+ One of the most helpful functions of MySQL (tags: database howto mysql nettuts) Increase Productivity by Creating PHP Helper Functions<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[106],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>links for 2010-07-06<\/title>\n<meta name=\"description\" content=\"Quick Tip: Working with MySQL and INNER JOIN | Nettuts+ One of the most helpful functions of MySQL (tags: database howto mysql nettuts) Increase\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"links for 2010-07-06\" \/>\n<meta property=\"og:description\" content=\"Quick Tip: Working with MySQL and INNER JOIN | Nettuts+ One of the most helpful functions of MySQL (tags: database howto mysql nettuts) Increase\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/\" \/>\n<meta property=\"og:site_name\" content=\"Daily Business Resources for Entrepreneurs, Web Designers, &amp; Creatives by Andy Sowards\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/facebook.com\/andysowardsfan\" \/>\n<meta property=\"article:published_time\" content=\"2010-07-07T01:01:20+00:00\" \/>\n<meta name=\"author\" content=\"Andy Sowards\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@andysowards\" \/>\n<meta name=\"twitter:site\" content=\"@andysowards\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andy Sowards\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/\",\"url\":\"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/\",\"name\":\"links for 2010-07-06\",\"isPartOf\":{\"@id\":\"https:\/\/www.andysowards.com\/blog\/#website\"},\"datePublished\":\"2010-07-07T01:01:20+00:00\",\"dateModified\":\"2010-07-07T01:01:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.andysowards.com\/blog\/#\/schema\/person\/2e0f72bd7f6497fd883e2bd67d9f3415\"},\"description\":\"Quick Tip: Working with MySQL and INNER JOIN | Nettuts+ One of the most helpful functions of MySQL (tags: database howto mysql nettuts) Increase\",\"breadcrumb\":{\"@id\":\"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.andysowards.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"links for 2010-07-06\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.andysowards.com\/blog\/#website\",\"url\":\"https:\/\/www.andysowards.com\/blog\/\",\"name\":\"Daily Business Resources for Entrepreneurs, Web Designers, &amp; Creatives by Andy Sowards\",\"description\":\"Design Inspiration &amp; Business Resources for Creatives\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.andysowards.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.andysowards.com\/blog\/#\/schema\/person\/2e0f72bd7f6497fd883e2bd67d9f3415\",\"name\":\"Andy Sowards\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.andysowards.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15f95b011563b5894883b22bd4b32d59?s=96&r=pg\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15f95b011563b5894883b22bd4b32d59?s=96&r=pg\",\"caption\":\"Andy Sowards\"},\"description\":\"Im a professional Freelancer specializing in Web Developer, Design, Programming web applications. Im an Avid member of the Design\/Development community and a Serial Blogger. follow me on Twitter @AndySowards\",\"sameAs\":[\"https:\/\/www.andysowards.com\"],\"url\":\"https:\/\/www.andysowards.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"links for 2010-07-06","description":"Quick Tip: Working with MySQL and INNER JOIN | Nettuts+ One of the most helpful functions of MySQL (tags: database howto mysql nettuts) Increase","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/","og_locale":"en_US","og_type":"article","og_title":"links for 2010-07-06","og_description":"Quick Tip: Working with MySQL and INNER JOIN | Nettuts+ One of the most helpful functions of MySQL (tags: database howto mysql nettuts) Increase","og_url":"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/","og_site_name":"Daily Business Resources for Entrepreneurs, Web Designers, &amp; Creatives by Andy Sowards","article_publisher":"http:\/\/facebook.com\/andysowardsfan","article_published_time":"2010-07-07T01:01:20+00:00","author":"Andy Sowards","twitter_card":"summary_large_image","twitter_creator":"@andysowards","twitter_site":"@andysowards","twitter_misc":{"Written by":"Andy Sowards","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/","url":"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/","name":"links for 2010-07-06","isPartOf":{"@id":"https:\/\/www.andysowards.com\/blog\/#website"},"datePublished":"2010-07-07T01:01:20+00:00","dateModified":"2010-07-07T01:01:20+00:00","author":{"@id":"https:\/\/www.andysowards.com\/blog\/#\/schema\/person\/2e0f72bd7f6497fd883e2bd67d9f3415"},"description":"Quick Tip: Working with MySQL and INNER JOIN | Nettuts+ One of the most helpful functions of MySQL (tags: database howto mysql nettuts) Increase","breadcrumb":{"@id":"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.andysowards.com\/blog\/2010\/links-for-2010-07-06\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.andysowards.com\/blog\/"},{"@type":"ListItem","position":2,"name":"links for 2010-07-06"}]},{"@type":"WebSite","@id":"https:\/\/www.andysowards.com\/blog\/#website","url":"https:\/\/www.andysowards.com\/blog\/","name":"Daily Business Resources for Entrepreneurs, Web Designers, &amp; Creatives by Andy Sowards","description":"Design Inspiration &amp; Business Resources for Creatives","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.andysowards.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.andysowards.com\/blog\/#\/schema\/person\/2e0f72bd7f6497fd883e2bd67d9f3415","name":"Andy Sowards","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.andysowards.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15f95b011563b5894883b22bd4b32d59?s=96&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15f95b011563b5894883b22bd4b32d59?s=96&r=pg","caption":"Andy Sowards"},"description":"Im a professional Freelancer specializing in Web Developer, Design, Programming web applications. Im an Avid member of the Design\/Development community and a Serial Blogger. follow me on Twitter @AndySowards","sameAs":["https:\/\/www.andysowards.com"],"url":"https:\/\/www.andysowards.com\/blog\/author\/admin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.andysowards.com\/blog\/wp-json\/wp\/v2\/posts\/3047"}],"collection":[{"href":"https:\/\/www.andysowards.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.andysowards.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.andysowards.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.andysowards.com\/blog\/wp-json\/wp\/v2\/comments?post=3047"}],"version-history":[{"count":0,"href":"https:\/\/www.andysowards.com\/blog\/wp-json\/wp\/v2\/posts\/3047\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.andysowards.com\/blog\/wp-json\/wp\/v2\/media?parent=3047"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.andysowards.com\/blog\/wp-json\/wp\/v2\/categories?post=3047"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.andysowards.com\/blog\/wp-json\/wp\/v2\/tags?post=3047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}