php - mysql select statement to pick only newly inserted records after cron job run -

i want select , use new records have been inserted between cron job runs , next run. in sense don't repeat data or records worked on earlier.

from select statement below, please direct me, thank you.

// select statement should pick fresh records after first cron $sql = "select name,amount, trans_id, msisdn, time_paid customer"; $result1 = mysqli_query($conn, $sql); $resultarr = mysqli_fetch_assoc($result1); // fetch data $name = $resultarr['name']; $amount = $resultarr['amount']; $transaction_id = $resultarr['trans_id']; $date = $resultarr['time_paid']; 

this important because data used send sms , don't want send sms twice someone.

kindly, anyone?

if want details of newly inserted data, add new column in table add_date. check add_date equals current date. if yes details of every day's new date. can use below code.

$today = date("y-m-d"); $check_new_data = mysql_query("select name,amount, trans_id, msisdn, time_paid  customer add_date='$today'");  while($check = mysql_fetch_array($check_new_data)) {             echo "what ever date need"; }