Jump to content

[SOLVED] Only first entry is outputted?


MadnessRed

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.