Posted by Rik Wasmus on 11/30/07 17:32

On Fri, 30 Nov 2007 17:07:42 +0100, <sales@freeweekends.co.uk> 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 =3D=3D '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 =3D=3D '0')
> elseif ($priority =3D=3D '1')
> elseif ($priority =3D=3D '2')

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

Rik Wasmus

[Back to original message]