Re: What's wrong with this code?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux