subject:"\[PHP\-DB\] while \- if problem"

Re: [PHP-DB] while - if - problem

2003-06-06 Thread Earl

Hey thanks Mike
that surly made a difference.

Earl
'
- Original Message -
From: "Ford, Mike [LSS]" <[EMAIL PROTECTED]>
To: "'Earl'" <[EMAIL PROTECTED]>; "PHP-DB" <[EMAIL PROTECTED]>
Sent: Thursday, June 05, 2003 6:13 AM
Subject: RE: [PHP-DB] while - if - problem


> > -Original Message-
> > From: Earl [mailto:[EMAIL PROTECTED]
> > Sent: 04 June 2003 22:04
> > To: PHP-DB
> >
> > FYI
> > this was beginning to bug me out... so I decided to try the
> > trim function
> > and walla... it worked.
> >
> > Thanks for ya'll assistance.
>
> I was going to say this even before you added the trim() calls in , but
this
> really does look like an excellent situation for using the switch
construct
> (just look at all those trim() calls and array accesses you save!):
>
>
> while($cols=ifx_fetch_row($eventQuery))
> {
>   switch (trim($cols['out_type']))
>   {
> case '0':
>   $r_away['linetype']='L';
>   $r_home['linetype']='L';
>   break;
>
> case '1':
>   $r_away['linetype']='H';
>   $r_home['linetype']='H';
>   break;
>   }
>
>   switch (trim($cols["s_acro"]))
>   {
> case 'CF':
> case 'PF':
>   $r_away['sport']='1';
>   $r_home['sport']='1';
>   $s_lt='PS';
>   $t_lt='TP';
>   break;
>
> case 'PB':
> case 'CB':
>   $r_away['sport']='2';
>   $r_home['sport']='2';
>   $s_lt='PS';
>   $t_lt='TP';
>   break;
>
> case 'B':
>   $r_away['sport']='3';
>   $r_home['sport']='3';
>   $s_lt='ML';
>   $t_lt='TM';
>   break;
>
> case 'H':
>   $r_away['sport']='4';
>   $r_home['sport']='4';
>   $s_lt='ML';
>   $t_lt='TM';
>   break;
>   }
>
> Cheers!
>
> Mike
>
> -
> Mike Ford,  Electronic Information Services Adviser,
> Learning Support Services, Learning & Information Services,
> JG125, James Graham Building, Leeds Metropolitan University,
> Beckett Park, LEEDS,  LS6 3QS,  United Kingdom
> Email: [EMAIL PROTECTED]
> Tel: +44 113 283 2600 extn 4730  Fax:  +44 113 283 3211
>
> --
> 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

RE: [PHP-DB] while - if - problem

2003-06-05 Thread Ford, Mike [LSS]

> -Original Message-
> From: Earl [mailto:[EMAIL PROTECTED]
> Sent: 04 June 2003 22:04
> To: PHP-DB
> 
> FYI
> this was beginning to bug me out... so I decided to try the 
> trim function
> and walla... it worked.
> 
> Thanks for ya'll assistance.

I was going to say this even before you added the trim() calls in , but this
really does look like an excellent situation for using the switch construct
(just look at all those trim() calls and array accesses you save!):


while($cols=ifx_fetch_row($eventQuery)) 
{
  switch (trim($cols['out_type']))
  {
case '0': 
  $r_away['linetype']='L';
  $r_home['linetype']='L';
  break;
  
case '1':
  $r_away['linetype']='H';
  $r_home['linetype']='H';
  break;
  }
  
  switch (trim($cols["s_acro"]))
  {
case 'CF':
case 'PF': 
  $r_away['sport']='1';
  $r_home['sport']='1';
  $s_lt='PS';
  $t_lt='TP';
  break;

case 'PB':
case 'CB':
  $r_away['sport']='2';
  $r_home['sport']='2';
  $s_lt='PS';
  $t_lt='TP';
  break;

case 'B':
  $r_away['sport']='3';
  $r_home['sport']='3';
  $s_lt='ML';
  $t_lt='TM';
  break;
   
case 'H':
  $r_away['sport']='4';
  $r_home['sport']='4';
  $s_lt='ML';
  $t_lt='TM';
  break;
  }

Cheers!

Mike

-
Mike Ford,  Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Beckett Park, LEEDS,  LS6 3QS,  United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730  Fax:  +44 113 283 3211 

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

[PHP-DB] while - if - problem

2003-06-05 Thread Earl

FYI
this was beginning to bug me out... so I decided to try the trim function
and walla... it worked.

Thanks for ya'll assistance.

---
$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 (trim($cols['out_type'])=='0') 
   {
$r_away['linetype']='L';
$r_home['linetype']='L';
   }
  
  elseif (trim($cols['out_type'])=='1')
   {
$r_away['linetype']='H';
$r_home['linetype']='H';
   }
  
  if (trim($cols['s_acro'])=='CF' || trim($cols["s_acro"])=='PF') 
   {
$r_away['sport']='1';
$r_home['sport']='1';
$s_lt='PS';
$t_lt='TP';
   }

  elseif (trim($cols['s_acro'])=='PB' || trim($cols['s_acro'])=='CB')
   {
$r_away['sport']='2';
$r_home['sport']='2';
$s_lt='PS';
$t_lt='TP';
   }
  
  elseif (trim($cols['s_acro'])=='B')
   {
$r_away['sport']='3';
$r_home['sport']='3';
$s_lt='ML';
$t_lt='TM';
   }
   
  elseif (trim($cols['s_acro'])=='H')
   {
$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"; 
 }

Re: [PHP-DB] while - if problem

2003-06-05 Thread Miles Thompson

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

Re: [PHP-DB] while - if problem

2003-06-05 Thread Earl

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

Re: [PHP-DB] while - if problem

2003-06-05 Thread Becoming Digital

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-DB] while - if problem

2003-06-05 Thread Earl

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

Re: [PHP-DB] while - if - problem

RE: [PHP-DB] while - if - problem

[PHP-DB] while - if - problem

Re: [PHP-DB] while - if problem

Re: [PHP-DB] while - if problem

Re: [PHP-DB] while - if problem

[PHP-DB] while - if problem

7 matches

Site Navigation

Mail list logo

Footer information