PHP Help Request

[ChristopherH]

Hello Guys!

I am after a little help,

I am setting up a user-system with RMB's user-system as i quite like it,
Now i know their is security flaws and what not, But I'll sort them out.

It's been doing my head in trying to get this to work but i would like to
know if you could recode this to make the member list showup like this:

Userlist:

[MemberName] [MemberName] [MemberName]

[MemberName] [MemberName] [MemberName]

But Currently it's showing up like:

[MemberName]
[MemberName]
[MemberName]
[MemberName]
[MemberName]

Etc..

Here is the code:

}
}else{
//gets all the members from the database
$getusers = mysql_query("SELECT * FROM `authme` ORDER BY `id` ASC") or die(mysql_error());
//loops there name out
while ($user = mysql_fetch_array($getusers)) {
echo "<a href='members.php?user=$user[username]'>$user[username]</a><br>";
}
}
echo "<center>";
?> 

Would be appreciated if you could help me with this asap.

Thanks,
Chris.

[N!ck]

A little bit messy and untested, but something like this should work.

}
}else{
//gets all the members from the database
$getusers = mysql_query("SELECT * FROM `authme` ORDER BY `id` ASC") or die(mysql_error());
//loops there name out
$i = 1;
while ($user = mysql_fetch_array($getusers)) {
if ($i % 3 != 0) {
echo "<a href=\"members.php?user={$user['username']}\">{$user['username']}</a> ";
} else {
echo "<a href=\"members.php?user={$user['username']}\">{$user['username']}</a><br />";
}
i++;
}
}
echo "<center>";
?> 

[ChristopherH]

Cheer's for that mate, Ill check it about asap.

[ChristopherH]

Ok so that did work, but it didn't

I was after it to display diffrent users name's 3 across so on,
but the script you sent displays as many as it can fit on the page across.

Could you posiblly re-design the code to do this?

[Username1] [Username2] [Username3]
[Username4] [Username5] [Username6]
So on..

In tables?

[Blinger]

Okay this is pseudocode since I'm not on a Pc!


while($i < 3){
..if($i == 3){
....echo "<tr><td>username</td></tr>"
....$i=0
..} else {
....echo "<td>username</td>
..}
..$i ++
}

[ChristopherH]

Okay this is pseudocode since I'm not on a Pc!


while($i < 3){
..if($i == 3){
....echo "<tr><td>username</td></tr>"
....$i=0
..} else {
....echo "<td>username</td>
..}
..$i ++
}

So ill just remove the ..?

[Blinger]

Ill jump on a Pc now and type up what should work!

---------- Post added 06-04-2012 at 04:03 PM ----------

} else {
// row counter
$i = 0;
// Echo the start of the table
echo("<table width=\"90%\" border=\"0\"><tr>");
// Start fetching usernames
while ($user = mysql_fetch_array($getusers)) {
    // Check whether we are at the 3rd member
    if($i < 3){
        // Since we are, echo start of a new row
        echo("</tr><tr>");
    }
    // Show the users
    echo ("<td width=\"33%\" align=\"center\"><a href=\"members.php?user={$user['username']}\">{$user['username']}</a></td>");
}
// End of the table and users
echo("</tr></table>"); 

That should work

[ChristopherH]

Ill jump on a Pc now and type up what should work!

---------- Post added 06-04-2012 at 04:03 PM ----------

} else {
// row counter
$i = 0;
// Echo the start of the table
echo("<table width=\"90%\" border=\"0\"><tr>");
// Start fetching usernames
while ($user = mysql_fetch_array($getusers)) {
    // Check whether we are at the 3rd member
    if($i < 3){
        // Since we are, echo start of a new row
        echo("</tr><tr>");
    }
    // Show the users
    echo ("<td width=\"33%\" align=\"center\"><a href=\"members.php?user={$user['username']}\">{$user['username']}</a></td>");
}
// End of the table and users
echo("</tr></table>"); 

That should work

OK so i have this:

";

}
}else{
//gets all the members from the database
$getusers = mysql_query("SELECT * FROM `authme` ORDER BY `id` ASC") or die(mysql_error());
//loops there name out
while ($user = mysql_fetch_array($getusers)) {
// row counter
$i = 0;
// Echo the start of the table
echo("<table width=\"90%\" border=\"0\"><tr>");
// Start fetching usernames
while ($user = mysql_fetch_array($getusers)) {
    // Check whether we are at the 3rd member
    if($i < 3){
        // Since we are, echo start of a new row
        echo("</tr><tr>");
    }
    // Show the users
    echo ("<td width=\"33%\" align=\"center\"><a href=\"members.php?user={$user['username']}\">{$user['username']}</a></td>");
}
// End of the table and users
echo("</tr></table>");  
echo("");  
?> 

And it's showing it back to this format?
{member}
{member}
{member}
{member}
{member}
{member}

[Blinger]

You need to close the while loop.

[ChristopherH]

Hahah I'm really ****** at this kind of stuff Blinger
Would love it if you could help me with that one?