Parse error: syntax error, unexpected T_ELSE

[dbdummy]

I am getting this error...and don't know why. Can anyone help with this code?

<?php
$institutionname = $_POST['institutionname'];
$query_payment = "SELECT * FROM test_tbl WHERE institutionname = '$institutionname' AND expired = '0'";
$institutionypayment = mysql_query($query_contact) or die("Problem with the query: $query_payment<br>" . mysql_error());
$row = mysql_fetch_assoc($institutionpayment);
if (isset($row['expired']) && $row['expired']=="0") {
{
 	// redirect to affiliate page
?>
	<meta http-equiv="refresh" content="0;URL=https://mysite.com/membership06/memberaffiliateapp.php">
<?php
}  

else
{
    // redirect to unpaid membership page
?>
	<meta http-equiv="refresh" content="0;URL=https://mysite.com/membership06/unpaid.php">
<?php
}      

?>

[Installer]

You have two opening braces for your "if" clause.

[Houdini]

OK so which line is the one causing the problem?

[dbdummy]

it was definitely the extra opening brace (thanks : )). then I discovered a couple of other problems like I didn't want to only query where expired = '0'.

What I want is if the member institution isn't expired '0', then it goes to one page page, if the institution is expired, then it takes them to another page.

So, now I have a new problem

"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource..."

I have tried mysql_fetch_row, assoc, etc.

<?php
$institutionname = $_POST['institutionname'];
$query_payment = "SELECT expired FROM test_tbl WHERE institutionname = '$institutionname'";
$institutionypayment = mysql_query($query_payment) or die("Problem with the query: $query_payment<br>" . mysql_error());
$row = mysql_fetch_array($institutionpayment);
if (isset($row['expired']) && $row['expired']=="0") {
// redirect to affiliate page
?>
<meta http-equiv="refresh" content="0;URL=https://mysite.com/membership06/memberaffiliateapp.php">
<?php
}
else
{
// redirect to unpaid membership page
?>
	<meta http-equiv="refresh" content="0;URL=https://mysite.com/membership06/unpaid.php">
<?php
}      

?>

many thanks

[Houdini]

Ido not see where you connected to the database or selected a database in the above script, this would cause that error.

[dbdummy]

it's connecting to the database earlier in the script, I just didn't add that as that seemed unimportant (at the time,) and it definitely posts the $institutionname (I echoed that just to make sure.)

any other thoughts?

thanks

: )

[dbdummy]

okay, my bad...there was an extra y in $institutionypayment in the query...this is resolved...now to see if there is a resolved button somewhere.

[Weedpacket]

dbdummy wrote:

now to see if there is a resolved button somewhere.

Under the Thread Tools menu.

there was an extra y in $institutionypayment in the query

Which is why you should do your development with error_reporting set to E_ALL.