SQL Database
hi all
i have this code to cleanup old entries in my database PHP Code:
this is my table PHP Code:
|
Re: SQL Database
You would do:
Code:
SELECT * FROM `global_stats` WHERE `timestamp` < '%d'; |
Re: SQL Database
Quote:
im really noob at this if u can give me example that would be nice... PHP Code:
|
Re: SQL Database
Quote:
PHP Code:
PHP Code:
result> PHP Code:
|
Re: SQL Database
What you need to do is first call your query to retrieve what will be deleted so they can be written to your log. Once you execute that query, execute the delete query which you do not to do any handling in the query callback...once it executes, it is done and all records are deleted.
PHP Code:
|
Re: SQL Database
Bugsy You are the man! TY
All good now..im switching from nvault to sql |
| All times are GMT -4. The time now is 20:53. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.