Re: Else If
- From: "Rik Wasmus" <luiheidsgoeroe@xxxxxxxxxxx>
- Date: Fri, 30 Nov 2007 18:32:07 +0100
On Fri, 30 Nov 2007 17:07:42 +0100, <sales@xxxxxxxxxxxxxxxxxx> wrote:
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))
$priority = $row['priority'];
$company = $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
.
- References:
- Else If
- From: sales
- Else If
- Prev by Date: Re: Joomla?
- Next by Date: Re: SQLite PDO numRows problem
- Previous by thread: Else If
- Next by thread: getting values of checkboxes.
- Index(es):
Relevant Pages
|
