unexpected T_FOR, expecting T_CASE or T_DEFAULT or '}' error

dmacman1962

Hi All,

I am trying save myself some time and write loops for my switch statements, but this one is giving me a hard time.

switch ($key) { 
		for ($x = 1; $x <= 31; $x++) {
		echo 'case "'.$x.'":<br>';
				echo '$day = '.$x.';<br>';
				echo 'break;<br>';
				}
					}

is the code and I am trying to write out a switch statement and goes from case "1" to case "31" like this.

switch ($key) {
								case "1":
									$day = '1';
									break;
								case "2":
									$day = '2';				
									break;
								case "3":
									$day = '3';
									break;
									}
//etc to 31

Where am I missing this?

Thanks,

Don

bpat1434

Why in the world would you be using a switch for this? Just say:

$day = $key;

Heck, you could even type-cast it to make it a string if necessary.

Ah yes, and the error is because of the fact that you need a case: or default declaration before any code. So to dynamically write the switch statement, you might have to use [man]eval/man in some incarnation.

NogDog

bpat1434 wrote:
Why in the world would you be using a switch for this? Just say:
$day = $key;
...

For that matter, why have two different variables storing the same value? (You could either change the name of $key to $day wherever it gets set, or just use $key wherever you're planning to use $day.)

dmacman1962

Hi bpat,

I used the switch because I was trying to stick with some code that was working (that I did not write and did not follow completely). Some of the code came from this post here.

Here is a snippet of a more complete list of the code.

<?php
echo '<table>';
while ($row = mysql_fetch_assoc($result)) {$array[$row['Day2']][] = $row;}
foreach ($array as $key => $value)
{
$day = $key;
?>
  <tr>
    <td bgcolor=white style="padding-top:2px;padding-bottom:2px;background-image: url(../images/tab2.gif);background-repeat: no-repeat;padding-left:10px;font-family:tahoma;letter-spacing:1px;font-size:12px;font-weight:bold;color:#2E7045;border-left:1px solid #99B4C9;border-right:1px solid #99B4C9"><img src="../images/bullet-blu.gif" width="12" height="12" align="left" style="margin-top:1px;margin-right:5px" /><?php echo $day.':'; ?> </td>
  </tr>
  <?php
foreach ($value as $subvalue) {
	?>
  <tr>
    <td bgcolor=white align=center style="border-top: 1px solid #bfbfbf;border-left:1px solid #99B4C9;border-right:1px solid #99B4C9;padding:8px"> <a class="links" href="article3.php?ID=<?php echo $subvalue['ID']; ?>" onClick="NewWindow(this.href,'name','740','500','yes');return false"><font style="font-family:arial;font-weight:bold;font-size:16px"><?php echo $subvalue['Quote']; ?></font></a><br />
        <font style="color:#333333;font-size:13px"><?php echo $subvalue['Source']; ?></font></td>
  </tr>
  <?php
	}
}

?>
</table>

Where the

echo $day.':';

is displayed, I am trying to get 2006-10-09 as the end result, but I am not sure how to with the

while ($row = mysql_fetch_assoc($result)) {$array[$row['Day2']][] = $row;}
foreach ($array as $key => $value)

loop.

This is for a current events listing and it worked, but I know need to show the actual date of the event instead of the weekday name, and I could not get it to work.

I am TOTALLY open to suggestions here.

Here is the link to my test page.

And the original page.

Thanks,

Don

dmacman1962

I have this code and understand the query, but I cannot seem to extract the named pairs of info I am looking for.


$result = mysql_query('SELECT quote, source, DAYNAME(date_time) AS day FROM daily_events2 WHERE date_time BETWEEN CURDATE() - INTERVAL 6 DAY AND CURDATE() ORDER BY date_time DESC') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {$array[$row['day']][] = $row['quote'];}

foreach ($array as $key => $value)
<b>{
    echo '<b>' . $key . '</b><br>';
    foreach ($value as $subvalue) {echo ' - ' . $subvalue . '<br>';}
    echo '<br>';
}

I get...

Friday
- Izzit Friday?
- Izzit also Friday?

Thursday
- N. Korea Pledges Nuclear Test

But I am trying to get also

Friday 10-6-2006
- Izzit Friday?
- Izzit also Friday?

Thursday 10-5-2005
- N. Korea Pledges Nuclear Test

I can only get the quote with the above code and cannot get multiple fields at once.

What am I missing here?

Thanks in advance,

Don

bpat1434

YOu need to get the date from the returned result 😉 You account for the query, but not the date. add it to your array and call accordingly below it. Personally, I'd do something more along the lines of:

 $result = mysql_query('SELECT quote, source, date_time FROM daily_events2 WHERE date_time BETWEEN CURDATE() - INTERVAL 6 DAY AND CURDATE() ORDER BY date_time DESC') or exit(mysql_error());

while ($row = mysql_fetch_assoc($result)) { $array[$row['date_time']][] = $row['quote']; }

foreach($array as $dt=>$value)
{
  echo '<b>' . date('l', $dt) . ' '. date('m-d-Y', $dt) . '</b><br>';

  foreach($value as $val) { echo ' - ' . $val . '<br>'; }

  echo '<br>';
}

That looks a lot cleaner 😉 YOu could do it within the mySQL function like below too:

$result = mysql_query('SELECT quote, source, DAYNAME(date_time) AS day, DATE_FORMAT(date_time, '%m-%e-%Y') AS `date` FROM daily_events2 WHERE date_time BETWEEN CURDATE() - INTERVAL 6 DAY AND CURDATE() ORDER BY date_time DESC') or exit(mysql_error());

while($row = mysql_fetch_array($result)) { $array[$row['day'].' '.$row['date']][] = $row['quote']; }

foreach($array as $day=>$value)
{
  echo '<b>' . $day . '</b><br>';

  foreach($value as $subvalue) { echo ' - ' . $subvalue . '<br>'; }

  echo '<br>';
}

Either method is acceptable. It's up to you to choose.