quick help please

philvia

i have this..

$thismonth=(int) date("m");
$thisyear=date("Y");
$sql=@mysql_query("SELECT id,dateday,datemonth,dateyear FROM events WHERE dateyear=".$thisyear." AND datemonth=".$thismonth."");
    $eventdate=@mysql_fetch_array($sql) or die(mysql_error()) ;

and then somewhere down the lines i have this...

      if($eventdate['dateday'] == $counter) {
	        echo "<a href=\"events/index.php?id=".$eventdate['id']."\">$counter</a></td>\n";
        } else { 
	        echo "$counter</td>\n";
        }

OK so on the if statement it only links ONE of the dates, not all of them that should be. I want it to coordinate every day on a calendar that has a day in the database to link to its id. Say there's two different dates in Jan., they should both be linked on the appropriate day, but only the last one is linked. Should there be a while or for statement somewhere? I'm not sure =\

NogDog

Yes, there should be a while loop in there. See the examples #2 - #4 on the [man]mysql_fetch_array/man page.

philvia

could you suggest where or how to put it? i tried a while inside if statement and it made another link for day 14 up above the calendar and i tried the if statement inside the while and it didn't show up any of the days

i'm not sure how to do if and while together <_>

Joseph07

Try this?

while ($eventdate) {
if($eventdate['dateday'] == $counter) {
            echo "<a href=\"events/index.php?id=".$eventdate['id']."\">$counter</a></td>\n";
        } else {
            echo "$counter</td>\n";
        } }

philvia

lol that's a big noooooo

just made the number 1 repeating lol

NogDog

// do the query, then...
while($eventdate = mysql_fetch_array($sql)) {
   if($eventdate['dateday'] == $counter) {
      echo "<a href=\"events/index.php?id=".$eventdate['id']."\">$counter</a></td>\n";
   }
   else {
      echo "$counter</td>\n";
   }
}

philvia

that echos this..
1122334455667788991010111112121313141415151616171718181919202021212222232324242525262627272828292930303131
above the calendar lol

weevil

Where is the code where you are printing out the days of the month? You need the if statement, that checks if there is an event that day, inside that loop.

NogDog

philvia wrote:
that echos this..
1122334455667788991010111112121313141415151616171718181919202021212222232324242525262627272828292930303131
above the calendar lol

Probably because you left out the opening "<td>" tag in your original example, and that's what we have been copying and pasting. If that's not it, well, we cannot simply use our ESP to determine what you want your HTML output to look like.

philvia

as of right now it looks like this..

http://i15.photobucket.com/albums/a391/philvia/calendar1.jpg

and the main part of the code is this..

			[code=php]$sql=@mysql_query("SELECT id,dateday,datemonth,dateyear FROM events WHERE dateyear=".$thisyear." AND datemonth=".$thismonth."");
        	while($eventdate = mysql_fetch_array($sql)) {
				if($eventdate['dateday'] == $counter) {
  					echo "<td class=\"calendar\"><a href=\"events/index.php?id=".$eventdate['id']."\">$counter</a></td>\n";
				} else {
  					echo "<td class=\"calendar\">$counter</td>\n";
				} 
			}[/code]

this is what i want it to look like but with all the links working..

http://i15.photobucket.com/albums/a391/philvia/calendar.jpg

and the code in the pic is the same code as the first post in this thread

hope that cleared up what i wanted 😃

foyer

$prev_day = null;
while($eventdate = mysql_fetch_array($sql)) {
	if ($prev_day != $counter) {
		if($eventdate['dateday'] == $counter) {
			echo "<td class=\"calendar\"><a href=\"events/index.php?id=".$eventdate['id']."\">$counter</a></td>\n";
		} else {
			echo "<td class=\"calendar\">$counter</td>\n";
		}
	}
   $prev_day = $counter;
}