MadnessRed Posted July 24, 2008 Share Posted July 24, 2008 ok, I have installed apache, mysql and php on my computer and am runing a php calendar on it whihc I am sharing over the network. Basically each cell in that table (Day) looks to see if there is anythign happening that day. Here is my code. echo '<tr><td><span id="r"><a href="event.php?day=1&month='.$s_month.'&year='.$s_year.'">'.$add.'</a></span>01)<hr />'; $query = mysql_query("SELECT Title FROM ".$table." WHERE Day='1' AND Month='".$s_month."' AND Year='".$s_year."' GROUP BY 'Page' ;"); while ($row = mysql_fetch_array($query)){echo $row[Title];} echo '</td><td><span id="r">... I have 2 entries on 1 day. They both show in the mysql database. ID - 3 - 4 Title - Me out - Brother Out From - 12:00 - 12:30 To - 13:00 - 13:00 Where - Town - Town Who - 4 - 8 Desc - Going Out - Going Out Day - 27 - 27 Month - 7 - 7 Year - 2008 - 2008 however the table only shows the first one 27) ......... ++ Me Out Quote Link to comment Share on other sites More sharing options...
Barand Posted July 24, 2008 Share Posted July 24, 2008 Are they both on the same page? GROUP BY page will only show 1 entry per page Quote Link to comment Share on other sites More sharing options...
MadnessRed Posted July 25, 2008 Author Share Posted July 25, 2008 there is no such thing as post, so post would = "" for both. thanks, I missed that, Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.