Re: Need help with coding problem

You seem to be missing your last bracket for the while loop that you started to state the end of the block. "Ben C." <benc@cox.net> wrote in message news:AIEKJHFHCPDJIKLELPKEKEILEOAA.benc@cox.net... > I have a subscription service and am trying to not allow the buyer to > proceed purchasing another subscription if one of their subscriptions is > over 29 days past due in their payment. I am trying to query each invoice > and checking to see if it is past due more than 29 days, if it is I want a > message to come up saying that it can not proceed because they account is > not current. Can you look at the code below and let me know if you see > something wrong. It is not working for me. Thanks. > > > ------START CODE---------------------------------------------------------- > > $sql_1 ="SELECT * FROM $table_name > WHERE buyerid = \"$buyerid\" AND paidinfull is NULL"; > $result_1 = @mysql_query($sql_, $connection) or die("Error #" . > mysql_errno() . ": " . mysql_error()); > > if(mysql_num_rows($result_1) > 0){ > while($row = mysql_fetch_array($result_1)) { > > $duedate1 = $row['duedate']; > $paiddate1 = $row['paiddate']; > $paidinfull = $row['paidinfull']; > > $duedatestamp = strtotime($duedate1); // due date unix > timestamp > $difference = time() - $duedatestamp; // diff in seconds > $differencedays = $difference / 86400; // 60 x 60 x 24 hours floor > rounds the days down > $differencedays1 = floor($differencedays); > > $paiddatestamp = strtotime($paiddate1); // paid date unix timestamp > $diffdays = floor(((paiddatestamp - duedatestamp) / 86400)); > > > if (!$paiddate1) > { > $daysout = $differencedays1; > } > else > { > $daysout = $diffdays; > } > > if ($daysout > 29) > { > echo "You cannot add this product as your account is 30 days past due"; > exit; > } > > ----END CODE-------------------------------------------------------------- > > > > -------------------------------------------------------------------------- > The content of this email message and any attachments are confidential and > may be legally privileged, intended solely for the addressee. If you are > not the intended recipient, be advised that any use, dissemination, > distribution, or copying of this e-mail is strictly prohibited. If you > receive this message in error, please notify the sender immediately by reply > email and destroy the message and its attachments. >