counting results of for loop inside foreach?

[csousley]

I have a query that returns this in a browser:

------------------------------
For Frozen/Totes (id # 7)
Job 30 needs 2 people
Job 32 needs 1 people

For Single Pass/Reg Box (id # 6)
Job 32 needs 1 people
Job 33 needs 3 people
Job 34 needs 1 people
------------------------------

What I need is some code that will keep track of the different jobs and how many people are needed for a job. For example:

Job 30 totals 2 people (2 from Frozen/Totes)
Job 32 totals 2 people (1 from Frozen/Totes-1 from Single Pass/Reg)
and so on...

The code I have now that returns the above information is this:

---

foreach ($id as $value) {
	$query_name = "select * from process where proid = $value";
	$result_name = mysql_query($query_name);
	$row_name = mysql_fetch_array($result_name);

$processname = $row_name['proname'];
echo "<b>For $processname (id # $value)</b><br>";

$query = "select jb.jobid , jb.jobname, pj.pjproid, pj.pjjobid, pj.pjnumber from jobs jb left outer join process_jobs pj on jb.jobid = pj.pjjobid where pj.pjproid = $value order by jb.jobname asc";
$result = mysql_query($query);
$num = mysql_num_rows($result);
for ($i=0; $i<$num; $i++) {
	$row = mysql_fetch_array($result);
	$pjjobid = $row['pjjobid'];
	$pjnumber = $row['pjnumber'];
	echo "Job $pjjobid needs $pjnumber people<br>";
}
echo "<p>";
}

----------------------------------

Anyone have any thoughts, I'm out of ideas, thanks!

-Cy

[gid]

You probably want to build a big $jobs array somehow. And then add the data into it. You can do something like this:
$jobs[$job_num][$id] = $number_of_needed_jobs_for_this_id_and_job_num;

And then later, loop through the $jobs array printing everything out, you'll need a foreach loop nested in a foreach loop to do this most likely. I'm a nice guy, but unfortunately for you, not nice enough to do this for you. 🙂 Hopefully I gave you enough of a general idea to get started.

Where does the $id array come from? Maybe you can simply change your queries around looping through by job number first, and avoid the whole $jobs array nonsense.

[csousley]

gid

Thanks for the reply. I was able to work around it without having to store the job information like you said. It just took leaving it alone for a couple hours.

I checked out your site, steem.com, nice flash movie! What can I say, I'm a nerd.

-Cy