Else If

Am trying Else-If but encounter a problem (newbie question, sorry)

Step 1 - Create selection of companies ordered by a priority number.

$query = "SELECT company, priority FROM foo1 WHERE foo2 AND priority
IN
('0', '1', '2') ORDER BY priority";

$result = mysql_query($query) or die ('Error in query: $query . ' .
mysql_error());
while($row = mysql_fetch_object($result))

Step 2 - I want to output the data in differing table formats
depending upon each of the priority numbers - hence Else If. Am just
displaying the variable values below for simplicity.

{
$priority = $row['priority'];
$company = $row['company'];

if ($priority == '0')
{
echo $company;
echo $priority;
}

elseif ($priority == '1')
{
echo $company;
echo $priority;
}

elseif ($priority == '2')
{
echo $company;
echo $priority;
}

}

The ElseIf however does not recognise if $priority equals either 1 or
2, even though it does, and it outputs only the condition for if
($priority == '0')

What am I doing wrong?????

Thanks

Alec
.

Relevant Pages

  • Problems with Elseif
    ... What am I doing wrong with this elseif condition? ... ORDER BY priority"; ... echo ''; ...
    (alt.php)
  • Re: Problems with Elseif
    ... ORDER BY priority"; ... I now want to create a table result for each one, with an 'elseif' ... echo ''; ...
    (alt.php)
  • Re: macros do not work the same on different computers
    ... one of the top-level selections, no matter which selection they choose ... .Add "Addition, Deletion, or Priority" ...
    (microsoft.public.word.vba.general)
  • Re: WHEN-ELSE vs CASE statement
    ... as that will generate a mux instead of a long priority selection chain. ... requires overlapping cases. ... Synthesis is not free to create priority logic based on a keyword alone. ... The if statement with zero or one else clauses. ...
    (comp.lang.vhdl)
  • Re: 1.9 patch computer question
    ... This is the affinity selection in task manager. ... Some games don't like running on multiple CPU's. ... > The games priority is just that, ... DVD burn. ...
    (alt.games.warcraft)