User Profile

ryangsh · Mar 6 '11, 03:02 PM

I'm trying to consolidate inventory records in db. (I'm displaying the result in a table form but for this post I'm putting it simple)

table_name= PC:
department - msoffice
IT - 2000
IT - 2002
IT - 2000
SNM - 2000
SNM - 2003
Finance - 2003
-----------------------------------

expected output:
msoffice - dept - qty
2000 - IT - 2
2000 - SNM - 1
2002 - IT...

ryangsh · Jun 2 '10, 04:03 AM

hi guys, need your expertise...

I'm trying to create a list for group of associates by group and when a group is selected the associates assigned to that group will appear in a list

sample

Code:

 
<select name="groupName">
<?php $rs_groupSearch="SELECT * FROM tblGroup";
$groupCount=mysql_num_rows($rs_groupSearch);
if($groupCount>0){
   while($Groups=mysql_fetch_array($rs_groupSearch)){

...

User Profile

Profile Sidebar

count & multiple group by

parse value from 1 dropdown list to another list onChange event