|
|
Posted by Jerry Stuckle on 10/18/07 18:10
J.O. Aho wrote:
> 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.
>
Ah, I missed that one. Good catch! I just always use
mysql_fetch_array(). :-)
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|