Recently I was asked to upload a whole Excell database into an existing Mysql database. Looking online I found several responses and they had most of the answers I needed but also I had to improvise some coding. Here are the steps I took.
1 - Make the Excell file into a CSV. To [...]
Entries Tagged as 'Tutorials / Training'
Import excel file to Mysql with PHP
October 24th, 2007 by Alex Costa · No Comments
Tags: Applications · Programming · Tutorials / Training
Show Control Panel as a Flyout Menu in Vista
October 20th, 2007 by Mark5 · No Comments
Ever wanted to see your control panel as a flyout menu in Vista rather than having to click on it, wait for the whole window to load and then sort though the applets?
Fortunately, the solution is very straightforward. First right click on the Orb and select properties.
Then simply choose ‘Start Menu’ from the tabs (it [...]
Tags: Mark's Bits · Tutorials / Training · quick & easy tips
Projector Problems
October 6th, 2007 by dcouper · No Comments
Tonight at 8:30 I got a call saying that the projector is not displaying the picture, it just continually searches for an input, going through Scart, VGA 1, VGA 2 and USB.
There are several things that you need to check that could be causing the problem.
Check that the cable is plugged into the correct [...]
Tags: Peripherals · Tutorials / Training
Linux Commands
September 5th, 2007 by Alex Costa · 2 Comments
I did a search on google search for “Linux Commandline” looking for some simple linux commands to do some work on my home Debian based (Kurumin) linux distro, and I came across this list of usefull commands. Interesting fact that a lot of other sites I visited also list this same site http://www.pixelbeat.org/cmdline.html .
Some of [...]
Tags: OS & Servers · Tutorials / Training · quick & easy tips
WordPress to MySpace Crossposting
August 29th, 2007 by Mark5 · 3 Comments
For those of us who maintain several blogs, crossposting - or the ability to write one blog and then publish it to multiple blogs - is a very handy function!
MySpace has traditionally been one of the hardest to crosspost to, but if you are a WordPress user, then enter some funky php courtesy of Roderick [...]
Tags: Lifestyle · Mark's Bits · Tutorials / Training · Web Browsers
Download FLV files from Youtube / Flash Video Sites and Convert to AVI
August 21st, 2007 by Mark5 · No Comments
From time to time I find I want to actually download a video from sites like Youtube or GoogleVideo so that I have access to them offline.
There are several ways to do this, and if you are windows user, by far the easiest is to use a Firefox plugin. There are several, but the two [...]
Tags: Mark's Bits · Tutorials / Training · quick & easy tips

