[RESOLVED] display total num of rows of multiple form category

[rooky]

hi there

I have a form category in html which has jobtitle set to multiple for selecting more than category eg. optician and receptionist

I want to be able to display the total number of results of more than one category returned using mysql_num_rows($result); and while ($item = mysql_fetch_row($result)) :-

here is the code

<?php
$jobtitle= $_POST ['jobtitle']; //form variable
$jobtitlepos=265; //position for displayed result
foreach ($jobtitle as $value){
$job=$value;

$sqlquery ="SELECT entryID,negotiate, rates,posted,jobtitle,worktime,minimumsalary ,maximumsalary , salary, location, LEFT(description,10) FROM recruitment WHERE jobtitle LIKE '$job' ";

$result = mysql_query($sqlquery);

$resulto=mysql_num_rows($result);

////////////////////////////display no. of search results////////////

echo '<div>Your jobsearch found&nbsp;'.$resulto.'&nbsp;results today. </div>';

//display result
while ($item = mysql_fetch_row($result)) {

echo '<div class=jobtitle id="Layer3" style="position:absolute; left:736px; top:'.$jobtitlepos.'px; width:370px; height:15px; z-index:24">',$item[4],'&nbsp;&nbsp;<br>jobtitle</div>';

$jobtitlepos=$jobtitlepos+155;

}
}
?>

What happens is the result when i select 2 different job categories in the form and click submit

Your jobsearch found&nbsp;'.$resulto.'&nbsp;results today.
it displays 2 lots of results :-
eg if there were- 3 opticians in table and 2 receptionists in same table
the figure 3 displays on top of figure 2 instead of adding 3+2 to show the result as 5

the foreach statement gets reset to give 2 results instead of one??

help please

rooky

[jheitz]

By what I can make of your code, it seems to be displaying the number of results per category followed by the details of all those jobs.

So for your example it would do something like:

"Your jobsearch found 3 results today"
<Followed by the details of these 3 optician jobs>
"Your jobsearch found 2 results today"
<Followed by the details of these 2 recepcionist jobs>

Am I write in understanding that what you want it to do is to display something like:

"Your jobsearch found 5 results today"
<Followed by the details of these 5 optician & recepcionist jobs>?

[rooky]

yuo got it exactly

rooky

[jheitz]

I don't have the time to code it for you, but it should be fairly easy.

Basically you need to gather all results before echoing them. This means that within your loop you shouldn't have any output (echo) but instead, a variable that gets incremented with the number of records for each query (eg: 3 + 2) and the same for the results themselves (place them in a holder). Then, after the loop (ie: end of your code) Display these 2 variables

[rooky]

thanks got it solved now

rooky