RGB Color Tools
These are some development information that I find useful for every day use. I will continue to add information to this page when I find something that I might need to use again. Feel free to use the information on this page!!
This query is useful when you want to query a table and only return the rows within a certain date range. In this case, records created in the past 24 hours will be returned:
select * from sometable
In the above query, the "ChangeDate" column is a datetime column type. This query works fine in SQL Server 2000 and 2008.
Powerful PHP SQL Query
Sample of a PHP code that will dump SQL values into an array, sure they might be better ways to do this, but this is simple and I have found to be pretty effective for most cases.
// Get the Value from the Database