Which database do you use ?
I donīt know mySql ... but I know Sybase very well and there you have
something called Triggers ...
[Cite SybaseDoc]
A trigger is a stored procedure that goes into effect when you insert,
delete, or update data in a table
[/CITE]
You could say for example
Create trigger for blahblah on insert
as
begin
take the inserted recordset and put it in another table ...
end
Cheers,
Marcel
> -----Original Message-----
> From: jv [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 30, 2001 17:44
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Seperate Tables for Same Data?
>
> Greetings,
>
> I am setting up two seperate tables that will hold identically INSERTed
> data. The reason for this is that one table will hold data that will
> expire
> by timestamp daily and the other will hold the very same data for later
> manipulation.
>
> Is sending identical data like this to two seperate tables a good practise
> or is there a better way?
>
> Thanks,
>
> James
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
