Re: [PHP] What's wrong with this code?

[Karl DeSaulniers]

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 <k...@designdrumm.com> 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.meh...@gmail.com>  
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