Could it be that you are not using the same variable name? In the if statement you are using $row['EndDate'] and when attempting to print you are using $row['enddate']. I think you need to be consistent about which capitalization you use (and make sure it matches what is in the db).
>>> if (!empty($row['EndDate'])) {
>>> echo "<td>" . $row['enddate'] . "</td>";
>>> }
On Jun 5, 2010, at 5: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@xxxxxxxxxxxxxxx> wrote:
>> Could 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@xxxxxxxxx> wrote:
>>
>>> Hello,
>>> 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
>>
>>
>
> --
> 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
