Lesane
01-24-2002, 08:43 PM
I'm busy with a hack that displays all the users that using wich style on one seperated page. Now i'm stuck in the while loop :( It only displayes the first user but i want it so that it displayes all users.. but i dont know wich code to use in the while loop.
This is the code of style.php:
<?php
require('./global.php');
$postsresult = mysql_query("SELECT username, userid, style.title, user.styleid FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect=1 GROUP BY username");
while ($topposters = mysql_fetch_array($postsresult)):
eval("dooutput(\"".gettemplate("whousingtest")."\");");
endwhile;
?>
Now when i run style.php then it only shows the first user with the style that he's using and id etc but i want to let it show all users.
Live demo :)
http://www.outlawznation.com/board/style.php
Any help appreciated.
This is the code of style.php:
<?php
require('./global.php');
$postsresult = mysql_query("SELECT username, userid, style.title, user.styleid FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect=1 GROUP BY username");
while ($topposters = mysql_fetch_array($postsresult)):
eval("dooutput(\"".gettemplate("whousingtest")."\");");
endwhile;
?>
Now when i run style.php then it only shows the first user with the style that he's using and id etc but i want to let it show all users.
Live demo :)
http://www.outlawznation.com/board/style.php
Any help appreciated.