i have an attribute in 'users' table called RegNo which refer ro region number ...
so i have to select users and display them according to their region number .

here is my code


<ul id="nav">
<li class="heb"> <a href="parentUrl" >hebron</a>
<li class="bet"> <a href="parentUrl" >ramallah</a>
include ("config.php");
$query="select * from users";
if (!$returnValue)
    die ("error");
        if ($row['RegNo']==100){
            echo '<ul class="heb">
                       <li><a href="childAUrl" >'.$row['username'].'</a></li>

so if the RegNo=100 , username must be displayed under 'hebron' city...

how i can solve this problem ?!

Member Avatar

You need to order the records by RegNo.

In your loop, listen out for a change in the regno value. if it changes, that's a trigger to place a "heading" before adding individual list items

you mean if there are any change in regno , i must dispaly the heading (<li class="heb"> <a href="parentUrl" >hebron</a>)
, and then add individual items ?!

Member Avatar

I have no idea.

If you order your data by regno, then in your data loop, you listen out for when the regno changes. You didn't put a WHERE clause in your SQL, so I'm assuming that you're outputting every single user in the table.

Not quite sure what you're trying to do. Are you just tring to return users for one 'selected' city?

output must be for more than one city


Member Avatar

What are your table fields? How is the city name retrieved? I assumed that RegNo was the id for city. So, we need to know the table fields and maybe a row or two as example data

here's my table attributes

username    password    UserId  Email   Phone   RegNo

UserId is the primary key

Ex data :
username    password    UserId  Email   Phone   RegNo
john        123456WSD   8542WQ  s@s.xom 52154   100 

sami        10223       5542WQ  s@s.xom 52154   101

jojo        032656      8582WQ  s@s.xom 52154   102

Your requirement is just grouping, its does not look like tree

You can do this using two queries

$cityquery= "select distinct city from usertable"
loop -- through above records and in loop fetch users for the city
echo $cityrow['city']
$userquery "select usernaem from usertable where city='{$cityrow['city']}'";

   echo "&nbsp;&nbsp;&nbsp;".$userrow['userid'];
end loop

end loop ---city

aha thanks :)
i will try....