Results 1 to 2 of 2

Thread: Formatting help

  1. #1
    Join Date
    Apr 2006
    Location
    Waco,Tx
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Talking Formatting help

    Alrighty after scouring the net searching for this all day i've lost all sense of direction with this escentially what im wanting to do is take 1 column from my mysql database and arrange it into a 5 column 9 row the code im working with is

    Code:
    echo "<h3><i><b>RF Online Members</b></i></h3><table border=\"0\" width=\"377\" height=\"13\"><tr>";
    while($out = mysql_fetch_array($member))
    echo "<td width=\"75\" align=\"center\"><a href=\"http://eternalbrethren.com/SMF/index.php?action=profile;u=$out[ID_MEMBER]\" onMouseover=\"ddrivetip('<b>MSN</b>: $out[MSN]<br><b>Yahoo</b> :$out[YIM]<br><b>Email</b>: $out[emailAddress]<br><b>Location</b>: $out[location]<br><b>Birthday</b>: $out[birthdate]','#000000', 300)\";
    onMouseout=\"hideddrivetip()\">$out[memberName]</a></td>";
    echo "</tr></table>";
    the query being ran to begin with is
    Code:
    $member = mysql_query("SELECT *,date_format( birthdate, '&#37;M %d,%Y' ) AS birthdate FROM `smf_members` WHERE `ID_GROUP` = 11 ORDER BY `memberName` ASC  LIMIT 0, 100");
    i tried adjusting the limit to 0,5 and thought of just using multiple queries to accomplish this, and i read about the pivot tables but they confused me using 2-3 rows of data for it so any help would be appreciate :-)

    the results of the query
    what i want it to look like(html page)
    Last edited by Dakon Barton; 06-15-2007 at 06:31 AM.

  2. #2
    Join Date
    Apr 2006
    Location
    Waco,Tx
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Talking

    Solved thanks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •