Jump to content

[SOLVED] If Else


bravo14

Recommended Posts

Hi all

 

I am trying to display a list of fixtures using if statements.

 

If the Home/Away field is Home I want it to display the fixtures in one way and if it is Away I want it to show another way, I have had a stab at it but am getting an error message on the page at www.yardleyheroes.co.uk/fixtures.php

 

$result = mysql_query('SELECT FROM fixtures ORDER BY date', $con) or die(mysql_error());
if(mysql_num_rows($result) < 1) 
{ 
   echo('<tr class="profiletext"><td colspan="6">Sorry, no results were found.</td></tr>'); 
} 
else 
{ 
   while($row = mysql_fetch_array($result))
    {
if ($row[Home/Away]=="Home")
echo ('<tr><td>'.$row[Date].'</td><td><b>Yardley</b></td>');
echo ('<td>'.$row[yardley_goals].'-'.$row[opposition_goals].'</td><td>'.$row[Opposition].'</td>');
echo ('<td></td><td><a href="http://www.yardleyheroes.co.uk/matchfines.php?match_id='.$row[match_id].'"View Fines</a></td></tr>');

else{

echo ('<tr><td>'.$row[Date].'</td><td>'.$row[Opposition]'</td>');
echo ('<td>'.$row[opposition_goals].'-'.$row[yardley_goals].'</td><td>Yardley</td>');
echo ('<td></td><td><a href="http://www.yardleyheroes.co.uk/matchfines.php?').$row[match_id].'<a></td></tr>');
}
}
mysql_close($con);
?>

 

Cheers

 

Mark

Link to comment
Share on other sites

$result = mysql_query('SELECT FROM fixtures ORDER BY date', $con) or die(mysql_error());
if(mysql_num_rows($result) < 1) 
{ 
   echo('<tr class="profiletext"><td colspan="6">Sorry, no results were found.</td></tr>'); 
} 
else 
{ 
   while($row = mysql_fetch_array($result))
    {
if ($row[Home/Away]=="Home")
echo ('<tr><td>'.$row[Date].'</td><td><b>Yardley</b></td>');
echo ('<td>'.$row[yardley_goals].'-'.$row[opposition_goals].'</td><td>'.$row[Opposition].'</td>');
echo ('<td></td><td><a href="http://www.yardleyheroes.co.uk/matchfines.php?match_id='.$row[match_id].'"View Fines</a></td></tr>');
       }

else{

echo ('<tr><td>'.$row[Date].'</td><td>'.$row[Opposition]'</td>');
echo ('<td>'.$row[opposition_goals].'-'.$row[yardley_goals].'</td><td>Yardley</td>');
echo ('<td></td><td><a href="http://www.yardleyheroes.co.uk/matchfines.php?').$row[match_id].'<a></td></tr>');
        }
}
}
mysql_close($con);
?>

 

There you go.  You missed like 2 braces.  Be careful.  { } needs to go around everything you want executed in the if/else blocks (or any loop for that matter).

Link to comment
Share on other sites

Thank you for your quick response

 

I have copied that text over  so it now looks like

 

$result = mysql_query('SELECT FROM fixtures ORDER BY date', $con) or die(mysql_error());
if(mysql_num_rows($result) < 1) 
{ 
   echo('<tr class="profiletext"><td colspan="6">Sorry, no results were found.</td></tr>'); 
} 
else 
{ 
   while($row = mysql_fetch_array($result))
    {
if ($row[Home/Away]=="Home")
echo ('<tr><td>'.$row[Date].'</td><td><b>Yardley</b></td>');
echo ('<td>'.$row[yardley_goals].'-'.$row[opposition_goals].'</td><td>'.$row[Opposition].'</td>');
echo ('<td></td><td><a href="http://www.yardleyheroes.co.uk/matchfines.php?match_id='.$row[match_id].'"View Fines</a></td></tr>');
       }

else{

echo ('<tr><td>'.$row[Date].'</td><td>'.$row[Opposition]'</td>');
echo ('<td>'.$row[opposition_goals].'-'.$row[yardley_goals].'</td><td>Yardley</td>');
echo ('<td></td><td><a href="http://www.yardleyheroes.co.uk/matchfines.php?').$row[match_id].'<a></td></tr>');
        }
}
}
mysql_close($con);
?>

and get the following error message

 

Parse error: syntax error, unexpected T_ELSE in /home/fhlinux147/y/yardleyheroes.co.uk/user/htdocs/fixtures.php on line 64

 

Line 64 is else{

 

Any ideas?

 

Cheers Mark

Link to comment
Share on other sites

Thanks for all your help guys, still geting error message

 

Parse error: syntax error, unexpected '[' in /home/fhlinux147/y/yardleyheroes.co.uk/user/htdocs/fixtures.php on line 58

 

$result = mysql_query('SELECT * FROM `fixtures` ORDER BY `date`', $con) or die(mysql_error());
if(mysql_num_rows($result) < 1) 
{ 
   echo('<tr class="profiletext"><td colspan="7">Sorry, no results were found.</td></tr>'); 
} 
else 
{ 
   while($row = mysql_fetch_array($result))
    {
if ($row.[HomeAway].=="Home") {
echo ('<tr><td>'.$row[Date].'</td><td><b>Yardley</b></td>');
echo ('<td>'.$row[yardley_goals].'-'.$row[opposition_goals].'</td><td>'.$row[Opposition].'</td>');
echo ('<td></td><td><a href="http://www.yardleyheroes.co.uk/matchfines.php?match_id='.$row[match_id].'"View Fines</a></td></tr>');
       }

else{

echo ('<tr><td>'.$row[Date].'</td><td>'.$row[Opposition].'</td>');
echo ('<td>'.$row[opposition_goals].'-'.$row[yardley_goals].'</td><td>Yardley</td>');
echo ('<td></td><td><a href="http://www.yardleyheroes.co.uk/matchfines.php?'.$row[match_id].'<a></td></tr>');
        }
}
}
mysql_close($con);
?>

 

Line 58 is if ($row.[HomeAway].=="Home") {

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.