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
