It looks like the addition of the distinct verb should do the job if in fact your
query only showed the fields on the display.
>From your Sql however you are selecting more fields than are displayed and some
of those are different which distinct
will still display.
Chris Toth wrote:
> Ok, I've been battling this SELECT statement for the better part of the day.
>
> The SELECT statement is this:
>
> SELECT DISTINCT request.id AS requestid, request.date, request.type,
> request.status,
> faculty.f_name, faculty.l_name, action.id AS actionid, faculty.id AS
> facultyid FROM faculty, request, action WHERE request.id=action.request_id
> AND request.requested_by=faculty.id AND request.status=0;
>
> And the results are here:
>
> http://www.geology.ohio-state.edu/test/rfatest/rfaadmin.php?closed=Closed
>
> Now, if you look at the table, at the far left cell under RFA#, you'll
> notice that they are all the same (2). That is because there were 4 actions
> performed on RFA # 2. However, I only need for the column to be displayed
> once. When the user clicks under 'last action' then they can see all 4
> actions. But for this table, I just need to show the data once.
>
> So, could any kind soul help me out?
>
> Thanks
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
