<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-5409651822142154476</id><updated>2011-11-27T17:38:30.115-08:00</updated><category term='PHP'/><category term='Driver'/><category term='Internet'/><category term='MS Access'/><category term='Database'/><category term='OS'/><category term='MS Excel'/><category term='HTML'/><title type='text'>EXEmedia</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>14</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-3279647620219726806</id><published>2008-10-07T17:58:00.000-07:00</published><updated>2008-10-07T18:52:55.784-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='HTML'/><title type='text'>How to indent the first line in paragraphs using HTML</title><content type='html'>Indenting paragraphs can be done in several ways.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Cascading Style Sheets&lt;span style="font-weight: bold;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;Using CSS, you can set all your paragraphs in a document to be indented whatever amount you would wish.&lt;br /&gt;&lt;blockquote class="yes"&gt;&lt;br /&gt;&amp;lt;style&amp;gt;&lt;br /&gt;&amp;lt;!--&lt;br /&gt;  p { text-indent : 10px; }&lt;br /&gt;--&amp;gt;&lt;br /&gt;&amp;lt;/style&amp;gt;&lt;br /&gt;&lt;/blockquote&gt;&lt;br /&gt;This is the best way to indent paragraphs, as it separates style from content and is widely supported on modern browsers.&lt;br /&gt;&lt;span class="fullpost"&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Non-Breaking Space&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;The non-breaking space special character can be used to move text and images over slightly on a Web page.&lt;br /&gt;&lt;blockquote class="yes"&gt;&lt;br /&gt;&amp;lt;p&amp;gt;&lt;br /&gt;&amp;amp; nbsp; &amp;amp; nbsp; &amp;amp; nbsp; &amp;amp; nbsp; Paragraph starts here....&lt;br /&gt;&amp;lt;/p&amp;gt;&lt;br /&gt;&lt;/blockquote&gt;&lt;br /&gt;&lt;p&gt;&lt;i&gt;Remove the spaces between the ampersand and the "nbsp;".&lt;/i&gt;&lt;br /&gt;&lt;/p&gt;&lt;br /&gt;Some browsers don't like multiple non-breaking spaces in a row. They will crash, or just ignore them.&lt;br /&gt;&lt;h3&gt;Transparent Image&lt;/h3&gt;&lt;br /&gt;Use a transparent GIF image, no more than 5-10 pixels wide and 2-5 pixels high. Place that image at the beginning of each of your paragraphs.&lt;br /&gt;&lt;blockquote class="yes"&gt;&lt;br /&gt;&amp;lt;p&amp;gt;&lt;br /&gt;&amp;lt;img src="spacer.gif" width="1" height="1" border="0" style="margin: 0 5px 0 5px;" alt=" " /&amp;gt;Paragraph starts here....&lt;br /&gt;&amp;lt;/p&amp;gt;&lt;br /&gt;&lt;/blockquote&gt;&lt;br /&gt;Using this method can make your  pages load more slowly, and look strange if the image doesn't load for some reason.&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;p&gt;&lt;br /&gt;From: &lt;a href="http://webdesign.about.com/od/faqsandhelp/f/bl_faq5_3a.htm"&gt;webdesign.about.com&lt;/a&gt;&lt;br /&gt;&lt;/p&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-3279647620219726806?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/3279647620219726806/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/10/how-to-indent-first-line-in-paragraphs.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/3279647620219726806'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/3279647620219726806'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/10/how-to-indent-first-line-in-paragraphs.html' title='How to indent the first line in paragraphs using HTML'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-7335497290584204496</id><published>2008-10-05T01:20:00.001-07:00</published><updated>2008-10-05T01:59:17.529-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Internet'/><title type='text'>Free cPanel Web Hosting with PHP5/Mysql - no advertising</title><content type='html'>&lt;center&gt;&lt;br /&gt;&lt;a href="http://www.000webhost.com/82961.html" onClick="this.href='http://www.000webhost.com/82961.html'" target="_blank"&gt;&lt;img src="http://www.000webhost.com/images/banners/468x60/banner6.gif" alt="Free Web Hosting with Website Builder" width="468" height="60" border="0" /&gt;&lt;/a&gt;&lt;/center&gt;&lt;br /&gt;If you wish to have a professional shared hosting quality in a free hosting package, come and host with &lt;a href="http://www.000webhost.com/82961.html"&gt;000webhost.com&lt;/a&gt; and experience the best service you can get absolutely free.&lt;br /&gt;&lt;br /&gt;Founded in December 2006, &lt;a href="http://www.000webhost.com/82961.html"&gt;000webhost.com&lt;/a&gt; has a trusted free hosting members base of over 60,000 members and still counting! Offering professional quality hosting, support, uptime and reliability, we have a great community of webmasters, you'd love to be a part of!&lt;br /&gt;&lt;br /&gt;&lt;span class="fullpost"&gt;Register now and get it all free:&lt;br /&gt;*** 350 MB of disk space&lt;br /&gt;*** 100 GB of data transfer&lt;br /&gt;*** PHP and MySQL support with no restrictions&lt;br /&gt;*** cPanel control panel&lt;br /&gt;*** Website Builder&lt;br /&gt;*** Absolutely no advertising!&lt;br /&gt;&lt;br /&gt;&lt;a href="http://www.000webhost.com/82961.html"&gt;&lt;span style="font-weight: bold;"&gt;JOIN NOW&lt;/span&gt;&lt;/a&gt;!&lt;br /&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-7335497290584204496?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/7335497290584204496/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/10/free-cpanel-web-hosting-with-php5mysql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/7335497290584204496'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/7335497290584204496'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/10/free-cpanel-web-hosting-with-php5mysql.html' title='Free cPanel Web Hosting with PHP5/Mysql - no advertising'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-4110661023957556127</id><published>2008-09-23T20:54:00.001-07:00</published><updated>2008-09-23T23:17:40.738-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Internet'/><title type='text'>Free file hosting</title><content type='html'>&lt;a href="http://uploads.bizhat.com/signup.php?ref=bahtiar"&gt;&lt;img src="http://adserver.bizhat.com/banners/uploads_3.gif" width="468" height="60" border="0"&gt;&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-4110661023957556127?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/4110661023957556127/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/09/free-file-hosting.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/4110661023957556127'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/4110661023957556127'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/09/free-file-hosting.html' title='Free file hosting'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-6619185771862442683</id><published>2008-09-16T18:37:00.000-07:00</published><updated>2008-09-23T23:12:36.071-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Driver'/><title type='text'>Audio and Modem's driver of Compaq V3360</title><content type='html'>Have problems in installing drivers of HP Compaq V3360? I got that problem when I reformated myV3360 even have the original CD of myV3360. Here are the drivers that I split with winrar into 6 parts: &lt;br /&gt;&lt;span class="fullpost"&gt;&lt;br /&gt;- &lt;a href="http://uploads.bizhat.com/file/332241"&gt;Audio and Modem Driver of V3660 Part 1&lt;/a&gt;&lt;br /&gt;- &lt;a href="http://uploads.bizhat.com/file/332243"&gt;Audio and Modem Driver of V3660 Part 2&lt;/a&gt;&lt;br /&gt;- &lt;a href="http://uploads.bizhat.com/file/332242"&gt;Audio and Modem Driver of V3660 Part 3&lt;/a&gt;&lt;br /&gt;- &lt;a href="http://uploads.bizhat.com/file/332247"&gt;Audio and Modem Driver of V3660 Part 4&lt;/a&gt;&lt;br /&gt;- &lt;a href="http://uploads.bizhat.com/file/332258"&gt;Audio and Modem Driver of V3660 Part 5&lt;/a&gt;&lt;br /&gt;- &lt;a href="http://uploads.bizhat.com/file/332248"&gt;Audio and Modem Driver of V3660 Part 6&lt;/a&gt;&lt;br /&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-6619185771862442683?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/6619185771862442683/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/09/driver-audio-and-modems-driver-of.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/6619185771862442683'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/6619185771862442683'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/09/driver-audio-and-modems-driver-of.html' title='Audio and Modem&apos;s driver of Compaq V3360'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-8715040092433532223</id><published>2008-08-25T18:22:00.000-07:00</published><updated>2008-09-23T23:13:48.803-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='OS'/><title type='text'>Recovering a slow computer</title><content type='html'>To get your computer back in top shape, do the following - in order (try not to skip) - and I will not bore you with the technical details as to why you should do these steps, in this sequence:&lt;br /&gt;&lt;br /&gt;1. Disk Cleanup:  Check how much disk space you have left on your primary "C" drive.  You should have at least 1 GB, or more.  If you have less than this, your computer will be as slow as a snail.  &lt;br /&gt;&lt;br /&gt;To quickly free up some disk space, do a global search (from the Start/Search menu on your computer) for your children's MP3 and video files (usually files ending in *.avi, *.mpg or *.wmv).  These files will be huge (many Gigabytes in size), and deleting a few of these files will greatly speed up your PC - if you PC is already low on disk space (that is under 1 GB).&lt;br /&gt;  &lt;br /&gt;&lt;span class="fullpost"&gt;2. Run Microsoft Scan Disk and Microsoft Defragmenter.  They are both built into Windows and are 100% free.&lt;br /&gt;&lt;br /&gt;Scan Disk will fix any soft disk errors that are interrupting normal computer operations.  Here are some step-by-step details on how to run Scan Disk, in case you need further details on how to launch this great utility program.&lt;br /&gt;Here is an image of the Windows Check Disk interface (also called Scan Disk):&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_LUXyf14Cvtk/SLOvhay8wWI/AAAAAAAAAB8/7iUlHgAK48E/s1600-h/diskcheck0uo.gif"&gt;&lt;img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="http://3.bp.blogspot.com/_LUXyf14Cvtk/SLOvhay8wWI/AAAAAAAAAB8/7iUlHgAK48E/s400/diskcheck0uo.gif" border="0" alt=""id="BLOGGER_PHOTO_ID_5238723780225581410" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;3. Check for a virus, and use a good virus program.  Do not use a no-name brand software, since there are several well known trial anti-virus software on the market. Check out this recommended  anti-virus software, on the link just mentioned.   &lt;br /&gt;&lt;br /&gt;Download the software now and start protecting yourself.  Installing this software is something you should do without thinking or hesitating - you need it.  I guarantee it.&lt;br /&gt;  &lt;br /&gt;4. Check for spyware and adware on your PC.  It is not enough to have a good anti-virus software.  You need both a good anti-spyware and anti-virus software.  They do different things.&lt;br /&gt;&lt;br /&gt;There are several good anti-spyware software on the market. Download a free trial version of this recommended anti-spyware software.  It will find infections spyware and ad-ware that might be messing with your computer.  Some estimates say 90% of computers have spyware - most often without your knowledge!  &lt;br /&gt;Get rid of these pests and download the free software just mentioned.  Your computer will be glad you did, and it will run faster.&lt;br /&gt; &lt;br /&gt;5. Check and cleanup your Windows System Registry.  This is one of the most important system files on your computer, and cleaning up the settings in this file can make a big difference in the amount of errors and speed of your computer. &lt;br /&gt;The problems with the system registry can occur for many reasons, including:&lt;br /&gt;&lt;br /&gt;files being left-behind after the un-installation, or &lt;br /&gt;incorrect removal of software, or &lt;br /&gt;by missing or corrupt hardware drivers, or &lt;br /&gt;by orphaned startup programs and DLL files. &lt;br /&gt;To ensure system integrity of this most important Windows systems file on your computer; check this Windows Registry file with the excellent and easy to use software package for this purpose.  You can download our recommended Windows Registry Cleaner here.&lt;br /&gt;&lt;br /&gt;By using the registry cleaner regularly and fixing your registry, your system should be more stable - and it will help Windows and your software to run faster. &lt;br /&gt;&lt;br /&gt;6. Remove unwanted startup programs&lt;br /&gt;&lt;br /&gt;Windows takes a long time to load on most computers because a bunch of software that is set to start automatically. To remove these programs in Windows, you simple go to the Start button, chose "Run" and typed "MSCONFIG" (no quotes.)&lt;br /&gt;&lt;br /&gt;In the "Startup" tab in program there will be a list of startup program. However, this list isn't very human-readable, but you can make some educated guesses about what is necessary and what was not.  If you make a mistake, you can come back and add the program back in.&lt;br /&gt;&lt;br /&gt;Another option - that I really like - is to download this totally free utility startup manager.  This software works great and does not cause strange messages to appear at boot time, like when you use MSCONFIG.   You can download it from here: &lt;br /&gt;&lt;br /&gt;Download Startup Control Panel 2.8&lt;br /&gt;&lt;br /&gt;That is it.  Your computer should now be in the best shape ever!&lt;br /&gt;&lt;br /&gt;You can get real complicated about this process, but there is no need.  Install the above software utilities and enjoy your life instead!&lt;br /&gt;&lt;br /&gt;And, do not search all over the Internet for free software that make big claims about this or that.  I have tried most of them, and the steps above will solve most - if not all - of your problems.&lt;br /&gt;&lt;br /&gt;Some programs are offering a "free" service, but in the best case some of these programs do very little (in terms of protection), and in the worst case they actually install additional adware (computer infections) on your computer.  Here is a list of more than 200 bogus spyware products that do just this, if you don't believe me.  Nasty...&lt;br /&gt;&lt;br /&gt;The software programs I recommend on this web page are all tried and tested, and I use them personally on my own computer.  They are totally safe and do not add additional problems to your computer.  I stand by my word, and you can email me personally if you have any doubts about what I say.&lt;br /&gt;&lt;br /&gt;Once you do 'all' the above steps, your computer should be "like-new" again.&lt;br /&gt;&lt;br /&gt;Nils Rognerud&lt;br /&gt;&lt;br /&gt;source: &lt;a href="http://www.computerrecover.com/slow-computer/speed-up-my-computer.html"&gt;ComputerRecover.com&lt;/a&gt;&lt;br /&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-8715040092433532223?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/8715040092433532223/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/08/recovering-slow-computer.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/8715040092433532223'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/8715040092433532223'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/08/recovering-slow-computer.html' title='Recovering a slow computer'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://3.bp.blogspot.com/_LUXyf14Cvtk/SLOvhay8wWI/AAAAAAAAAB8/7iUlHgAK48E/s72-c/diskcheck0uo.gif' height='72' width='72'/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-3803371537119744403</id><published>2008-08-18T22:37:00.000-07:00</published><updated>2009-01-08T16:48:26.779-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='MS Access'/><title type='text'>Make header row number in report 2</title><content type='html'>Just follow the steps of the &lt;a href="http://exemedia.blogspot.com/2008/08/make-header-row-number-in-report-of-ms.html"&gt;previous posting&lt;/a&gt;, except the last step.&lt;br /&gt;In the properties window of the textbox, type &lt;span style="font-weight:bold;"&gt;=1&lt;/span&gt; in &lt;span style="font-weight:bold;"&gt;Current Record&lt;/span&gt; and change the value of &lt;span style="font-weight:bold;"&gt;Running Sum &lt;/span&gt; to &lt;span style="font-weight:bold;"&gt;Over Group&lt;/span&gt; or &lt;span style="font-weight:bold;"&gt;Over All&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_LUXyf14Cvtk/SKpeVlUZ65I/AAAAAAAAAB0/57wSHR1I_wA/s1600-h/curentrecord04.JPG"&gt;&lt;img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="http://4.bp.blogspot.com/_LUXyf14Cvtk/SKpeVlUZ65I/AAAAAAAAAB0/57wSHR1I_wA/s400/curentrecord04.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5236101241659583378" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;source: &lt;a href="http://www.programindo.com"&gt;www.programindo.com&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-3803371537119744403?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/3803371537119744403/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/08/make-header-row-number-in-report-of-ms_18.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/3803371537119744403'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/3803371537119744403'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/08/make-header-row-number-in-report-of-ms_18.html' title='Make header row number in report 2'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://4.bp.blogspot.com/_LUXyf14Cvtk/SKpeVlUZ65I/AAAAAAAAAB0/57wSHR1I_wA/s72-c/curentrecord04.JPG' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-6206355934351609220</id><published>2008-08-18T21:53:00.000-07:00</published><updated>2009-01-08T16:47:49.875-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='MS Access'/><title type='text'>Make header row number in  report 1</title><content type='html'>Working in a Report, sometimes we need an autonumber in a report as header of row.&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_LUXyf14Cvtk/SKpajYnO3RI/AAAAAAAAABs/9h_k1xoTyDQ/s1600-h/curentrecord01.JPG"&gt;&lt;img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="http://4.bp.blogspot.com/_LUXyf14Cvtk/SKpajYnO3RI/AAAAAAAAABs/9h_k1xoTyDQ/s400/curentrecord01.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5236097080720547090" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;To do that, just put a textbox report tools in report.&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_LUXyf14Cvtk/SKpYEHy2wNI/AAAAAAAAABc/UXgn0wU1SQg/s1600-h/curentrecord02.JPG"&gt;&lt;img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="http://3.bp.blogspot.com/_LUXyf14Cvtk/SKpYEHy2wNI/AAAAAAAAABc/UXgn0wU1SQg/s400/curentrecord02.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5236094344606695634" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Click the textbox, then click DATA tab in properties window&lt;br /&gt;Click &lt;span style="font-weight:bold;"&gt;Record Source&lt;/span&gt;, then type&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;=[CurrentRecord]&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_LUXyf14Cvtk/SKpZJo8PFOI/AAAAAAAAABk/J_H2YdWWeek/s1600-h/curentrecord03.JPG"&gt;&lt;img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="http://2.bp.blogspot.com/_LUXyf14Cvtk/SKpZJo8PFOI/AAAAAAAAABk/J_H2YdWWeek/s400/curentrecord03.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5236095538915382498" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Source: &lt;a href="http://www.programindo.com"&gt;www.programindo.com&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-6206355934351609220?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/6206355934351609220/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/08/make-header-row-number-in-report-of-ms.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/6206355934351609220'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/6206355934351609220'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/08/make-header-row-number-in-report-of-ms.html' title='Make header row number in  report 1'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://4.bp.blogspot.com/_LUXyf14Cvtk/SKpajYnO3RI/AAAAAAAAABs/9h_k1xoTyDQ/s72-c/curentrecord01.JPG' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-5845011574805375666</id><published>2008-08-18T19:29:00.000-07:00</published><updated>2008-09-23T23:15:50.553-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='MS Excel'/><title type='text'>MATCH Function</title><content type='html'>Excel offers a function for finding specific data in column or row called MATCH. This function will allow you to find the location within an array, versus the LOOKUP functions that provide information related to the data you are seeking but in another column or row (you can use the LOOKUP function to return values in the same column or row, but the MATCH function shortens it a bit).&lt;br /&gt;&lt;br /&gt;The format of the MATCH function is:&lt;br /&gt;&lt;br /&gt;=MATCH(lookup_value,lookup_array,match_type).&lt;br /&gt;&lt;br /&gt;The lookup_value is the item you want to find within the lookup_array, like finding "apple" in a range of fruits or "green" in a list of colors. The match_type can be 1, 0 or 1. If the match_type is left blank, then it is assumed to equal 1. By using 1, MATCH will return the exact value or the value that is the largest value less than the specific item for which you are searching. In this case, the array must be in ascending order. Conversely, using -1 will provide he value that is immediately larger than the item for which you are searching, if no exact value exists. If you use -1, the array must be in descending order. If the match_type is 0, only an exact match is accepted, and if no exact match is available, #N/A! is returned. With match_type set to 0, the array can be in any order.&lt;br /&gt;&lt;br /&gt;The order is important, because the 1 or -1 is dependent on how the data is presented. If, for example, you have a range of data in a non-sequential order, you will get the wrong answer. Let's assume that the array contains the following data:&lt;br /&gt;&lt;br /&gt;1, 4, 7, 2, 21, 14, 5, 32, 6.&lt;br /&gt;&lt;br /&gt;If you enter the formula =MATCH(6,{1, 4, 7, 2, 21, 14, 5, 32, 6}), you will get the answer 2. Clearly there is a number 6 at the end of the array, but because it is not an exact search and the data is not in order, the MATCH formula produces an answer you do not want. If you modify the formula to read =MATCH(6,{1, 4, 7, 2, 21, 14, 5, 32, 6},0), the answer will be 9, which is the correct location. So remember that for a NON-exact search, the order is imperative.&lt;br /&gt;&lt;br /&gt;Once I learned to better incorporate the lookup functions, the MATCH function lost its relevance for many applications. In addition, when counting and summing, the array multiplication formulas work much better, and I will be discussing that in later articles. The point is that MATCH is good for a very limited set of basic inquiries, but ultimately, it is likely easily replaced by LOOKUP or other means. For now, it is a decent way to familiarize with the methodology Excel uses.&lt;br /&gt;&lt;br /&gt;Finally, another formula used to determine the exact match that the MATCH formula uses, is, not surprisingly, EXACT. The format for this formula is = EXACT(text1,text2). This formula is not case sensitive, and straightforward in construct. This is another formula that is not entirely useful in most instances, because the double equal sign (= =) accomplishes the same result. For example, =EXACT(A1,B1) is the same as the formula =A1= = B1. Thus, the latter is as easy to use as the actual EXACT formula. The only rationale for mentioning this formula is to remind you that there are a myriad of formulas Excel provides, but some that may never be used or are easily replaced by better, more flexible formulas. The more experience you have in financial modeling, the more easily you will understand which formulas are the appropriate to use under the specific circumstances of your model.&lt;br /&gt;&lt;br /&gt;About the Author&lt;br /&gt;&lt;br /&gt;Russ Steward has more than fifteen years of experience in investment banking and private equity, and has developed hundreds of financial models and analyses in Excel. For more information, please visit http://www.rjsholdingsllc.com or http://www.makefinancialmodels.blogspot.com.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-5845011574805375666?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/5845011574805375666/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/08/match-function-in-microsoft-excel.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/5845011574805375666'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/5845011574805375666'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/08/match-function-in-microsoft-excel.html' title='MATCH Function'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-1127010004288641408</id><published>2008-08-14T01:34:00.000-07:00</published><updated>2008-09-23T23:16:04.957-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='PHP'/><title type='text'>Getting a part text of a string</title><content type='html'>To get part of a string in PHP, we use a substr() function.&lt;br /&gt;Syntax:&lt;br /&gt;&lt;blockquote&gt;substr(string,start,length)&lt;/blockquote&gt;&lt;br /&gt;example:&lt;br /&gt;&lt;blockquote&gt;&lt;br /&gt;$str = "Welcome";&lt;br /&gt;$part_str = substr($str,0,3);&lt;br /&gt;echo "$part_str";&lt;br /&gt;&lt;/blockquote&gt;&lt;br /&gt;Result:&lt;br /&gt;&lt;blockquote&gt;Wel&lt;/blockquote&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-1127010004288641408?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/1127010004288641408/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/08/php-getting-part-text-of-string.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/1127010004288641408'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/1127010004288641408'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/08/php-getting-part-text-of-string.html' title='Getting a part text of a string'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-5265506889478847795</id><published>2008-08-14T01:23:00.000-07:00</published><updated>2008-09-23T23:18:26.169-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='PHP'/><title type='text'>Formatting Numbers</title><content type='html'>PHP function number_format is used to format a number in several ways, including choosing how many decimal points it will have, and choosing the 1000s, and decimal point dividers. It is phrased as number_format ( your_number , optional_decimals , optional_decimal_point, optional_1000_separator ) You can not specify just the decimal point or 1000 separator, if you specify one you need to specify both. When working with decimals, it will function like round () and put things at or over .5 up, and under .5 down.&lt;br /&gt;&lt;blockquote&gt;&lt;br /&gt;    number_format (1234.567);&lt;br /&gt;    //Returns the number 1,235&lt;br /&gt;&lt;br /&gt;    number_format (1234.567, 2);&lt;br /&gt;    //Returns the number 1,234.57&lt;br /&gt;&lt;br /&gt;    number_format (1234.567, 2, ',', ' ');&lt;br /&gt;    //Returns the number 1 234,57&lt;br /&gt;&lt;br /&gt;    number_format (1234.567, 1, 'a', 'b');&lt;br /&gt;    //Returns the number 1b234a6&lt;br /&gt;&lt;/blockquote&gt;&lt;br /&gt;&lt;br /&gt;Rounding and Formatting Numbers&lt;br /&gt;   1. Round () - Rounding Numbers&lt;br /&gt;   2. Ceil () - Always Rounding Up&lt;br /&gt;   3. Floor () - Always Rounding Down&lt;br /&gt;   4. Number_format () - Formatting your Numbers&lt;br /&gt;&lt;br /&gt;Source: &lt;a href="http://php.about.com/od/learnphp/ss/round_num_PHP_4.htm"&gt;php.about.com&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-5265506889478847795?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/5265506889478847795/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/08/php-formatting-numbers.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/5265506889478847795'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/5265506889478847795'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/08/php-formatting-numbers.html' title='Formatting Numbers'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-3615078194204986185</id><published>2008-08-14T01:01:00.000-07:00</published><updated>2008-09-23T23:11:35.163-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Internet'/><title type='text'>How to download video from YouTube</title><content type='html'>To download videos from YouTubo, you can follow these following steps...&lt;br /&gt;1. Open the url of a video in YouTubo site, for example: http://www.youtube.com/watch?v=nCuFTJHrRbQ&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_LUXyf14Cvtk/SKTGPD-jf0I/AAAAAAAAAAU/U6dBsAZU784/s1600-h/youtube.JPG"&gt;&lt;img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="http://2.bp.blogspot.com/_LUXyf14Cvtk/SKTGPD-jf0I/AAAAAAAAAAU/U6dBsAZU784/s400/youtube.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5234526628979375938" /&gt;&lt;/a&gt;&lt;br /&gt;2. Click "More Info" text link at right side of the video.&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_LUXyf14Cvtk/SKTHGXm8e6I/AAAAAAAAAAk/FDpuyqBgAhU/s1600-h/youtube1.JPG"&gt;&lt;img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="http://4.bp.blogspot.com/_LUXyf14Cvtk/SKTHGXm8e6I/AAAAAAAAAAk/FDpuyqBgAhU/s400/youtube1.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5234527579141864354" /&gt;&lt;/a&gt;&lt;br /&gt;3. You will find a new box of a URL below the description of the video&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_LUXyf14Cvtk/SKTHfS16YwI/AAAAAAAAAAs/AEmU5i-VFR4/s1600-h/youtube2.JPG"&gt;&lt;img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="http://2.bp.blogspot.com/_LUXyf14Cvtk/SKTHfS16YwI/AAAAAAAAAAs/AEmU5i-VFR4/s400/youtube2.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5234528007359193858" /&gt;&lt;/a&gt;&lt;br /&gt;4. Copy the URL inside of the URL box&lt;br /&gt;5. Open a new window of your browser and tipe this URL: http://keepvid.com&lt;br /&gt;6. Paste the URL you copied before at the URL box of the keepvid.com site&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_LUXyf14Cvtk/SKTJVBZXTJI/AAAAAAAAABE/vGQCDOjGHnI/s1600-h/youtube3.JPG"&gt;&lt;img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="http://2.bp.blogspot.com/_LUXyf14Cvtk/SKTJVBZXTJI/AAAAAAAAABE/vGQCDOjGHnI/s400/youtube3.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5234530029900614802" /&gt;&lt;/a&gt;&lt;br /&gt;7. Then Click download&lt;br /&gt;8. Right click the green text &gt;&gt;Download&lt;&lt;, and choose Save As&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_LUXyf14Cvtk/SKTJr1ahtUI/AAAAAAAAABM/Sy8aAiXDpfM/s1600-h/youtube4.JPG"&gt;&lt;img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="http://3.bp.blogspot.com/_LUXyf14Cvtk/SKTJr1ahtUI/AAAAAAAAABM/Sy8aAiXDpfM/s400/youtube4.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5234530421821257026" /&gt;&lt;/a&gt;&lt;br /&gt;9. Choose your directory to save the video&lt;br /&gt;10. End&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-3615078194204986185?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/3615078194204986185/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/08/how-to-download-video-from-youtubo.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/3615078194204986185'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/3615078194204986185'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/08/how-to-download-video-from-youtubo.html' title='How to download video from YouTube'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://2.bp.blogspot.com/_LUXyf14Cvtk/SKTGPD-jf0I/AAAAAAAAAAU/U6dBsAZU784/s72-c/youtube.JPG' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-2013761289154225327</id><published>2008-08-11T23:11:00.000-07:00</published><updated>2008-09-23T23:21:05.899-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='HTML'/><title type='text'>HTML Introduction</title><content type='html'>&lt;span style="font-family: arial;font-family:verdana, helvetica;font-size:85%;"  &gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;Welcome to HTML...&lt;/b&gt;&lt;/span&gt; &lt;/span&gt; &lt;p style="font-family: arial;"&gt;&lt;span style="font-size:85%;"&gt;&lt;b&gt;&lt;span style="font-size:100%;"&gt;T&lt;/span&gt;&lt;/b&gt;his is Primer #1 in a series of seven that will calmly introduce you to the very basics of &lt;b&gt;H&lt;/b&gt;yper&lt;b&gt;T&lt;/b&gt;ext &lt;b&gt;M&lt;/b&gt;ark-up &lt;b&gt;L&lt;/b&gt;anguage. I suggest you take the Primers one at a time over seven days. By the end of the week, you'll easily know enough to create your own HTML home page. No really. You will. &lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:85%;"&gt;I say that because many people scoff at the notion that they can actually learn this new Internet format. I'm still amazed that the best-selling line of computer books calls its readers "Dummies." And people seem to revel in that title. Some of the smartest people I know love to proclaim themselves "Dummies" regarding every aspect of computers. Strange. I think you'll do a whole lot better at your next cocktail party by handing out your home page address rather than laughing about how dumb you are about the Internet.&lt;br /&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:85%;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;Let's Get Started&lt;/b&gt;&lt;/span&gt;  &lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:85%;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;I&lt;/b&gt;&lt;/span&gt; am assuming at the beginning of this tutorial that you know nothing about HTML. I am assuming, however, some computer knowledge. You wouldn't be looking at this page without having some knowledge. To continue with these Primers, you will need... &lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:85%;"&gt;&lt;b&gt;1.&lt;/b&gt; A computer (obviously)  &lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:85%;"&gt;&lt;b&gt;2.&lt;/b&gt; A browser like &lt;a href="http://www.mozilla.com/firefox/"&gt;Mozilla Firefox&lt;/a&gt;, &lt;a href="http://home.netscape.com/" target="resource window"&gt;Netscape Navigator&lt;/a&gt;, &lt;a href="http://www.microsoft.com/ie/" target="resource window"&gt;Microsoft Internet Explorer&lt;/a&gt;, or &lt;a href="http://www.opera.com/" target="resource window"&gt;Opera&lt;/a&gt;. If you're looking at this page, you already have one. If you look up at the title bar at the very top of your screen it will probably say the page title ("Basic HTML: Introduction") and then your browser's name. &lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;3.&lt;/b&gt; A word processor. If you have access to Windows "Notepad" or "WordPad" programs or the MAC "Simple Text" program, use that to get started. &lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:85%;"&gt;If you have those three things, you can write HTML with the best of them. Now here are a few questions you probably have:  &lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;Q. &lt;i&gt;I have a MAC (or PC) -- will this work on my computer?&lt;/i&gt;&lt;/b&gt;&lt;br /&gt;&lt;b&gt;A.&lt;/b&gt; Yes. HTML does not use any specific platform. It works with simple text. More on that in a moment...  &lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:85%;"&gt;&lt;b&gt;Q. &lt;i&gt;Must I be logged onto the Internet to do this? More specifically, will learning this throw my cost for on-line way up?&lt;/i&gt;&lt;/b&gt;&lt;br /&gt;&lt;b&gt;A.&lt;/b&gt; Neither. You will write off-line.  &lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:85%;"&gt;&lt;b&gt;Q. &lt;i&gt;Do I need some sort of expensive program to help me write this?&lt;/i&gt;&lt;/b&gt;&lt;br /&gt;&lt;b&gt;A.&lt;/b&gt; No. You will write using just what I outlined above. You can buy those programs if you'd like, but they're not needed. I've never used one. &lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:85%;"&gt;&lt;b&gt;Q. &lt;i&gt;Is this going to require I learn a whole new computer language like Basic or Fortran or some other cryptic, God-awful, silly-lookin', gothic extreme gobbledygook?&lt;/i&gt;&lt;/b&gt;&lt;br /&gt;&lt;b&gt;A.&lt;/b&gt; Touchy-touchy, aren't we? "No" is the answer. HTML is not a computer language. Allow me to repeat that in bold... &lt;b&gt;HTML is not a computer language!&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:85%;"&gt;&lt;span style="font-size:85%;"&gt;&lt;b&gt;What is HTML?&lt;/b&gt;&lt;/span&gt;  &lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:85%;"&gt;&lt;span style="font-size:85%;"&gt;&lt;b&gt;H&lt;/b&gt;&lt;/span&gt;-T-M-L are initials that stand for &lt;b&gt;H&lt;/b&gt;yper&lt;b&gt;T&lt;/b&gt;ext &lt;b&gt;M&lt;/b&gt;arkup &lt;b&gt;L&lt;/b&gt;anguage (computer people love initials and acronyms -- you'll be talking acronyms ASAP). Let me break it down for you:  &lt;/span&gt;&lt;/p&gt;&lt;p style="font-family: arial;"&gt; &lt;/p&gt;&lt;span style="font-family: arial;font-family:verdana, helvetica;font-size:85%;"  &gt;&lt;li&gt;&lt;b&gt;Hyper&lt;/b&gt; is the opposite of linear. It used to be that computer programs had to move in a linear fashion. This before this, this before this, and so on. HTML does not hold to that pattern and allows the person viewing the World Wide Web page to go anywhere, any time they want.  &lt;/li&gt;&lt;li&gt;&lt;b&gt;Text&lt;/b&gt; is what you will use. Real, honest to goodness English letters.   &lt;/li&gt;&lt;li&gt;&lt;b&gt;Mark up&lt;/b&gt; is what you will do. You will write in plain English and then mark up what you wrote. More to come on that in the next Primer.   &lt;/li&gt;&lt;li&gt;&lt;b&gt;Language&lt;/b&gt; because they needed something that started with "L" to finish HTML and Hypertext Markup &lt;i&gt;Louie&lt;/i&gt; didn't flow correctly. Because it's a language, really -- but the language is plain English.&lt;/li&gt;&lt;/span&gt;&lt;br /&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;Beginning to Write&lt;/b&gt;&lt;/span&gt;  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;Y&lt;/b&gt;&lt;/span&gt;ou will actually begin to write HTML starting with &lt;a href="http://www.htmlgoodies.com/primers/primer_2.html"&gt;Primer #2&lt;/a&gt;. That's tomorrow if you follow the seven-day plan this was written for. Here, I want to tell you how you will go about the process. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;You will write the HTML document on the word processor, or Notepad, WordPad, or Simple Text. When you are finished creating the HTML document, you'll then open the document in a browser, like Netscape Navigator. The browser will interpret the HTML commands for you and display the Web page. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;Now, some people who are already schooled in HTML are going to jump up and down and yell that you should be using an HTML assistant program because it makes it easier. That's true, but it also makes it harder to learn as the program does half the work for you. Take my word for it, use the word processor for a week, then go to the assistant if you still want to use one. You'll be far better off for the effort. I have been writing HTML for six years and I still use Notepad for the bulk of my writing. &lt;/p&gt;&lt;p style="font-family: arial;"&gt; &lt;/p&gt;&lt;hr style="font-family: arial;" width="40%"&gt;  &lt;p style="font-family: arial;"&gt;Let's get into the programs you will use to write your HTML document. Keep this in mind: HTML documents must be text only. When you save an HTML document, you must save only the text, nothing else. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;The reason I am pushing NotePad, WordPad, and Simple Text is that they save in text-only format without your doing any additional work. They just do it. But, if you're like me, then you will want to start writing on a word processor, like WORD, or WordPerfect. Maybe you're just more comfortable on it. If so, read this next part carefully. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;The Word Processor&lt;/b&gt;&lt;/span&gt;  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;W&lt;/b&gt;&lt;/span&gt;hen you write to the word processor you will need to follow a few steps:  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;1.&lt;/b&gt; Write the page as you would any other document.  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;2.&lt;/b&gt; When you go to save the document (&lt;span style="color:#800000;"&gt;Here's the trick&lt;/span&gt;), ALWAYS choose &lt;b&gt;SAVE AS&lt;/b&gt;.  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;3.&lt;/b&gt; When the SAVE AS box pops up, you will need to save the page in a specific format. Look at the SAVE AS dialogue box when it pops up: Usually at the bottom, you find where you will be able to change the file format. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;4.&lt;/b&gt; If you have a PC, save your document as &lt;b&gt;ASCII TEXT DOS&lt;/b&gt; or just &lt;b&gt;TEXT&lt;/b&gt;. Either one will work.  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;5.&lt;/b&gt; If you have a MAC, save your document as &lt;b&gt;TEXT&lt;/b&gt;.  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;6.&lt;/b&gt; When I started writing HTML, I saved pages by assigning every Web page its own floppy disc. It just helped me keep it all straight, but if you want to save right to your hard drive, do it. I only offer the floppy disc premise as a suggestion. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;i&gt;Please remember:&lt;/i&gt; It is very important to choose SAVE AS EVERY time you save your document. If you don't, the program won't save as TEXT, but rather in its default format. In layman's terms -- use SAVE AS or screw up your document. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;You see, when you save your document in WORD, or some other word processor format other than text, you are saving much more than just the letters on the page. You're saving the margin settings, the tab settings, specific fonts, and a whole lot of other settings the page needs to be displayed correctly. You don't want all of that. You just want the text. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;NotePad, WordPad, and SimpleText already save in text-only format so if you use one of them as your word processor, you'll get the correct format simply by saving your document. &lt;/p&gt;&lt;p style="font-family: arial;"&gt; &lt;/p&gt;&lt;hr style="font-family: arial;" width="40%"&gt;  &lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;How To Name Your Document&lt;/b&gt;&lt;/span&gt;  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;W&lt;/b&gt;&lt;/span&gt;hat you name your document is very important. You must first give your document a name and then add a suffix to it. That's the way everything works in HTML. You give a name and then a suffix. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;Follow this format to name your document:  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;1.&lt;/b&gt; Choose a name. Anything. If you have a PC &lt;i&gt;not&lt;/i&gt; running Windows 95, you are limited to eight letters, however.  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;2.&lt;/b&gt; Add a suffix. For all HTML documents, you will add either ".htm" or ".html".  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;(&lt;i&gt;".htm" for PCs running Windows 3.x and ".html" for MAC and Windows 95/98 Machines&lt;/i&gt;)  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;Example:&lt;/b&gt;&lt;br /&gt;I am looking to name a document I just wrote on a PC running Windows 3.11 for workgroups. I want to name the document "fred". Thus the document must be named "fred.htm". If it was MAC or Windows 95/98 I would name it "fred.html". Please notice the dot (period) before .htm and .html. And no quotation marks, I just put them in here to set the name apart. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;Uhhhhhh.... Why Do I Do That?&lt;/b&gt;&lt;/span&gt;  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;G&lt;/b&gt;&lt;/span&gt;lad you asked. It's a thing called "association." It's how computers tell different file types apart. ".html" tells the computer that this file is an HTML document. When we get into graphics, you'll see a different suffix. All files used on the Web will follow the format of "name.suffix." Always. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;Okay, why .htm for PCs running Windows 3.x and .html for MAC and Windows 95/98?&lt;/b&gt;&lt;/span&gt;  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;Because that's the way the operating systems are made (Windows 3.x, Windows 95/98, and MAC OS are all technically called operating systems). Windows 3.x only allows three letters after the dot. MAC OS and Windows 95/98 allow four, or more. Your browser allows for both suffixes. It acts upon .html and .htm in the same fashion. &lt;/p&gt;&lt;p style="font-family: arial;"&gt; &lt;/p&gt;&lt;hr style="font-family: arial;" width="40%"&gt;  &lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;Why do you keep harping on the fact that I must save in TEXT only?&lt;/b&gt;&lt;/span&gt;  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;Y&lt;/b&gt;&lt;/span&gt;ou're just full of questions! You see, HTML browsers can only read text. Look at your keyboard. See the letters and numbers and little signs like % and @ and *? There are 128 in all (read upper- and lowercase letters as two). That's text. That's what the browser reads. It simply doesn't understand anything else. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;If you'd like to test this theory, then go ahead and create an HTML document and save it in WORD. Then try and open it in your browser. Nothing will happen. Go ahead and try it. You won't hurt anything. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;Remember that if you are using Notepad, Wordpad, or Simple Text, the document will be saved as text with no extra prompting. Just choose SAVE. &lt;/p&gt;&lt;p style="font-family: arial;"&gt; &lt;/p&gt;&lt;hr style="font-family: arial;" width="40%"&gt;  &lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;Opening the Document in the Browser&lt;/b&gt;&lt;/span&gt;  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;O&lt;/b&gt;&lt;/span&gt;nce you have your HTML document on the floppy disc or your hard drive, you'll need to open it up in the browser. It's easy enough. Since you're using a browser to look at this Primer, follow along. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;1.&lt;/b&gt; Under the FILE menu at the very top left of this screen, you'll find OPEN, OPEN FILE, OPEN DOCUMENT, or words to that effect.  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;2.&lt;/b&gt; Click on it. Some browsers give you the dialogue box that allows you to find your document right away. Internet Explorer, and later versions of Netscape Navigator, require you to click on a BROWSE button or OPEN FILE button to get the dialogue box. When the dialogue box opens up, switch to the A:\ drive (or the floppy disc for MAC users) and open your document. If you saved the file to your hard drive, get it from there. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;3.&lt;/b&gt; You might have to then click an OK button. The browser will do the rest.  &lt;/p&gt;&lt;p style="font-family: arial;"&gt; &lt;/p&gt;&lt;hr style="font-family: arial;" width="40%"&gt;  &lt;p style="font-family: arial;"&gt;&lt;a name="view"&gt;&lt;/a&gt;&lt;span style="font-size:85%;"&gt;&lt;b&gt;One More Thing&lt;/b&gt;&lt;/span&gt;  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;Y&lt;/b&gt;&lt;/span&gt;ou easily have enough to keep you occupied for the first day. Don't worry, the Primers get less wordy after this.  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;If you are going to start writing HTML, I suggest you make a point of learning to look at other authors' HTML pages. You say you're already doing that, right? Maybe. What I mean is for you to look at the HTML document a person wrote to present the page you are looking at. Don't look at the pretty page, look behind it at the HTML document. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;Why Would I Do That?&lt;/b&gt;&lt;/span&gt;  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;Because you can... but seriously, folks. Let's say you run into a page that has a really neat layout, or a fancy text pattern, or a strange grouping of pictures. You'd like to know how to do it. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;Well, look, I'm not telling you to steal anything, but let's be honest, if you see some landscaping you like, you're going to use the idea. If you see a room layout you like, you will use the idea to help yourself. That's the point of looking at another page's HTML document. I think it's also the best way to learn HTML. In fact, I am self-taught in HTML simply by looking at others' documents. It was the long way around, believe me. You're going to have a much easier time of it with these Primers. &lt;/p&gt;&lt;p style="font-family: arial;"&gt;Here's how you look at an HTML document (known as the "source code"):  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;1.&lt;/b&gt; When you find a page you like, click on VIEW at the top of the screen.  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;2.&lt;/b&gt; Choose DOCUMENT SOURCE from the menu. Sometimes it only reads SOURCE.  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;3.&lt;/b&gt; The HTML document will appear on the screen.  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;&lt;b&gt;4.&lt;/b&gt; Go ahead. Try it with this page. Click on VIEW and then choose the SOURCE.  &lt;/p&gt;&lt;p style="font-family: arial;"&gt;It's going to look like chicken-scratch right now, but by the end of the week, it'll be readable and you'll be able to find exactly how a certain HTML presentation was performed.&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-family: arial;"&gt;Copied from: &lt;/span&gt;&lt;a style="font-family: arial;" href="http://www.htmlgoodies.com/primers/html/article.php/3478141#lets"&gt;www.htmlgoodies.com&lt;/a&gt;&lt;br /&gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-2013761289154225327?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/2013761289154225327/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/08/html-introduction.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/2013761289154225327'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/2013761289154225327'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/08/html-introduction.html' title='HTML Introduction'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-2269891571371046956</id><published>2008-08-11T00:25:00.000-07:00</published><updated>2008-09-23T23:22:29.060-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Database'/><title type='text'>SQL Tutorial</title><content type='html'>&lt;p&gt;&lt;b&gt;SQL&lt;/b&gt; is short for &lt;b&gt;S&lt;/b&gt;tructured &lt;b&gt;Q&lt;/b&gt;uery &lt;b&gt;L&lt;/b&gt;anguage and is a widely            used database language, providing means of data manipulation (store, retrieve,            update, delete) and database creation.&lt;/p&gt;          &lt;p&gt;Almost all modern Relational Database Management Systems like MS SQL Server,            Microsoft Access, MSDE, Oracle, DB2, Sybase, MySQL, Postgres and Informix use            SQL as standard database language. Now a word of warning here, although all            those RDBMS use SQL, they use different SQL dialects. For example MS SQL Server            specific version of the SQL is called T-SQL, Oracle version of SQL is called            PL/SQL, MS Access version of SQL is called JET SQL, etc.&lt;/p&gt;          &lt;p&gt;Our SQL tutorial will teach you how to use commonly used &lt;a href="http://www.sqlcommands.net/" title="SQL Commands" target="_blank"&gt;SQL commands&lt;/a&gt; and you            will be able to apply most of the knowledge gathered from this SQL tutorial to            any of the databases above.&lt;/p&gt;          &lt;h3&gt;SQL Tutorial Table of Contents&lt;/h3&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-tutorial.asp" title="SQL tutorial"&gt;SQL Tutorial&lt;/a&gt;&lt;br /&gt;          Learn what SQL (Structured Query Language) is, and where and how it is used.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/sql-database-table.asp" title="SQL Database Table"&gt;SQL             Table&lt;/a&gt;&lt;br /&gt;          SQL Database Tables are the foundation of every RDBMS (Relational Database            Management System). Learn more about SQL tables here.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-SELECT.asp" title="SQL SELECT"&gt;SQL SELECT&lt;/a&gt;&lt;br /&gt;          Learn how to use the SELECT SQL statement to retrieve data from a SQL database            table.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-SELECT-INTO.asp" title="SQL SELECT INTO"&gt;SQL SELECT             INTO&lt;/a&gt;&lt;br /&gt;          Learn how to use the SQL SELECT INTO statement to copy data between database tables.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-DISTINCT.asp" title="SQL DISTINCT"&gt;SQL DISTINCT&lt;/a&gt;&lt;br /&gt;          Learn how to use the SQL DISTINCT clause together with the SQL SELECT keyword, to return            a dataset with unique entries for certain database table column.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-WHERE.asp" title="SQL WHERE"&gt;SQL WHERE&lt;/a&gt;&lt;br /&gt;          The SQL WHERE command is used to specify selection criteria, thus restricting            the result of a SQL query.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-LIKE.asp" title="SQL LIKE"&gt;SQL LIKE&lt;/a&gt;&lt;br /&gt;          The SQL LIKE clause is used along with the SQL WHERE clause and specifies            criteria based on a string pattern.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-INSERT-INTO.asp" title="SQL INSERT INTO"&gt;SQL INSERT             INTO&lt;/a&gt;&lt;br /&gt;          Learn how to use the SQL INSERT INTO clause to insert data into a SQL database            table.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-UPDATE.asp" title="SQL UPDATE"&gt;SQL UPDATE&lt;/a&gt;&lt;br /&gt;          Learn how to use the SQL UPDATE statement to update data in a SQL database table.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-DELETE.asp" title="SQL DELETE"&gt;SQL DELETE&lt;/a&gt;&lt;br /&gt;          Learn how to use the SQL DELETE statement to delete data from a SQL database table.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-ORDER-BY.asp" title="SQL ORDER BY"&gt;SQL ORDER BY&lt;/a&gt;&lt;br /&gt;          Learn how to use the SQL ORDER BY statement to sort the data retrieved in your SQL            query.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-AND-OR.asp" title="SQL OR &amp;amp; AND"&gt;SQL OR &amp;amp; AND&lt;/a&gt;&lt;br /&gt;          Learn how to use the SQL OR &amp;amp; AND keywords together with the SQL WHERE clause to            add several conditions to your SQL statement.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-IN.asp" title="SQL IN"&gt;SQL IN&lt;/a&gt;&lt;br /&gt;          The SQL IN clause allows you to specify discrete values in your SQL WHERE            search criteria.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-BETWEEN.asp" title="SQL BETWEEN"&gt;SQL BETWEEN&lt;/a&gt;&lt;br /&gt;          The SQL BETWEEN &amp;amp; AND keywords define a range of data between 2 values.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-Aliases.asp" title="SQL Aliases"&gt;SQL Aliases&lt;/a&gt;&lt;br /&gt;          SQL aliases can be used with database tables and/or with database table            columns, depending on task you are performing.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-COUNT.asp" title="SQL COUNT"&gt;SQL COUNT&lt;/a&gt;&lt;br /&gt;          The SQL COUNT aggregate function is used to count the number of rows in a database table.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-MAX.asp" title="SQL MAX"&gt;SQL MAX&lt;/a&gt;&lt;br /&gt;          The SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-MIN.asp" title="SQL MIN"&gt;SQL MIN&lt;/a&gt;&lt;br /&gt;          The SQL MIN aggregate function allows us to select the lowest (minimum) value for a certain column.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-AVG.asp" title="SQL AVG"&gt;SQL AVG&lt;/a&gt;&lt;br /&gt;          The SQL AVG aggregate function selects the average value for a certain table column.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-SUM.asp" title="SQL SUM"&gt;SQL SUM&lt;/a&gt;&lt;br /&gt;          The SQL SUM aggregate function allows selecting the total for a numeric column.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-GROUP-BY.asp" title="SQL GROUP BY"&gt;SQL GROUP BY&lt;/a&gt;&lt;br /&gt;          The SQL GROUP BY statement is used along with the SQL aggregate functions like            SUM to provide means of grouping the result dataset by certain database table            column(s).          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-HAVING.asp" title="SQL HAVING"&gt;SQL HAVING&lt;/a&gt;&lt;br /&gt;          The SQL HAVING clause is used to restrict conditionally the output of a SQL            statement, by a SQL aggregate function used in your SELECT list of columns.          &lt;/p&gt;          &lt;p&gt;           &lt;a class="MainLink" href="http://www.sql-tutorial.net/SQL-JOIN.asp" title="SQL JOIN"&gt;SQL JOIN&lt;/a&gt;&lt;br /&gt;          The SQL JOIN clause is used whenever we have to select data from 2 or more tables.&lt;/p&gt;&lt;p&gt;Copied from &lt;a href="http://www.sql-tutorial.net/SQL-tutorial.asp"&gt;www.sql-tutorial.net&lt;/a&gt;&lt;br /&gt;         &lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-2269891571371046956?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/2269891571371046956/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/08/sql-tutorial.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/2269891571371046956'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/2269891571371046956'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/08/sql-tutorial.html' title='SQL Tutorial'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5409651822142154476.post-4388774672561735287</id><published>2008-08-10T23:57:00.000-07:00</published><updated>2008-09-23T23:20:56.105-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='PHP'/><title type='text'>PHP Tutorial</title><content type='html'>&lt;p&gt;If you want to learn the basics of PHP, then you’ve come to the right place. The goal of this tutorial is to teach you the basics of PHP so that you can:&lt;/p&gt; &lt;h1&gt;PHP - What is it?&lt;/h1&gt; &lt;p&gt;Taken directly from PHP’s home, &lt;a href="http://www.php.net/" target="_blank"&gt;&lt;strong&gt;&lt;span style="color: rgb(0, 0, 0);font-size:small;" &gt;PHP.net&lt;/span&gt;&lt;/strong&gt;&lt;/a&gt;, “PHP is an HTML-embedded scripting language. Much of its syntax is borrowed from C, Java and Perl with a couple of unique PHP-specific features thrown in. The goal of the language is to allow web developers to write dynamically generated pages quickly.”&lt;/p&gt; &lt;p&gt;This is generally a good definition of PHP. However, it does contain a lot of terms you may not be used to. Another way to think of PHP is a powerful, behind the scenes scripting language that your visitors won’t see!&lt;/p&gt; &lt;p&gt;When someone visits your PHP webpage, your web server processes the PHP code. It then sees which parts it needs to show to visitors(content and pictures) and hides the other stuff(file operations, math calculations, etc.) then translates your PHP into HTML. After the translation into HTML, it sends the webpage to your visitor’s web browser.&lt;span id="more-6"&gt;&lt;/span&gt;&lt;/p&gt; &lt;h1&gt;PHP - What’s it do?&lt;/h1&gt; &lt;p&gt;It is also helpful to think of PHP in terms of what it can do for you. PHP will allow you to:&lt;/p&gt; &lt;ul&gt;&lt;li&gt;Reduce the time to create large websites.&lt;/li&gt;&lt;li&gt;Create a customized user experience for visitors based on information that you have gathered from them.&lt;/li&gt;&lt;li&gt;Open up thousands of possibilities for online tools. Check out &lt;a href="http://www.hotscripts.com/PHP/Scripts_and_Programs/" target="_blank"&gt;&lt;strong&gt;&lt;span style="color: rgb(0, 0, 0);font-size:small;" &gt;PHP - HotScripts&lt;/span&gt;&lt;/strong&gt;&lt;/a&gt; for examples of the great things that are possible with PHP.&lt;/li&gt;&lt;li&gt;Allow creation of shopping carts for e-commerce websites.&lt;/li&gt;&lt;/ul&gt; &lt;h1&gt;What You Should Know&lt;/h1&gt; &lt;p&gt;Before starting this tutorial it is important that you have a basic understanding and experience in the following:&lt;/p&gt; &lt;ul&gt;&lt;li&gt;HTML - Know the syntax and especially &lt;a href="http://www.tizag.com/htmlT/forms.php"&gt;&lt;strong&gt;&lt;span style="color: rgb(0, 0, 0);font-size:small;" &gt;HTML Forms&lt;/span&gt;&lt;/strong&gt;&lt;/a&gt;.&lt;/li&gt;&lt;li&gt;Basic programming knowledge - This isn’t required, but if you have any traditional programming experience it will make learning PHP a great deal easier.&lt;/li&gt;&lt;/ul&gt; &lt;h1&gt;Tutorial Overview&lt;/h1&gt; &lt;p&gt;This tutorial is aimed at the PHP novice and will teach you PHP from the ground up. If you want a drive-through PHP tutorial this probably is not the right tutorial for you.&lt;/p&gt; &lt;p&gt;Remember, you should not try to plow through this tutorial in one sitting. Read a couple lessons, take a break, then do some more after the information has had some time to sink in.&lt;/p&gt; &lt;p&gt;cp from &lt;span style="text-decoration: underline;"&gt;&lt;span style="color: rgb(128, 0, 128);"&gt;www.tizag.com&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5409651822142154476-4388774672561735287?l=exemedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exemedia.blogspot.com/feeds/4388774672561735287/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://exemedia.blogspot.com/2008/08/php-tutorial-learn-php.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/4388774672561735287'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5409651822142154476/posts/default/4388774672561735287'/><link rel='alternate' type='text/html' href='http://exemedia.blogspot.com/2008/08/php-tutorial-learn-php.html' title='PHP Tutorial'/><author><name>exemedia</name><uri>http://www.blogger.com/profile/15893258094237974396</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>
