{"id":886,"date":"2010-09-23T22:29:45","date_gmt":"2010-09-24T02:29:45","guid":{"rendered":"http:\/\/vapingguides.com\/blog\/?page_id=886"},"modified":"2011-08-30T08:46:45","modified_gmt":"2011-08-30T12:46:45","slug":"recommended-suppliers-dynamic-2","status":"publish","type":"page","link":"http:\/\/vapingguides.com\/blog\/recommended-suppliers-dynamic-2\/","title":{"rendered":"Favorite Suppliers"},"content":{"rendered":"<h2><strong>Kits, parts, e-liquid, etc.<\/strong><\/h2>\n<p>This list represents a number of Eric&#8217;s and Don&#8217;s <em>personal<\/em> favorite electronic cigarette suppliers, who have provided us many hours of vaping pleasure. They are <em>some<\/em> of the really good ones &#8230; but there are dozens of others as well.<\/p>\n<p>The icons identify what types of vaping supplies are available from each. (Roll over each icon for an explanation.)<\/p>\n<p><?php\n\/\/ open the connection\n$con = mysql_connect(\"db2518.perfora.net\", \"dbo334714099\", \"P455word\") or die(mysql_error());\n\/\/ pick the database to use\nmysql_select_db(\"db334714099\",$con) or die (mysql_error());\n\/\/create the SQL statement\n\/\/ Get all the data from the \"example\" table\n$result = mysql_query(\"SELECT * FROM rec_suppliers ORDER BY Name ASC\") \nor die(mysql_error());  \n\n\n\n\/\/ Begin table\necho \"\n\n<table border='1'>&#8220;;<\/p>\n<p>\/\/ keeps getting the next row until there are no more to get<br \/>\nwhile($row = mysql_fetch_array( $result )) {<\/p>\n<p>\/\/ Define variables<br \/>\n        $_name = $row[&#8216;Name&#8217;];<br \/>\n        $_address = $row[&#8216;Address&#8217;];<br \/>\n        $_address2 = $row[&#8216;Link&#8217;];<br \/>\n        if ( $_address2 == &#8220;&#8221; ) {<br \/>\n        $_link = &#8220;<a href = 'http:\/\/\" . $_address . \"' target='blank'>&#8221; . $_address . &#8220;<\/a>&#8220;;<br \/>\n        } else {<br \/>\n        $_link = &#8220;<a href = 'http:\/\/\" . $_address2 . \"' target='blank'>&#8221; . $_address . &#8220;<\/a>&#8220;;<br \/>\n        }<\/p>\n<p>\/\/ Print out the contents of each row into a table<\/p>\n<p>echo &#8220;<\/p>\n<tr>\n<td>&#8220;;<br \/>\n\tif ($row[&#8216;Kits&#8217;] == &#8220;1&#8221;) {<br \/>\n\t\t\t echo &#8220;<img class='size-full wp-image-821 alignnone' title='Kits, parts, and accessories'         src='http:\/\/vapingguides.com\/blog\/wp-content\/uploads\/2010\/09\/kit-icon_24.gif' alt='Kits, parts and accessories' width='24' height='24' \/>&#8220;;<br \/>\n\t\t\t } else {<br \/>\n\t\t\t echo &#8220;<img class='size-full wp-image-824 alignnone' title='blank_24' src='http:\/\/vapingguides.com\/blog\/wp-content\/uploads\/2010\/09\/blank_24.gif' alt='' width='24' height='24' \/>&#8220;;<br \/>\n\t\t\t }<br \/>\n\techo &#8220;<\/td>\n<td>&#8220;;<br \/>\n\tif ($row[&#8216;Liquid&#8217;] == &#8220;1&#8221;) {<br \/>\n\t\t\t echo &#8220;<img class='size-full wp-image-821 alignnone' title='E-liquid' src='http:\/\/vapingguides.com\/blog\/wp-content\/uploads\/2010\/09\/liquid-icon_24.gif' alt='E-liquid' width='24' height='24' \/>&#8220;;<br \/>\n\t\t\t } else {<br \/>\n\t\t\t echo &#8220;<img class='size-full wp-image-824 alignnone' title='blank_24' src='http:\/\/vapingguides.com\/blog\/wp-content\/uploads\/2010\/09\/blank_24.gif' alt='' width='24' height='24' \/>&#8220;;<br \/>\n\t\t\t }<br \/>\n\techo &#8220;<\/td>\n<td>&#8220;;<br \/>\n\t\tif ($row[&#8216;Diy&#8217;] == &#8220;1&#8221;) {<br \/>\n\t\t\t echo &#8220;<img class='size-full wp-image-821 alignnone' title='DIY E-liquid' src='http:\/\/vapingguides.com\/blog\/wp-content\/uploads\/2010\/09\/diy-icon_24.gif' alt='DIY E-liquid' width='24' height='24' \/>&#8220;;<br \/>\n\t\t\t } else {<br \/>\n\t\t\t echo &#8220;<img class='size-full wp-image-824 alignnone' title='blank_24' src='http:\/\/vapingguides.com\/blog\/wp-content\/uploads\/2010\/09\/blank_24.gif' alt='' width='24' height='24' \/>&#8220;;<br \/>\n\t\t\t }<br \/>\n\techo &#8220;<\/td>\n<td>&#8220;;<br \/>\n\tif ($row[&#8216;Mod&#8217;] == &#8220;1&#8221;) {<br \/>\n\t\t\t echo &#8220;<img class='size-full wp-image-821 alignnone' title='Modding parts' src='http:\/\/vapingguides.com\/blog\/wp-content\/uploads\/2010\/09\/mod-icon_24.gif' alt='Modding parts' width='24' height='24' \/>&#8220;;<br \/>\n\t\t\t } else {<br \/>\n\t\t\t echo &#8220;<img class='size-full wp-image-824 alignnone' title='blank_24' src='http:\/\/vapingguides.com\/blog\/wp-content\/uploads\/2010\/09\/blank_24.gif' alt='' width='24' height='24' \/>&#8220;;<br \/>\n\t\t\t }<br \/>\n\techo &#8220;<\/td>\n<td>&#8220;;<\/p>\n<p>\techo $_name;<br \/>\n\techo &#8220;<\/td>\n<td>&#8220;;<br \/>\n\techo $_link;<br \/>\n\techo &#8220;<\/td>\n<\/tr>\n<p>&#8220;;<br \/>\n} <\/p>\n<p>echo &#8220;<\/table>\n<p>&#8220;;<br \/>\n?><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kits, parts, e-liquid, etc. This list represents a number of Eric&#8217;s and Don&#8217;s personal favorite electronic cigarette suppliers, who have provided us many hours of vaping pleasure. They are some of the really good ones &#8230; but there are dozens of others as well. The icons identify what types of vaping supplies are available from [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"http:\/\/vapingguides.com\/blog\/wp-json\/wp\/v2\/pages\/886"}],"collection":[{"href":"http:\/\/vapingguides.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/vapingguides.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/vapingguides.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/vapingguides.com\/blog\/wp-json\/wp\/v2\/comments?post=886"}],"version-history":[{"count":67,"href":"http:\/\/vapingguides.com\/blog\/wp-json\/wp\/v2\/pages\/886\/revisions"}],"predecessor-version":[{"id":936,"href":"http:\/\/vapingguides.com\/blog\/wp-json\/wp\/v2\/pages\/886\/revisions\/936"}],"wp:attachment":[{"href":"http:\/\/vapingguides.com\/blog\/wp-json\/wp\/v2\/media?parent=886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}