Posted by GM on 01/23/06 10:51
Hi All
I'm trying to create a loop in PHP which will do the following for me :-
1. Get a count of rows from a table where the current time is greater than
the expired_time.
2. Based on that, we need to get the customercode from that table, to be
able to get an e-mail address from another table where the customercode
matches.
3. Send a notification to the email address to inform the client that the
time has expired.
For now, I have left out the e-mail address part as well as the actual
e-mail sending part. I guess that will happen in the same loop. For now, I
am just trying to get a list of the customercodes. Don't know if i'm on the
right track here...
<?
include "../includes/mysqlcon.php";
echo "hello...";
$current_time = date("Y-m-d H:i:s");
$count = mysql_query("SELECT count(nid) FROM nack_ack where '$current_time'
> date_expired");
$numrows = mysql_num_rows($count);
$i = 1;
while ($i <= $numrows) {
$querycustomercode = mysql_fetch_row(mysql_query("SELECT * from nack_ack
WHERE nid = '$i'"));
$customercode = $querycustomercode[1];
echo $customercode;
}
?>
[Back to original message]
|