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 Link to comment https://forums.phpfreaks.com/topic/116500-solved-only-first-entry-is-outputted/ 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 Link to comment https://forums.phpfreaks.com/topic/116500-solved-only-first-entry-is-outputted/#findComment-599067 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, Link to comment https://forums.phpfreaks.com/topic/116500-solved-only-first-entry-is-outputted/#findComment-599591 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.