[RESOLVED] looping columns.. or something like that.. :P

[pettsogn]

Hi i'm wondering if its possible to do somthing like this with columns instead of rows?

$a = 0;
$a1 = 0;
$res = mysql_query("SELECT * FROM my_table ORDER BY id DESC  LIMIT ".($a).",100",$db);
if ($info = mysql_fetch_array($res)) {

$count = $a1;
if ($count>0)$count--;
do {
    $count++;

echo "This lists the rows...";


} while ($info = mysql_fetch_array($res));
}

thanks 🙂

EDIT: I want to show userstats without have to write code for all the stats..

[nemonoman]

Of course you can do this; it just takes more work.

Suppose each mysql_fetch_array returns 3 values:
name, address, phone

while ($row=mysql_fetch_array($result)){
$namecells[]=$row['name'];
$addresscells[]=row['address'];
$phonecells[]=$row['phone'];
}
//To print the table
echo "<table><tr>";
foreach($namecells as $name){
echo "<td>$name</td>";
}
echo "</tr><tr>";
foreach($addresscells as $address){
echo "<td>$address</td>";
}
echo "</tr><tr>";
foreach($phonecells as $phone){
echo "<td>$phone</td>";
}
echo "</tr></table>";

I made this example very non-generic...however, once you get the example, you can see that it would be a simple matter to write a generic function that would instantly convert database returned values to display in a column-based table format.

[pettsogn]

Ok, thanks! I'll try that 🙂