how to change provious fetched while loop

[man12_patil3]

hi all,

 

  My prob. is that i am feacthing record from DB by while loop (Mysql fetch Arry) and print it row by row.

 

  id    Begnning Stage          Ending Stage                    Active

 

  1      Begnner   Intermidiate       "No"

  2    Intermidiate    Uppper intermidiate      "Yes"

  3      Begnner   Intermidiate       "Yes"

  .     . .         .

  .     . .         .

  .     . .         .

  .     . .         .

  n     . .         .

 

as above mention i want to  Active is "NO" IF first Records Ending stage is same as next record "Begnning Stage".

[bluejay002]

You can do this in two ways:

 

1. Do this in your query.

 

2. Use a delayed printing of result by atleast 1 record and have the previous record stored in a temporary variable so that you can scan out what to do with it.

 

My two cents.

 

bluejay,