Computer Magic
Software Design Just For You

Archive for the 'MySQL' Category

PHP Tutorial – Lesson 12 Hello!? Are you there?! – Using the SELECT statement

Monday, February 13th, 2006

This is both the easiest and most difficult of the four SQL statements. The SELECT statement. We have covered putting data in the database (INSERT), removing data (DELETE), and changing data that already exists (UPDATE). Aside from the INSERT statement, which simply jams data into a table, you append a WHERE clause onto your statements […]

PHP Tutorial – Lesson 11 Just make it go away! – Using the DELETE statement

Tuesday, January 31st, 2006

The next of the big four SQL statements that you need to master on this long and bumpy road is the DELETE statement. At some point, a customer will leave, or an item will permanently go out of stock or some other reason will pop up where you will need to remove data that is […]

PHP Tutorial – Lesson 10 Ooops… I messed up, can I start over? – Using the UPDATE statement

Tuesday, January 24th, 2006

We always have to make changes. In fact, I think that is one of the first things that people quote as an advantage of using computers, “it’s easy to change!”. That is right up there with “these are real time savers!”. Your mileage will vary I am sure… Information in the database is easy to […]

PHP Tutorial – Lesson 9 Putting data in the database – Using the INSERT statement

Tuesday, January 24th, 2006

Ok, take two. The web can be unreliable at times, and it is never more frustrating than when you complete an article and hit save only to have the post fail. My impatience may result in a slightly abbreviated version of the last attempt. Remember folks, always copy long articles before submitting them on the […]

PHP Tutorial – Lesson 8 Data Data Everywhere!

Friday, January 13th, 2006

Today we take a short break from learning PHP. I would think that the bulk of the people reading these tutorials would like to learn about writing their own database driven web applications using PHP (that would be online shopping carts, message boards, and most any other use you would have for PHP scripts on […]

Home | My Blog | Products | Edumed | About Us | Portfolio | Services | Location | Contact Us | Embedded Python | College Courses | Quick Scan | Web Spy | EZ Auction | Web Hosting
This page has been viewed 828626 times.

Copyright © 2005 Computer Magic And Software Design
(360) 417-6844
computer magic