Author: Scott Roberts

We’ll be progressing from simply selecting records from a database to actually changing the data that resides in it. In this installment, we’ll add data with SQL’s insert statement.

The insert statement is a very straightforward one, and you’ll be surprised on how easy it is to add records to a database. Here is a simplistic example of what the code looks like:

INSERT INTO table_name (column_name1, column_name2, column_name3, column_name4)
VALUES ('value_1','value_2','value_3','value_4')

The first of the two lines needed begins with the insert into clause, proceeded by the name of the table, then in parenthesis all the columns you wish to insert data into. The second line starts with the term value followed by the individual records that are to be inserted into the table. The specific records are enclosed in single quotation marks, separated by commas, and the entire group lays inside parenthesis…

Hot off the press from Blair Lazar:

“Dear ChiliPal,

So many things have been going on in Death Sauce Land over the last few months. So much in fact that I could not explain everything in just one e-Mail. Over the next couple of weeks I will be sending out several additional messages covering many exciting topics.

Today I want to announce that Blair’s and Zakk Wylde have…

A bird runs into the space shuttle’s fuel tank during a launch:

The Strangemaps website has posted links to a couple of extremely cool map graphics: the area where the Apollo 11 astronauts (Neil Armstrong and Buzz Aldrin) walked on the moon in July 1969 compared to the sizes of a standard soccer field and a Major League Baseball diamond.

Click on the images below to view the full moonwalk maps:

How many hot sauces have you tried that have become an instant staple in your house, where you absolutely had to have a bottle on hand at all times and became as commonplace in your kitchen as ketchup and white bread? My “must-have” in the hot sauce world is Ott’s Wing Sauce.

I first became addicted to Ott’s sometime in the mid-1990s when St. Louis area Denny’s restaurants used Ott’s on their Buffalo Chicken Strips. I tasted them and knew I had to get my grubby little paws on the sauce. After a bit of research my wife and I found the answer, and a bottle of it has been in our kitchen ever since.

Sadly, our local Denny’s ditched Ott’s a few years ago in favor of a runnier, redder, and weaker buffalo sauce on their chicken breast strips. It’s a shame that more scraggly 2:00 am diner-goers who ordered the Buffalo Chicken Strips wouldn’t be able to experience what I consider the best mild-to-medium buffalo sauce in the world…

German website Pundo3000.com has taken photos of one hundred different, locally store-bought, food products and compared them side-by-side with the doctored pictures that are on their packages.

Here’s a German paraphrased translation of the web page, thanks to http://babelfish.altavista.com/:

A new sauce has just been made available on the Blair’s Website: Pure Death. No, it’s not one to top the 750,000 SHU threshold of Jersey Death. Blair promises this one to be around the same as level as After Death, which measures just shy of the 50,000 mark (still pretty darned hot). Unlike a lot of liquid super scorchers on the market, Pure Death contains no extract, and gets it’s heat from the pods of bhut jolokia and orange habanero peppers…

In my last article about growing bhut jolokia peppers, I briefly described the seeds and my experience eating a pepper flake. Now we get to the good part – planting the seeds!

Starting Indoors

Like a good bulk of the United States, my home state of Missouri has a climate that won’t allow for the outdoor starting of hot pepper plants. The good news is that with the right indoor conditions it’s easy to have your pepper seeds germinate and sprout up into nice little seedlings. What are those conditions, you might ask?

Keep Your Plants Warm

First, make sure you’re able to keep your peppers in a place that is able to get plenty of heat. It can be…

You’ve got to hand it to the guys who think up these things and then construct them. Here’s a nicely edited audio/video mashup featuring The Beatles and David Lee Roth performing “Drive My Car” and “Runnin’ With the Devil”:

In case you were wondering, the Beatles footage was taken from their 1968 “Revolution” video, and Van Halen’s from their “Runnin’ With the Devil” clip produced ten years later. Audio was the naked David Lee Roth studio vocal track of “Runnin'” (that surfaced some time last year) inserted into the Fab Four’s classic hit from Rubber Soul.

Things are going to slow down a bit on the RobertsSTL.com site, so don’t be expecting a whole lot of updates. Instead, in the coming months I’m going to focus more attention on updating my Scott Roberts web site.

Because of it’s wide availabilty on web servers and it’s free nature, PHP has become the choice scripting language in the internet. If you would like to get a good grasp on its precepts using variables, read on…

Have you always loved the antics of Garfield, the lasagna-loving cat? Yeah, me neither. Here are a few links that poke fun at the ridiculously unfunny comic:

Remove that wisecracking orange feline from every frame of the comic strip and you get Garfield Minus Garfield. It’s amusing to see Garfield’s owner, Jon Arbuckle, turn into a lonely, depressed, schizophrenic man who has conversations with thin air.

Realfield borrows from that last idea and pushes it further by replacing Garfield with a real, non-talking cat. Jon is even more psychopathically sad in this one.

My favorite is…

Jerry the dog needs no help playing with his ball, thanks to this cool ball-throwing machine: