numrows and counting entire query

ljschrenk

Ok Guys,

I desperately need your help. Here's the situation. I have an html form that produces a query, the last line of which is numrows < 51, returning only the first 50 results.

I need to find a way to alert the user that there were more that 50 results produced, but only 50 are showing. What's the easiest way to determine if there are more than 50 results, with or without using a php page?

Thanks for any suggestions,
ljschrenk

😕

LordShryku

is this numrows < 51 in a loop?
is this page strictly html?
is this a database query?
if you don't want to use a php page, what are you using?

ljschrenk

Hi,

Thanks for letting me clarify, I'm never sure exactly what information I should/need to include. 🙂

Right now it is strictly an HTML page, could be made into a php page if needed. The numrows < 51 is not a loop, it's part of a SQL query to oracle to return only the first 50 results.

Unfortunately the output generated from the query is processed by a program written in C so there's not much flexibility.

My original thought was to do an onload() after the results page loaded and use a javascript function to execute a php script and rerun the query counting the exact number of results. But then I learned you can't execute PHP from javascript. :mad:

Let me know if I can help with any more information. Thanks!!
ljschrenk

LordShryku

Well, my suggestion would be to convert the C program to PHP. It has great Oracle support. Then you would have complete control over the page and the results, and it wouldn't require any other pages.

ljschrenk

Unfortunately that is not an option. The program is slowing being converted to PHP but will be another few years to completion, very large task.

I need a solution that will work with the system that is in place.

LordShryku

Well then, considering that you haven't shown any of the code used in the program or how the html page integrates with this....there's not much I can help you with.

ljschrenk

This is a semantics question, not a syntax question. It has nothing to do with how the C program works. The only this the C program does is generate the output.

The user fills out a search form, the search executes displaying the first 50 results. Can you do a count on the total records in the same query as only selecting the first 50? Or can I do another type of query that will return the total number along with the results????

Or, could I submit the form to a php script, get the total number, if it's more than 50 display a message saying their search produced more than 50 results, click oK to continue, and then execute the c program to display the results, else if it's less than 50 just execute the script?