> I am a serious newbie (like less than two weeks & never programmed before),
> so I hope my code doesn't suck too bad & this isn't a really bad question...
> but here goes...
> I would like to modify this query so that it doesn't return the username,
> realname, and office results each time. The way the query is now, I see the
> username, realname & office results duplicated for each 'alias' result that
> is in the data. Instead, I'd like to see the username, realname & office
> only once & a list of the associated 'alias' (es) underneath it. If anyone
> can help w/ some "semi-real" code, that would be great.  Since I'm new, it
> really helps to have code that actually reflects my field names so that I
> can learn from it.  I appreciate any help you can provide.  Thanks in
> advance!  ~Andrea
> ____________________________________
> $query = "select users.username, users.realname,,
> users.location, users.office_phone, users.alt_phone, users.password,
> alias.alias from users, alias
> where users.username like '%".$searchterm."%'
> and users.username = alias.username";
> $result = mysql_query($query);
> $num_results = mysql_num_rows($result);
> echo "<p>Number of Users found: ".$num_results."</p>";
> for ($i=0; $i <$num_results; $i++){
> $row = mysql_fetch_array($result);
> echo "<p><strong>".($i+1).". Username: ";
> echo htmlspecialchars( stripslashes($row["username"]));
> echo "<br>Real Name: ";
> echo htmlspecialchars( stripslashes($row["realname"]));
> echo "<br>Office: ";
> echo htmlspecialchars( stripslashes($row["office"]));
> echo "<br>Alias: ";
> echo htmlspecialchars( stripslashes($row["alias"]));

With respect to your request for code, in fact you need to take two steps: 1 to 
understand the program/script
logic required to achieve your aims, then 2 code that logic in PHP. One of the tools 
for the first step is
"pseudo-code". This offers an answer to your (logic) question in pseudo-code (with 
regrets that lack of time
precludes the next step):

If you think about it, your display has (probably) a main heading, and maybe a footer. 
What lies in between
(apart from white space) is groups of lines, where each group is defined/identified by 
the username (etc). You
want to display the groups so that the first line identifies the group, and any 
ensuing lines within the group
do not duplicate the information.

So think about writing the first line in a group. Then how would you display the 
ensuing lines in each group?
How would you know if the next line belongs with the same group, or starts a new one? 
Apart from ensuring that
you use all of the rows in the resultset (and no more!?) that's about the nub of it...

retrieve first row from resultset
while not eod
  note group's username
  display (full) line
  retrieve next row
  while line's username = group's username and not eod
    display line (without username etc)
    retrieve next row
    end while line
  end while not eod

NB "eod" = end of data
(rather than working of num-rows it works off the boolean response of a call to 
retrieve from the resultset, eg


PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to