The Science of Web Art, Design and Development

Since I first met Gmail, in the very beginning of the service, I became addicted to the interface and, this days, I can hardly imagine myself using something else.

Yet using public email addresses is a big problem because if one day you change to another service you will have the headache of telling everybody about your new address. Having your own domain and your email within it is much better.

You may also want to handle old email accounts within Gmail transparently.

In this article, I will show you how to configure Gmail to manage multiple accounts in a transparent way and using your own domain email address or any other you may like.

Update: See the sequel of this article and learn How to manage all your main in Gmail: Filters, Labels multiple Id’s and even backups

read full post…

In my opinion, one of the coolest things of the site I’ve built to Paulo gazela is the event agenda on the navigation bar.

Of course there are many calendar programs around to add to your site and it’s also possible to integrate google calendar or a similar tool, but all Paulo needed was a way to show the events he was going to be in for the folowing, say, 15 days, and an easy interface to add them.

The solution is very simple. We’ve built a database with the date, time and details of the events and we created a SQL query to get all the events 15 days from the current date.

A single SQL query like the one below can handle everything

SELECT *
FROM event, place
WHERE event.place=place.id
  AND CURDATE() < = event.thedate
  AND DATE_ADD(CURDATE(),INTERVAL 15 DAY) >= event.thedate
ORDER BY
  event.thedate ASC,
  event.thetime ASC;

If you want to understand better what this is, to build the database tables and get some more detail, read on.

read full post…