|
|
Posted by J.O. Aho on 10/18/07 16:53
Jerry Stuckle wrote:
> Alec wrote:
>> What am I doing wrong with this elseif condition?
>>
>> $query = "SELECT company, priority FROM companyid_uks49179 WHERE
>> town='Bury St. Edmunds' AND category='sleep' AND priority IN
>> ('1', '2', '3') ORDER BY priority";
>>
>> This returns a result set of a number of companies with different
>> priority numbers from 1 to 3. see webpage
>> http://www.freeweekends.co.uk/test3.php
>>
>> I now want to create a table result for each one, with an 'elseif'
>> statement creating a different effect for each of the three different
>> priorities.
>>
>> $result = mysql_query($query) or die ('Error in query: $query. ' .
>> mysql_error());
>>
>> echo '<table border=1 cellpadding=10>';
>>
>> while($row = mysql_fetch_object($result))
>>
>> {
>> $priority = $row['priority'];
> Maybe it should be
>
> if ($priority == 1) ...
>
> And J.O.'s suggestion to use switch is good.
>
The $row is a object, and he tries to use it as an array, so $priority is
nothing/null, which mean it never can be 1,2 and therefore always will fall in
the last else-statement.
--
//Aho
Navigation:
[Reply to this message]
|