[GENIUSAdnan]

We have a database in our intranet(offline) which is update everyday. And other one database for our website(online) that must needs to be updated every day with data coming from the first one.

Please tell us such method in which only updation occur, i mean it shouldn't be like that (the deletion of previous one and create new one).
in updation case only that tables or records should be updated those are effected offline during data entry or in insertion case if any one new one table or record inserted.

Some replies i had got like that :
(adding a timestamp when a record was created/modified would help)

But the problem is that How can we SELECT every record with a timestamp newer than our last update(offline),And after that how can we insert new data into database online.
If u (anyone) have idea about how to write Script in php regarding my problem or having already script for that or having any useful reference than please response me soon.

[sufyan]

How about something like:

Code:

SELECT * FROM table WHERE timestamp between '$lastupdate' AND '$now'

or even:

Code:

SELECT * FROM table WHERE timestamp > '$lastupdate'

should work.