Hi, I need to refine this. I'm tired ... long day. I would like to echo $mydata->district only once unless it changes.
echo "<table>\n"; while ($mydata = mysql_fetch_object($glquery)) { #----- if $mydata->district is different, then echo "<tr bgcolor=\"#CCCCCC\"><td>$mydata->district</td><td></td><td></td></tr>\n"; echo "<tr bgcolor=\"#CCCCCC\"><td>$mydata->city</td> <td>$mydata->place</td> <td>$mydata->meetingtime</td></tr>\n"; } echo "</table>\n"; Clarity anyone :) Thanks, J -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php