IE bugs makes life unbearable

CSS is a nice technology when everybody adapts it correctly. Unfortunately some browser(s) like IE doesnt follow W3Cs recommendations and standarts making our lives miserable. I have done an html page with CSS which seems perfect on Firefox,Opera etc. But when it comes to IE it fails to be sown correctly. After some search I learned that IE has also a bug about floats which is called "3px float bug" . To solve it for my case
I changed a "width" attribute to a "max-width".
Also I used  png images with a hope for  transparency. But I learned after searc again that IE 6.0 is not capable of png transparency which is added to IE7.0 version. This is IE and life of a web programmer.

Mambo change 2

A new problem with com_events and mysql 5.0
DB function failed with error number 1054
Unknown column
'a.checked_out' in 'on clause' SQL=SELECT a.*, cc.name AS category,
u.name AS editor, g.name AS groupname FROM jos_events AS a,
jos_categories AS cc LEFT JOIN jos_users AS u ON u.id = a.checked_out
LEFT JOIN jos_groups AS g ON g.id = a.access WHERE a.catid=cc.id ORDER
BY a.catid LIMIT 0,30
And the solution:
This query is the one that fails, and appears around line 226. This
is the fixed version and has had brackets added in line 227 in the FROM
clause, like so-

Code:

   $database->setQuery( "SELECT a.*, cc.name AS category, u.name AS editor, g.name AS groupname"
      . "\nFROM (#__events AS a, #__categories AS cc)"
      . "\nLEFT JOIN #__users AS u ON u.id = a.checked_out"
      . "\nLEFT JOIN #__groups AS g ON g.id = a.access"
      . (count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : "")
      . "\nORDER BY a.catid"
      //. "\nAND a.state ASC"
      . "\nLIMIT $limitstart,$limit"
   );