Report Generating

[Infrabyte]

I have been designing a database using MySQL on my Linux server and using a web
based front-end. I have the users entering data into the database but now they
want to get reports by doing a query. For example I have a list of students,
addresses, courses and their marks, and they would like to know - of all the
students that did the computer course, how many of them got over 80%.

I cant seem to figure out how to generate this type of report and display it
on the web page. They would also like to use criteria to do their report
search. The database and website is now getting quite big and I'm a bit
'stumped'

Thank you

[Mintyman]

What you're trying to do is a simple search/result page. Create a form that
contains a field called 'percent' that will be used to enter the % rate you
wish to search above. The, on the next page create a recordset that will
return only those values that are greater than the value entered on the form
on the previous page using the request.form("percent") variable. In effect,
you want to create a query that will:

select all records where percent is greater than request.form("percent").

From there, simply drag the [total records] field from the
Application/Bindings panel in DW onto the page. Hey presto, it will display
the number of records that meet the criteria sspecified in the query.



"Infrabyte" <webforumsuser@macromedia.com> wrote in message
news:d30asi$9e8$1@forums.macromedia.com...

> I have been designing a database using MySQL on my Linux server and using

a web

> based front-end. I have the users entering data into the database but now

they

> want to get reports by doing a query. For example I have a list of

students,

> addresses, courses and their marks, and they would like to know - of all

the

> students that did the computer course, how many of them got over 80%.
>
> I cant seem to figure out how to generate this type of report and display

it

> on the web page. They would also like to use criteria to do their report
> search. The database and website is now getting quite big and I'm a bit
> 'stumped'
>
> Thank you
>