Well the code is below:
But it adds users in rows likePHP Code:<?
include "config.php";
$d = mysql_query("SELECT * FROM `users` ORDER BY `level` ASC");
while ($staff = mysql_fetch_array($d)) {
IF ($staff[level] == 2) {
echo (" <p><strong></strong></p> ");
echo ("
<p><a href=\"members.php?view=Profile&user=$staff[username]\"><b>$staff[habboname]</b></a> - DJ $staff[username]");
}
}
?>
Link
Link
Link
Does any one know how to make them in collums (of 3)?
Like
Link Link Link
+ Rep For Helping
J1MI (Forum Moderator) - Thread moved from Website designing, hopefully you'll get more reply's here
Results 1 to 10 of 12
Thread: Help With Code
-
28-11-2006, 08:33 PM #1
Help With Code
Last edited by J1MI; 29-11-2006 at 05:25 PM.
-
Each loop have a value increment ($i++) and use
etc etc.PHP Code:if ($i == 3 | $i == 6 | $i == 9) {}
Obviously if it returns true, <br /> or new table row, whatever method you're using.XHTML, CSS, AJAX, JS, php, MySQL.
--
HxF moderators can't read timestamps.
-
28-11-2006, 09:08 PM #3
Can u edit the code above please :p
Originally Posted by Heinous
Im not very good when people say use this, I then end up staring at screen like, erm, hum, where I put it lol
-
Its much easier to do it this way...
Make each div 33%PHP Code:<?
include "config.php";
$d = mysql_query("SELECT * FROM `users` ORDER BY `level` ASC");
while ($staff = mysql_fetch_array($d)) {
IF ($staff[level] == 2) {
echo (" <p><strong></strong></p> ");
echo ("
<div style=\"width: 33%;\"><a href=\"members.php?view=Profile&user=$staff[username]\"><b>$staff[habboname]</b></a> - DJ $staff[username]</div>");
}
}
?>Last edited by Luckyrare; 28-11-2006 at 09:12 PM.
-
But darling, div's stack by default. Originally Posted by Luckyrare
And if he used float, then that would stuff up as it would be floating.
And no, you asked for help, I told you how. If you don't work out how to implement it yourself, you'll never learn.XHTML, CSS, AJAX, JS, php, MySQL.
--
HxF moderators can't read timestamps.
-
28-11-2006, 09:35 PM #6
didnt work :S
-
put $i = 0; before the while statement. :p
edit;
and $i = $i++ in the while statement.Last edited by Heinous; 28-11-2006 at 09:48 PM.
XHTML, CSS, AJAX, JS, php, MySQL.
--
HxF moderators can't read timestamps.
-
29-11-2006, 04:44 PM #8
Im Officaly Confused Now :S
-
PHP Code:
<table border="1">
<?php
require('config.php');
$SQL = mysql_query("SELECT * FROM `users` ORDER BY `level` ASC");
while($row = mysql_fetch_array($SQL))
{
if(!$n) print '<tr>';
$n++;
print <<<HTML
<td> <a href='members.php?view=Profile&user={$row['username']}'>{$row['habboname']}</a> - {$row['username']} </td>
HTML;
if($n!=3) continue;
print '</tr>';
unset($n);
}
?>
</table>kinda quit.
-
Im to lazy to follow whats going on here but, you dont actualy need the $i = part. The code $i++ on its own is all you need to incriment the value of $i by one Originally Posted by Heinous
Reply With Quote
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts