Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 DB Replication

Author  Topic 

tomex1
Starting Member

47 Posts

Posted - 2009-08-12 : 14:52:12
Hi guys,
I am pretty new to SQL and I am hoping you might be able to help me. Basically, I have Database A which gets updated daily and I have a php application which connects to Db A to pull some records.
I would like the php page to change the font color on any field that has changed overnight or based on a particular date.
I was thinking of a solution that goes along the lines of Replicating Db B in another Db B and somehow comparing the two databases. This is just my vague idea and it might not be the best way to go about what I want.
Pls anything you can tell me would be really appreciated as I am open to your suggestions.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-08-12 : 15:02:38
You should post your question on a DB2 site as this site is for Microsoft SQL Server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-08-12 : 15:43:08
should add a "lastUpdated" field to tables in question. then let the PHP do the date math
Go to Top of Page
   

- Advertisement -