Kind of new but need some help.

[Ember]

Sorry for the long bit of posting here but I can't find my error. I have stared at this for a few hours now. I'm kind of new to PHP but I would say I know a bit more than a newbie. Here is the code. Let me know if you can find it. The browser keeps telling me on line 330 but we all know how awesome the browser trouble shoots for us.

<?php
	$db = mysql_pconnect('localhost', 'menu', 'system');
		if (!$db)
  		{
     		echo 'Error: Could not connect to database.  Please try again later.';
     		exit;
  		}
	mysql_select_db('menus');
	echo '<br />';
	$mpstatus = 0;
	$denstatus = 0;

if (date("l") == "Saturday")
{
	if (date("G") >= "8" || date("G") < "20")
	{
		$mpstatus = 1;
	}	
	if (date("G") >= "10" || date("G") < "19")
	{
		$denstatus = 1;
	}
	if ($mpstatus == 1)
	{
		if (date("G") >= "8" && date("G") < "11")
		{
			$mpmeal = "Breakfast";
		}
		if (date("G") > "11" && date("G") < "15")
		{
			$mpmeal = "Lunch";
		}
		if (date("G") >= "15")
		{
			$mpmeal = "Dinner";
		}
	}
	if ($denstatus == 1)
	{
		if (date("G") >= "10" && date("G") < "11")
		{
			$denmeal = "Breakfast";
		}
		if (date("G") > "11" && date("G") < "15")
		{
			$denmeal = "Lunch";
		}
		if (date("G") >= "15")
		{
			$denmeal = "Dinner";
		}
	}
}

if (date("l") == "Sunday")
{
	if (date("G") >= "10" || date("G") < "20")
	{
		$mpstatus = 1;
	}	
	if (date("G") >= "10" || date("G") < "19")
	{
		$denstatus = 1;
	}
	if ($mpstatus == 1)
	{
		if (date("G") >= "10" && date("G") < "11")
		{
			$mpmeal = "Breakfast";
		}
		if (date("G") > "11" && date("G") < "15")
		{
			$mpmeal = "Lunch";
		}
		if (date("G") >= "15")
		{
			$mpmeal = "Dinner";
		}
	}
	if ($denstatus == 1)
	{
		if (date("G") >= "10" && date("G") < "11")
		{
			$denmeal = "Breakfast";
		}
		if (date("G") > "11" && date("G") < "15")
		{
			$denmeal = "Lunch";
		}
		if (date("G") >= "15")
		{
			$denmeal = "Dinner";
		}
	}
}

if (date("l") == "Monday" || date("l") == "Tuesday" || date("l") == "Wednesday" || date("l") == "Thursday")
{
	if (date("G") >= "7" || date("G") < "21")
	{
		$mpstatus = 1;
	}	
	if (date("G") >= "7" || date("G") < "20")
	{
		$denstatus = 1;
	}
	if ($mpstatus == 1)
	{
		if (date("G") >= "7" && date("G") < "11")
		{
			$mpmeal = "Breakfast";
		}
		if (date("G") > "11" && date("G") < "15")
		{
			$mpmeal = "Lunch";
		}
		if (date("G") >= "15")
		{
			$mpmeal = "Dinner";
		}
	}
	if ($denstatus == 1)
	{
		if (date("G") >= "7" && date("G") < "11")
		{
			$denmeal = "Breakfast";
		}
		if (date("G") > "11" && date("G") < "15")
		{
			$denmeal = "Lunch";
		}
		if (date("G") >= "15")
		{
			$denmeal = "Dinner";
		}
	}
}

if (date("l") == "Friday")
{
	if (date("G") >= "7" || date("G") < "20")
	{
		$mpstatus = 1;
	}	
	if (date("G") >= "7" || date("G") < "20")
	{
		$denstatus = 1;
	}
	if ($mpstatus == 1)
	{
		if (date("G") >= "7" && date("G") < "11")
		{
			$mpmeal = "Breakfast";
		}
		if (date("G") > "11" && date("G") < "15")
		{
			$mpmeal = "Lunch";
		}
		if (date("G") >= "15")
		{
			$mpmeal = "Dinner";
		}
	}
	if ($denstatus == 1)
	{
		if (date("G") >= "7" && date("G") < "11")
		{
			$denmeal = "Breakfast";
		}
		if (date("G") > "11" && date("G") < "15")
		{
			$denmeal = "Lunch";
		}
		if (date("G") >= "15")
		{
			$denmeal = "Dinner";
		}
	}
}

if ($denstatus == 1)
{
	$query = "select menu from den where ((day = '" . date("l") . "') and (meal = '" . $denmeal . "'))";
	$result = mysql_query($query);
	$num_results = mysql_num_rows($result); 
	echo '<b>Now Serving @ the Wildcat Den:</b>';
	for ($i=0; $i <$num_results; $i++)
	{
		$row = mysql_fetch_array($result);
		echo '<br />';
		echo (stripslashes($row['menu']));
	}
} else {
	echo 'The Wildcat Den is currently closed';
}

echo '<hr align="center" width="75%">';		

if ($mpstatus == 1)
{
	$querymp = "select menu from mp where ((day = '" . date("l") . "') and (meal = '" . $mpmeal . "'))";
	$resultmp = mysql_query($querymp);
	$num_resultsmp = mysql_num_rows($resultmp); 
	echo '<b>Now Serving @ Marketplace:</b>';
	for ($i=0; $i <$num_resultsmp; $i++)
	{
		$rowmp = mysql_fetch_array($resultmp);
		echo '<br />';
		echo (stripslashes($rowmp['menu']));
	}
} else {
	echo 'Marketplace is currently closed';
}
mysql_close();
}
?>

Thanks

If you have any suggestions email me [e-mail] or hit me up on a messenger
AIM: Emb3rX
MSN: [e-mail]
Yahoo!: [e-mail]

[Shock_CNOP]

What's the exact error that you're seeing?

I find what you stated unusual because this script doesn't even have 330 lines... 😕

[halojoy]

The browser keeps telling me on line 330

Open the PHP source code
in an editor
and
turn on line numbers line numbering

this will keep us from trouble finding out what line it is

[Ember]

I have that turned on already but I can't find the error anywhere near where it is saying the problem. It actually says line 327 and that is this line (denoted with arrow).

	if ($mpstatus == 1)
	{
		$querymp = "select menu from mp where ((day = '" . date("l") . "') and (meal = '" . $mpmeal . "'))";
		$resultmp = mysql_query($querymp);
		$num_resultsmp = mysql_num_rows($resultmp); 
		echo '<b>Now Serving @ Marketplace:</b>';
--------->for ($i=0; $i <$num_resultsmp; $i++)
 		{
    		$rowmp = mysql_fetch_array($resultmp);
			echo '<br />';
    		echo (stripslashes($rowmp['menu']));
    	}
	} else {
		echo 'Marketplace is currently closed';
	}

I'm all out of ideas

[halojoy]

Ember wrote:

I have that turned on already but I can't find the error anywhere near where it is saying the problem. It actually says line 327 and that is this line (denoted with arrow).
I'm all out of ideas

<?php
error_reporting( E_ALL );  // turns on PHP debugging

// rest of your code

?>

And what exactly is the error message you get .....
It was asked in a previous post, too
by another member

Copy and paste it here for us,
and we will solve this

thinks halojoy
🆒

[Ember]

It just states
"Parse error: parse error in C:\Inetpub\wwwroot\dining\index2.php on line 328"

[halojoy]

I can see no parse error in the line you marked
the
FOR ($i;$i<$num;$i++) LOOP

but sometimes the error can be a missing { or }
somewhere else

[Ember]

wow after all that it was because of an EXTRA } at the end right before the closing of the php! Thanks for checking back halojoy. Appreciate it.

[Weedpacket]

Incidentally, the browser doesn't count line numbers in your PHP script because the browser never sees your PHP script. Line numbers are counted by PHP.

And I don't know what you're complaining about: Firefox is very good at identifying the location of Javascript bugs.

[Ember]

Not really complaining I just couldn't understand the issue with the whole thing. As with most issues it was just some small thing that I forgot to check.

[Weedpacket]

I was referring to this bit: "...but we all know how awesome the browser trouble shoots for us. "