[SOLVED] Insert Intro Paragraph on page 1 only before recordset

[technomad]

I need to insert a paragraph before a set of records that results from a MySQL query. The paragraph options are context sensitive and are stored in a field named 'IntroParagraph'. If the query asks to return all records WHERE City = 'New York', then the IntroParagraph about New York should be inserted above the list of records. However, if the results require more than one page, I only want the paragraph to show up on the first page. Can anyone tell me the best way to do this?

 

Thanks. P.S. I'm on a today deadline, so any help would be appreciated asap.

 

[lonewolf217]

are we assuming here that the entire set of records will always point to a single subject ?

 

if so:

1) check what page you are on

2) retrieve the first row

3) check the subject that you are dealing with

4) output the appropriate IntroParagraph

[technomad]

that worked well. thank you lonewolf!