What i want is to have a nav:
Client x
----project1
----project2
Client y
----project1
Client z
----project3
----project3
----project3
My database looks like:
projects
+-----+-----------------+-----+
| PID | PName | CID |
+-----+-----------------+-----+
| 15 | Project1 | 1 |
| 16 | Project2 | 6 |
| 14 | Project3 | 2 |
| 17 | Project4 | 2 |
+-----+-----------------+-----+
clients
+------------+-----------------------------+
| clients_ID | clients_Name |
+------------+-----------------------------+
| 1 | Client1 |
| 2 | Client2 |
| 3 | Client3 |
| 5 | Client4 |
| 6 | Client5 |
+------------+-----------------------------+
I am trying to figure out where to start. I thought i could use a loop within a loop, but my meager attempt ended in frustration.
Maybe i a going about this all wrong, but here is what i have:
Code: Select all
$sql=mysql_query("SELECT * FROM clients ORDER BY clients_Name ASC LIMIT 0, 10");
$sql2=mysql_query("SELECT * FROM projects ORDER BY PName ASC LIMIT 0, 10");
while ($select=mysql_fetch_array($sql)){
//get client names
$var1=$select["clients_Name"];
$var2=$select["clients_ID"];
while ($select2=mysql_fetch_array($sql2)){
//get projects where CID = $clients_ID;
$var3=$select2["PName"];
$var4=$select2["PID"];
$var5=$select2["CID"];
}
echo"$var1:$var2<br>$var3:$var4<br>";
}
Thanks in advance...