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
the query being ran to begin with isCode: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>";
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 :-)Code:$member = mysql_query("SELECT *,date_format( birthdate, '%M %d,%Y' ) AS birthdate FROM `smf_members` WHERE `ID_GROUP` = 11 ORDER BY `memberName` ASC LIMIT 0, 100");
the results of the query
what i want it to look like(html page)



Reply With Quote
Bookmarks