Re: What's wrong with this code?

[Karl DeSaulniers <karl@xxxxxxxxxxxxxxx>]

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@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

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php