INNER JOIN product_price
ON product.productId = product_price.productId
SET product_price.price = product_price.price * 1.5
WHERE product.dateCreated < '2009-10-23'
NOTE: This applies to MySQL version 4.0 or higher
Incorrect usage of UNION and ORDER BY
$time_A = strtotime("April 4, 2008"); $time_B=strtotime(now); $numdays=intval(($time_B-$time_A)/86400)+1;
The number of seconds in a day is 86400 and the calculations usually shorts you a day so thats why we add a 1. This is do the fact the now() returns the current time which is not a complete day.
Microsoft Preps Open-Source Apps Marketplace
Microsoft is in the process of building out a marketplace for open-source applications that could work like an equivalent to an app store for applications, services and support for open-source technology that runs on the Windows platform. At MIX09, Microsoft released several components of the Microsoft Web Platform, an integrated set of tools, servers and frameworks that work seamlessly together and interoperate with popular open-source applications and products that are used in the community. Microsoft is looking at Windows Azure as a potential distribution platform for these applications. read more ...
Microsoft Open Sources .NET MVC Framework
Further evidence of Microsoft's growing commitment towards interoperability and open source — the ASP.NET MVC source code has been released under the Microsoft Public License (MS-PL). read more ...
Highly anticipated open-source releases coming in '09
When big companies release new software, they launch it with lots of hoopla: press tours, technical conferences, free T-shirts. Open-source projects, even the well-known ones, generally release their major new versions with a lot less fanfare. The FOSS (free and open-source software) community is often too busy coding and testing to bother with marketing, even when the new "point release" of the software is really remarkable. read more ...