Array Problems

[Bilbozilla]

I have searched through the forums but have been unable to find my answer to this one.

I have a database with 2 tables, say

table_skills
----------------|--------------
ID                  SKILLTYPE
--------------------------------
1                   | CODING
2                   | PLATFORMEXP
3                   | HARDWARE

table_credentials
----------------|--------------|-------------
ID                  NAME           XREF
--------------------------------|------------
1                  | C++           | 1
2                  | Macintosh   | 2
3                  | Windows     | 2
4                  | PERL           | 1
5                  | Mouse cleaning         | 3
6                  | Power           | 3

How would I display the CODING and HARDWARE skilltypes in a list with a unique heading

Coding experience

• C++

• PERL

Hardware experience

• Mouse Cleaning

• Power

I am thinking along the lines of a foreach statement, but I am not sure of the Syntax.

[LordShryku]

Easiest thing would be just do two seperate queries. I'm thinking something like this

$skilltypes = array("CODING", "HARDWARE");
foreach($skilltypes as $type) {
   $sql = "SELECT tc.NAME
           FROM   table_skills ts, tc.table_credentials
           WHERE  ts.ID = tc.XREF
           AND    ts.SKILLTYPE = '".$type."'";

   $res = mysql_query($sql) or die(mysql_error());
   if(mysql_num_rows($res) > 0) {
      echo "<ul>\n";
      while($row=mysql_fetch_array($res)) {
         echo "<li>".$row['NAME']."</li>\n";
      }
      echo "</ul><br />\n";
   }
}

Of course, if you end up doing so many queries that this effects page loading times, you'll want to look at doing it all in one query. At that point, I'd set a sort of "place holder" for the skill type, and do a check within the while loop to see if the place holder == the current skill type. If it doesn't, close the current list, and start a new one.

[Bilbozilla]

How could I do it so that the $skilltypes is variable, say sometimes it might only take the first value, or it might take all three? The values are being read in from checkboxes.

[mediaholic]

i would suggest u use one self referenzed-table
i just got the func ready so just write ure own generate_menuitem(); to parse the output to html

and replace the tbl and colum names in sql statement, hope it helps;

 
//rekrusiv travesing selfreferenzed trees
function generate_menu($node=0){
	static $space_count=0;//und level gleichzeitig
	static $item_count=0;

$sql="SELECT m1.id, m1.p_id, m1.name, count(*) as c, m2.name as no_childitem FROM ";
$sql.="menu as m1 LEFT JOIN menu as m2 ON ";
$sql.="m1.id=m2.p_id WHERE ";
$sql.="m1.p_id=$node ";
$sql.="GROUP BY m1.id ORDER BY m1.id, m1.p_id ASC";
//echo "$sql<hr>";
$rs=mysql_query($sql);	
while($row=mysql_fetch_array($rs, MYSQL_ASSOC)){		
	if($row['no_childitem']!==null){
		$item_count=$row['c'];
		echo gen_space($space_count);
		echo generate_menuitem($row);
		$space_count++;
		generate_menu($row['id']);
	}else{
		$item_count--;
		echo gen_space($space_count);
		echo generate_menuitem($row);
		if($item_count<1){
			$space_count--;
		}
	}
}
}