Table:
cquestions
cqid, cqtext, showdate.
I want to update ‘showdate’ field to tomorrows date…
cqid cqtext showdate
200 q1 2013-05-22
201 q2 0000-00-00
202 q3 0000-00-00
the idea is to display only one question everyday. showdate is compared with the current date and display the first question q1. the starting date only store in db. now i want to update only the next row (q2)'s showdate to tomorrows date. next day wen q2 is displayed q3 will be updated to tomorrows date.
[code]today q1 displayed. db is like this.
cqid cqtext showdate
200 q1 2013-05-22
201 q2 2013-05-23
202 q3 0000-00-00
tomorrow q2 displayed. then db
cqid cqtext showdate
200 q1 2013-05-22
201 q2 2013-05-23
202 q3 2013-05-24
203 q4 0000-00-00 [/code]
my code:
[php]$today=date(“Y/m/d”);
$tomorrow= date(“Y-m-d”, strtotime(“tomorrow”));
echo “”;
$sql=“SELECT * FROM cquestions where showdate= ‘$today’ limit 1”;
$result=mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$cqid=mysql_result($result,“cqid”);
$update1=“update cquestions set showdate=’$tomorrow’ where showdate=‘0000-00-00’ and cqid!=’$cqid’ order by cqid limit 1”;
mysql_query($update1);
echo “
” . $row[‘cqtext’] . “
”;$sql2=“SELECT * FROM canswers where cqid=”.$row[‘cqid’];
$result2=mysql_query($sql2);
while($row2=mysql_fetch_assoc($result2)){
echo “<input type=‘radio’ name=’”.$row[‘cqid’]."’ value=’".$row2[‘cqans’]."’ />".$row2[‘aatext’]; }
/echo “”;/
}
echo"";
echo “”;
?>[/php]
this code update the next row, but the problem is its executed every time page loads and update the next row… i want to execute the update query only once for the day. how to do it?