Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18
  1. #11
    Join Date
    Apr 2006
    Location
    Leamington Spa
    Posts
    1,375
    Tokens
    72

    Latest Awards:

    Default

    No, Simon just e-bullies me.
    PHP Code:
    $time date("H:i");
    if(
    $time == "00:00"){
    $query mysql_query("TRUNCATE TABLE `table_name` ;");

    May've got that wrong.
    Last edited by lolwut; 01-11-2007 at 08:00 PM.
    i've been here for over 8 years and i don't know why

  2. #12
    Join Date
    May 2007
    Location
    Nebo, NC, USA
    Posts
    2,517
    Tokens
    0

    Latest Awards:

    Default

    <?php
    include "config.php"; // config file

    $query = mysql_query("TRUNCATE TABLE `table_name` ;");

    ?>

    go into cPanel.
    Go to cron jobs, put the command as:
    wget http://www.site.com/myfile.php

    Then set the time to everyday at 00:00 of every week of every month of every year.

  3. #13

    Default

    Quote Originally Posted by Dentafrice, View Post
    <?php
    include "config.php"; // config file

    $query = mysql_query("TRUNCATE TABLE `table_name` ;");

    ?>

    go into cPanel.
    Go to cron jobs, put the command as:
    wget http://www.site.com/myfile.php

    Then set the time to everyday at 00:00 of every week of every month of every year.
    Humm, how do you do it so it deletes say:
    the data in 00:00 etc..?

  4. #14
    Join Date
    Oct 2007
    Location
    Luton, England
    Posts
    1,548
    Tokens
    388
    Habbo
    DeejayMachoo

    Latest Awards:

    Default

    you set the cron to run the file at the time you want it delete and also

    Simon why are u so up your self?
    Just because someone else helped more then you.


  5. #15
    Join Date
    Jul 2005
    Location
    -
    Posts
    2,995
    Tokens
    0

    Latest Awards:

    Default

    Quote Originally Posted by Mattx.org View Post
    you set the cron to run the file at the time you want it delete and also

    Simon why are u so up your self?

    Just because someone else helped more then you.
    :| there is no need to be so rude.

  6. #16
    Join Date
    Apr 2006
    Location
    Leamington Spa
    Posts
    1,375
    Tokens
    72

    Latest Awards:

    Default

    Yeah, just ignore me. ('ere.)
    i've been here for over 8 years and i don't know why

  7. #17

    Default

    I made it so that it deletes them, but also re adds them at the same time

  8. #18
    Join Date
    Sep 2006
    Location
    Hobart, Australia
    Posts
    593
    Tokens
    0

    Default

    Re-adds the table structure? That's exactly what TRUNCATE does, anyway

Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •