Dakon Barton
06-15-2007, 03:56 AM
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
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
$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");
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 (http://www.eternalbrethren.com/test.php)
what i want it to look like(html page) (http://eternalbrethren.com/test.htm)
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
$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");
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 (http://www.eternalbrethren.com/test.php)
what i want it to look like(html page) (http://eternalbrethren.com/test.htm)