Jump to content

Cron PHP Help


HCProfessionals

Recommended Posts

Ok, I've been trying to figure this out for about 4 hours now. What I am trying to do is update log information from one table to another every 30 minutes. Am I doing this correct?

 

<?php
$cron = true;

$userinfo = $db->query( "SELECT * FROM users" );

while ( $pulluserinfo = $db->fetch( $userinfo ) ) {
$one .= "" . $pulluserinfo['uID'] . ""; //uID is from the users table
$two .= "" .$pulluserinfo['Amount=Amount+1000+(TotalAmount*10)']. ""; //Amount & TotalAmount is from the users table
$three .= date("F j, Y, g:i a"); //Putting a date
$db->query( "INSERT INTO systemlog (`User`,`Amount`,`Time`) VALUES ('$one', '$two', '$three')" );
}

$db->close();
?>

Link to comment
https://forums.phpfreaks.com/topic/228955-cron-php-help/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.