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

if ($row[Home/Away]=="Home") {

 

 

All you have to do is look at your other IF statements.  And honestly, if you don't know where it goes, you may want to read up more on PHP.

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

Archived

This topic is now archived and is closed to further replies.

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