Zaaka

Hello Barand, I have been trying to use this script to show the moon phases but I just keep getting broken image links, could you assist?

Didnt work at first but changed : if( $dispYear === null ) { $dispYear = ' '; To if( $dispYear === $curYear ) { $dispYear = ' '; And it works Great, Thankyou for your help.

so how do i apply it to the following : <?php do { ?> <tr> <td width="50"><?php echo $row_Recordset1['ctYear']; ?></td> <<<< Problem Line <td><?php echo $row_Recordset1['ctComp']; ?></td> <td width="60"><div align="center"><?php echo $row_Recordset1['ctpYear']; ?></div></td> <td width="50"><div align="center"><?php echo $row_Recordset1['ctLvl']; ?></div></td> <td width="50"><div align="center"><?php echo $row_Recordset1['ctpup']; ?></div></td> <td width="40" align="right"> <a href="vctinfo.php?s=<?php echo $row_Recordset1['o']; ?>">VIEW </a></td> <td width="40">- <a href="ectinfo.php?s=<?php echo $row_Recordset1['o']; ?>">EDIT</a></td> <td width="40">- <a href="dctinfo.php?o=<?php echo $row_Recordset1['o']; ?>&s=<?php echo $row_Recordset1['F1']; ?>">DEL</a></td> </tr> <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

I have the following query string : $query_Recordset2 = sprintf("SELECT DISTINCT ctYear, o, F1, ctComp, ctpYear, ctLvl,ctpup, ctTrainers, ctNotes FROM mainsheet WHERE F1 = %s", GetSQLValueString($colname_Recordset2, "int")); produced by Dreamweaver CS3, but I cannot get it to do what I need. I have a list of dates eg 2008/9 ,and a list of months but dont want the year duplicated. This is what I have: YearMonth 2007/8September 07 2007/8October 07 2007/8November 07 2007/8January 08 2007/8August 08 2008/9January 09 This is what I need: YearMonth 2007/8September 07 [/td]October 07 November 07 January 08 2008/9January 09 But the DISTINCT command wont work