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

Re: Else If

On Fri, 30 Nov 2007 17:07:42 +0100, wrote:

> Am trying Else-If but encounter a problem (newbie question, sorry)
>
> Step 1 - Create selection of companies ordered by a priority number.
>
> $query =3D "SELECT company, priority FROM foo1 WHERE foo2 AND priority=

> IN
> ('0', '1', '2') ORDER BY priority";
>
> $result =3D mysql_query($query) or die ('Error in query: $query . ' .
> mysql_error());
> while($row =3D mysql_fetch_object($result))

> $priority =3D $row['priority'];
> $company =3D $row['company'];

> 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')

Either use mysql_fetch_array()/mysql_fetch_assoc() and use arrays =

($row['fieldname'], or use mysql_fetch_object and use $row->fieldname.


> if ($priority == '0')
> elseif ($priority == '1')
> elseif ($priority == '2')

This seems better suited to a switch statement.
-- =

Rik Wasmus