Re: What's wrong with this code?
| From: | Karl DeSaulniers | Date: | Sun, 06 Jun 2010 01:07:36 +0000 |
| Subject: | Re: What's wrong with this code? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-305854@lists.php.net to get a copy of this message | ||
So your code looks like this?
while($row = mysql_fetch_array($result3))
{
echo "<tr>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['type'] . "</td>";
echo "<td>" . $row['startdate'] . "</td>";
if (!empty($row['EndDate'])) { //This should probably be $row['enddate']
echo "<td>" . $row['enddate'] . "</td>";
}
echo "<td>" . $row['location'] . "</td>";
echo "<td>" . $row['summary'] . "</td>";
echo "<td>" . $row['description'] . "</td>";
echo "</tr>";
}
Not to mention, you have a $row['EndDate'] and a $row['enddate'].
Probably need to choose one or the other.
HTH,
Karl
On Jun 5, 2010, at 7:43 PM, David Mehler wrote:
Hi, Thanks. I took out the entire else section including the exit call, it now all processes, however $row['enddate'] is not displayed on the two records where it is set. Thanks. Dave. On 6/5/10, Karl DeSaulniers <karl@designdrumm.com> wrote:Karl DeSaulniers Design Drumm http://designdrumm.comCould the exit() be terminating it? Do you need this exit() as the else for that if statement? Try deleting just the else {}. JAT Karl Sent from losPhone On Jun 5, 2010, at 6:54 PM, David Mehler <dave.mehler@gmail.com> wrote:--PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.phpHello, I've got a while loop outputting values from a database. Briefly it looks like this: while($row = mysql_fetch_array($result3)) { echo "<tr>"; echo "<td>" . $row['name'] . "</td>"; echo "<td>" . $row['type'] . "</td>"; echo "<td>" . $row['startdate'] . "</td>"; if (!empty($row['EndDate'])) { echo "<td>" . $row['enddate'] . "</td>"; } else { exit(); } echo "<td>" . $row['location'] . "</td>"; echo "<td>" . $row['summary'] . "</td>"; echo "<td>" . $row['description'] . "</td>"; echo "</tr>"; } That's not the whole code, but it is the problem code. Some output has the ending date set, one or two records i can't remember how many i entered with one, most do not, i want the echo to be conditional. The output stops right before the if statement, echoes startdate and that's it, comment out the if block and it works fine. Thanks. Dave. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php