Hello everyone, Much thanks. Sometimes when you stare at code for so long it blurs together, that's how it is with me at least. That was my problem, case sensitive variable. Thanks a lot. Dave. On 6/5/10, Mari Masuda <mari.masuda@xxxxxxxxxxxx> wrote: > 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