
All you ever need to remember about MySQL table manipulation in one easy place to find it!
mysql> ALTER TABLE tableName RENAME newName;mysql>ALTER TABLE tableName MODIFY columnName;mysql> ALTER TABLE tableName ADD columnName columnType;mysql> ALTER TABLE tableName DROP columnName;After a table edit it is good practice to optimise the table in order for it to run as efficiently as possible. The MySQL OPTIMIZE command orchestrates this but will not stop access to the table while running (It will suspend writing to the table until complete though).mysql>OPTIMIZE TABLE tableName;
mysql> DROP TABLE tableName;
A MySQL server has a finite number of connections that it will allow, which acts as a safety mechanism against potentially harmful actions. During usual interaction with the server a script will make a connection, run its query and return the query results. The script should also disconnect from the MySQL server when it’s finished to free up one of the limited number of connections that the server will allow. Not doing so can eventually cause an overflow error, which will often not manifest itself until much later in the development process or worse still after client delivery.mysqladmin flush-hosts
<?php
if(isset($my_db_connection)){
mysql_close($my_db_connection);
}
?>
$my_db_connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS);
<link rel="shortcut icon" href="/favicon.ico">
The thing with nature photography is you never quite know what you’re going to get (or was that a box of chocolates according to Forrest Gumph?) Anyway, it doesn’t matter how well planned your expedition; some days you’ll get nothing and some days it will just walk out of the woods in front of you.
In this series we are going to take a whistle stop tour of how to implement an HMI (Human Machine Interface) solution using the Schneider Electric Magelis range of touch screens. Primarily the core XBTGT series, which range from mono 3.8" up to full colour 15" with inbuilt audio visual (AV) functions.
Nowadays it’s not enough for your business to just have a web site. Ten years ago (and ten years is an age in Internet terms) it was certainly was enough but the world and the Internet have changed. Google is king and intends to stay there. Every company wants to be number one and on top of the pile in searches for its products and services however most organisations that are there are not there by accident. They have earned, or sometimes even paid for that privilege.
Today started gloriously and by 5:15am we were back on Harting Down (not unlike Watership Down and with just as many bunnies!). More importantly we had no commitments to be anywhere before 9am :D (You may need to read Part 1 (yesterday) in full to know why such an early start). Basically, this was our second early morning trip out and this time hopefully we had a little more time and continued enthusiasm. We were not disappointed as, once again, the word spectacular fails dismally to describe being on top of The South Downs as the sun rises on a summer morning.
The Boeing 737 clawed its way into the sky this morning. Tonnes of metal and electronics climbing away from London Gatwick, undoubtedly packed full of so many expectations of escape and adventure. Unfortunately we were not on it! An early morning start (4am!) for the chance to photograph herds of wild deer seen around the valleys surrounding Harting Down (approximately 4 miles east of Petersfield on the Hampshire/West Sussex border) and the promise of a hot and sunny day meant the bonus of some sunrise shots too.
Now we all have our list of things that we need to keep clean in life but without descending into a ‘Carry On" sketch about you chaps keeping your equipment clean we are talking camera equipment. You know that old faithful DLSR that we always expect to just get out of the bag and to work perfectly every time.
By 6:45am today the day's photography was a wrap. The best efforts of man's technological know how, scanned from million dollar satellites and processed by state of the art computers, had led BBC weather to promise a wash out weekend. Schools had cancelled fetes and festivities and we were all prepared for a wet and windy 48 hours. They would have been more accurate with sea weed!
Chances are that if you’re reading this then you are already a DSLR (digital single lens reflex) owner and are starting to move away from the nice comfortable ‘everything at automatic’ setting on your camera. Steady!
Every now and then we get notification of something that catches our eye and recently that included a flyer from Schneider Electric (Telemecanique) regarding an offer they are running to promote the launch of the latest version of their Vijeo Designer software (Version 5.0).function smiley($str){
//smileys to check for
$smiles=array(
":)",":-)",":D",":-D",";)",";-)",":O",
":-O",":P",":-P","w00t","8)","8-)",":S",
":s","\:\(","\;\(","\|\)",":@"
);
// replace with emoticons
$replacements=array(
"<img src="http//yourwebsite.com/image/smile.gif" width="20" height="20" title="happy smiley" />",
"<img src="http//yourwebsite.com/image/smile.gif" width="20" height="20" title="happy smiley" />",
"<img src="http//yourwebsite.com/image/biggrin.gif" width="20" height="20" title="big grin smiley" />",
"<img src="http//yourwebsite.com/image/biggrin.gif" width="20" height="20" title="big grin smiley" />",
"<img src="http//yourwebsite.com/image/wink.gif" width="20" height="20" title="winking smiley" />",
"<img src="http//yourwebsite.com/image/wink.gif" width="20" height="20" title="winking smiley" />",
"<img src="http//yourwebsite.com/image/ohmy.gif" width="20" height="20" title="oh my smiley" />",
"<img src="http//yourwebsite.com/image/ohmy.gif" width="20" height="20" title="oh my smiley" />",
"<img src="http//yourwebsite.com/image/tongue.gif" width="20" height="20" title="tongue smiley" />",
"<img src="http//yourwebsite.com/image/tongue.gif" width="20" height="20" title="tongue smiley" />",
"<img src="http//yourwebsite.com/image/w00t.gif" width="20" height="20" title="w00t smiley" />",
"<img src="http//yourwebsite.com/image/roll.gif" width="20" height="20" title="roll eyes smiley" />",
"<img src="http//yourwebsite.com/image/roll.gif" width="20" height="20" title="roll eyes smiley" />",
"<img src="http//yourwebsite.com/image/huh.gif" width="20" height="20" title="huh smiley" />",
"<img src="http//yourwebsite.com/image/huh.gif" width="20" height="20" title="huh smiley" />",
"<img src="http//yourwebsite.com/image/sad.gif" width="20" height="20" title="sad smiley" />",
"<img src="http//yourwebsite.com/image/crying.gif" width="20" height="20" title="crying smiley" />",
"<img src="http//yourwebsite.com/image/sleep.gif" width="20" height="20" title="sleep smiley" />",
"<img src="http//yourwebsite.com/image/mad.gif" width="20" height="20" title="mad smiley" />",
);
for($i=0;$i < sizeof($smiles);$i++){
$str=eregi_replace($smiles[$i], $replacements[$i], strtolower($str));
}
return $str;
}
echo smiley("w00t That makes me so happy! :)");
A stand alone Audio/Visual (AV) system has many advantages over a PC based solution, primarily size and cost. A stand alone presentation system allowing the playback of sound, music, static images or streaming video is a far more rugged platform needing no updates, is virtually impervious to dabbling and inquisitive users, needs no human input to start up and can just be switched off when not needed.
As the newest national park in the United Kingdom, the South Downs National Park will ultimately be fully elevated to National Park status by 2011. Stretching from Eastbourne in the East, through Brighton, Arundel, Petersfield and up to Winchester in the West, the fields, woodlands and chalk hills of the South Downs are within an hour of London and in an area where there is considerable pressure on land for housing.<?xml version="1.0" encoding="UTF-8'?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<url>
<loc>http://www.mywebdomain.co.uk/index.html</loc>
<lastmod>2009-03-07</lastmod>
<changefreq>daily</changefreq>
<priority>0.8</priority>
</url>
</urlset>
<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<url>
<loc>http://www.mywebdomain.co.uk/index.html</loc>
<lastmod>2009-03-07</lastmod>
<changefreq>daily</changefreq>
<priority>0.8</priority>
</url>
<url>
<loc>http://www.mywebdomain.co.uk/web_design.html</loc>
<lastmod>2009-03-15</lastmod>
<changefreq>daily</changefreq>
<priority>0.6</priority>
</url>
</urlset>
Trying to keep up with all the news and latest developments for all those personal and professional internet sites has been made a lot simple thanks to RSS, or Rich Site Syndication. Basically it retrieves the latest contents from your chosen sites thereby keeping you up to date.
Yesterday we wrote a blog article about starting to think more about locations for your panoramic shots ("Start taking better photos, instantly!"). Today we have some more resources for those of you determined to get out and photograph the UK’s flora, fauna and beautiful panoramas.
We all own numerous camera equipped devices nowadays. The prevalence of digital photography means we are inundated in opportunities to snap away far more than ever before. Out with friends, family occasions etc. Are now readily snapped and the internet and email means we can publish and distribute our pictures to anyone, everywhere.
Unfortunately we have had to temporarily remove the Google advertising, including the site search utility that was in use on the i3m site.
Having used Schneider Electric (Telemecanique) Vijeo Designer since version 4.2 (Yes that’s version 4.3, 4.4, 4.5, 4.6 and version 4.7!) we are currently awaiting the imminent release of Vijeo Designer 5.0 (If you have not heard about this release then contact your local Schneider Electric Representative).
The history of Internet Explorer has been interesting to say the least. From the early arguments about trying to unfairly dominate the market to the passions that are sparked about other browsers, the browser arena remains entertaining.
If you need to perform a basic image re-size or some simple photo editing then there is a free of charge photo retouching, image composition and image editing software package called GIMP, which provides one of the best free photo editing packages around.
Which are you? If you’re just starting out with digital photography and in particular considering your first entry level Digital Single Lens Reflex (DLSR) then you may be at that junction asking yourself just the question. Chances are that is you are already snapping away then you’ve made that choice already. Can you remember how or why? You see every now and then we get asked “Which is best Canon or Nikon?”.
If you think getting online is as simple as throwing together a web site and sitting back and waiting for the visitors to roll in then you are going to be sadly disappointed. The fact is that us web users are a fickle bunch. We flit, we scan and we don’t hang around too long. So if you’re site doesn’t rank on page one the chances are it will not get a hit.
At last! It’s true what they say about the weather in England. If you don’t like it then just hang around for a while! Today, after the blizzards and then the rain it was finally, finally, a glorious sunny day. Even the flora and fauna were convinced that it was time for spring!
For us it meant only one thing. Our first experiments with the Infrared filter and the excuse to get out into the countryside. We’re quite lucky at i3m as our offices are on the edge of the South Downs, so it was hiking boots and the Public Footpaths around Butser Hill for us.
Ditching the car in the picturesque village of South Harting, on the West Sussex/Hampshire border between Chichester and Petersfield, we ascended the South Downs. Now this sounds like an easy task when written in the blog but believe me it’s more than hard work! Our ascension was slow and well, painful!
Anyway, some early experimental shots were committed to flash disk and the one thing that we definitely need to brush up on is our f-stops, ISO settings and exposure times. It was a bit ‘hit and miss’ to say the least. Tomorrow we’re out again and hopefully we can give a good ‘getting started’ account early next week.
Yes, it arrived in super quick time thanks to the gang over at Surrey Photographic and we have managed a couple of test shots already (just basic set and test stuff). The good news is that with the Canon 350D set in BW mode we are get some good initial results. Without doing the English Tourist Board out of anything we just need a little sunshine and the excuse to get out into the English countryside. Today? Overcast…..
Is web 2.0 fast becoming a liability to graphic design, web design and machine interface? Have we just had too much? With good graphic design never having been about following the herd the need to reflect your brand and business is fast moving beyond web 2.0 Thanks to it’s over use the white background and sultry reflection, glossy buttons and diagonal stripes are looking all too similar.