Displaying SQL data into horizontal table

Discussion in 'PHP' started by james_sgp, Nov 5, 2007.

  1. #1
    Help!!

    I`m having difficulty working out how to display my query results in a horizontal table, similar to the one below:

    My query is this:

    SELECT MONTHNAME(dive_details_date), YEAR(dive_details_date), COUNT(*)
    FROM jos_fabrik_formdata_9 WHERE dive_user = '${joomla_user_id}'
    GROUP BY MONTHNAME(dive_details_date), YEAR(dive_details_date);

    I would like to display lie this:

    [​IMG]
     
    james_sgp, Nov 5, 2007 IP
  2. bartolay13

    bartolay13 Active Member

    Messages:
    735
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    98
    #2
    sir i think a good way of doing this is putting the Records to a
    
    <li>
    <ul>record 1</ul>
    <ul>record 2</ul>
    <ul>record 3</ul>
    </li>
    
    HTML:
    and set the CSS page and its container....
    i think that you will be dealing more on your CSS
     
    bartolay13, Nov 6, 2007 IP