The closing else is not bracketed.
Have you echoed the vars & confirmed values therein? It's amazing how often that will catch you.
Otherwise simplicate: comment out a bunch of stuff and build it up bit by bit, echoing all the while.
Miles Thompson


At 02:07 PM 6/4/2003 -0600, Earl wrote:
Sorry about that I did not get the closing tag when i copied the code.
I did as you said and it still gave the same problem.
below is the complete code
------------------------------------------------
$eventQuery=ifx_query('select * from event'
      .' where e_date >= today '
      .' and e_status in ("O","C") '
       .' and out_id is not null '
      .' order by s_acro, e_acro ',$db) or die (ifx_error());

while($cols=ifx_fetch_row($eventQuery))
 {
  if ($cols['out_type']=='0')
   {
    $r_away['linetype']='L';
    $r_home['linetype']='L';
   }

  elseif ($cols['out_type']=='1')
   {
    $r_away['linetype']='H';
    $r_home['linetype']='H';
   }

  if (($cols['s_acro']=='CF') || ($cols["s_acro"]=='PF'))
   {
    $r_away['sport']='1';
    $r_home['sport']='1';
    $s_lt='PS';
    $t_lt='TP';
   }

  elseif (($cols['s_acro']=='PB') || ($cols['s_acro']=='CB'))
   {
    $r_away['sport']='2';
    $r_home['sport']='2';
    $s_lt='PS';
    $t_lt='TP';
   }

  elseif ($cols['s_acro']=='B')
   {
    $r_away['sport']='3';
    $r_home['sport']='3';
    $s_lt='ML';
    $t_lt='TM';
   }

  else
    $r_away['sport']='4';
    $r_home['sport']='4';
    $s_lt='ML';
    $t_lt='TM';


$r_away['rotation']=$cols['out_id']; $r_home['rotation']=($r_away['rotation'] + 1);

echo "".$r_away['rotation']." , ".$r_home['rotation']." ,
".$r_away['linetype']." , ".$r_home['linetype']." , ".$r_away['sport']." ,
".$r_home['sport']."\n";
 }
-------------------------------------------------



----- Original Message -----
From: "Becoming Digital" <[EMAIL PROTECTED]>
To: "PHP-DB" <[EMAIL PROTECTED]>
Sent: Wednesday, June 04, 2003 1:52 PM
Subject: Re: [PHP-DB] while - if problem


> You don't have a closing bracket on your while() loop and you should not have > the else comments bracketed. Try this: > > while($cols=ifx_fetch_row($eventQuery)) > { > if (($cols['s_acro']=='CF') || ($cols["s_acro"]=='PF')) > { > $r_away['sport']='1'; > $r_home['sport']='1'; > $s_lt='PS'; > $t_lt='TP'; > } > > elseif (($cols['s_acro']=='PB') || ($cols['s_acro']=='CB')) > { > $r_away['sport']='2'; > $r_home['sport']='2'; > $s_lt='PS'; > $t_lt='TP'; > } > > elseif ($cols['s_acro']=='B') > { > $r_away['sport']='3'; > $r_home['sport']='3'; > $s_lt='ML'; > $t_lt='TM'; > } > > else > $r_away['sport']='4'; > $r_home['sport']='4'; > $s_lt='ML'; > $t_lt='TM'; > } > > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > ----- Original Message ----- > From: "Earl" <[EMAIL PROTECTED]> > To: "PHP-DB" <[EMAIL PROTECTED]> > Sent: Wednesday, 04 June, 2003 15:44 > Subject: [PHP-DB] while - if problem > > > Hey guys, I've got a problem with this piece of code.... > it is skipping the contents of the if and elseif statements and only printing > the else values, even though the if or one of the elseif statements might be > true. > what could possibly be the problem?? > > -------------------------------------------------------------------------- ------ > ------------ > $eventQuery=ifx_query('select * from eventtable' > .' where e_date >= today ' > .' and e_status in ("O","C") ' > .' and out_id is not null ' > .' order by s_acro, e_acro ',$db) or die (ifx_error()); > > while($cols=ifx_fetch_row($eventQuery)) > { > if (($cols['s_acro']=='CF') || ($cols["s_acro"]=='PF')) > { > $r_away['sport']='1'; > $r_home['sport']='1'; > $s_lt='PS'; > $t_lt='TP'; > } > > elseif (($cols['s_acro']=='PB') || ($cols['s_acro']=='CB')) > { > $r_away['sport']='2'; > $r_home['sport']='2'; > $s_lt='PS'; > $t_lt='TP'; > } > > elseif ($cols['s_acro']=='B') > { > $r_away['sport']='3'; > $r_home['sport']='3'; > $s_lt='ML'; > $t_lt='TM'; > } > > else { > $r_away['sport']='4'; > $r_home['sport']='4'; > $s_lt='ML'; > $t_lt='TM'; > } > -------------------------------------------------------------------------- ------ > ------------ > output is always: 4, ML, TM > > > thanks in advance > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to