User Profile

Collapse

Profile Sidebar

Collapse
kevenj
kevenj
Last Activity: Jun 27 '08, 05:06 PM
Joined: Apr 7 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kevenj
    replied to Grouping results with PHP
    in PHP
    I ended up adjusting the SQL a bit and it worked like a charm! Thanks again for the solution.
    [code=mysql]
    SELECT at.authorName
    FROM authorTable AS at
    INNER JOIN authorArticleLi st AS aal
    ON at.aID=aal.aID
    WHERE aal.articleID = {$articleRow['articleID']}
    [/code]
    See more | Go to post
    Last edited by Atli; Apr 11 '08, 11:59 PM. Reason: Added [code] tags.

      Leave a comment:

    • kevenj
      replied to Grouping results with PHP
      in PHP
      Thanks Atli, This will definitely give me something to play with tomorrow. I appreciate your help!
      See more | Go to post

        Leave a comment:

      • kevenj
        started a topic Grouping results with PHP
        in PHP

        Grouping results with PHP

        Hello,

        I'm a bit of a newcomer to PHP and am having an issue I can't overcome.

        I've read some great posts on the issue of grouping results on this forum 1 and can happily display results under a common variable. The problem occurs as I want to display the common variable after the grouped results.

        I'm attempting to write out the results of a query for journal articles in a citation format that lists authors...
        See more | Go to post
        Last edited by Atli; Apr 8 '08, 12:08 AM. Reason: Added [code] tags.
        No activity results to display
        Show More
        Working...