Pulling from a db into equal columns

Anon

Here's what I need to do....Im going to be having a database always growing, and on the front page of my site i want to display some results from that db. like select all from mydb where sitename=$sitename or something. now i want those results to be displayed in two even columns in a table, or if there's an odd number for it to be as even as possible..... how would I go about doing this? im still fairly new to php...im thinking i might try and use a divide funtion by 2 or something of the number of results....am i on the right path?

Anon

Hi! You could use something like this:

<?php
//connect to database and run the query

$left = true;
echo "<TABLE width=100%>\n";
while($row = mysql_fetch_row()) {
// which column we are??
if($left) {
echo "<TR><TD>" . $row[0] . "</TD>";
$left = false;
} else {
echo "<TD>" . $row[0] . "</TD></TR>";
$left = true;
}
}

//close table if still open.
if(!$left) echo "<TD> </TD></TR>";
echo "</TABLE>";
?>

With something like this it should work... or I didn't understand your question!! =)

Bye.. inK

Anon

So you want two even colums....
Well.. One easy way to do it (I'm going to use MySql in this example):

$DBname = 'myDB';
$result = mysql_list_tables($DBname);
$i = 0;
while($names[$i] = mysql_tablename($result, $i)) {
$result = mysql_query("SELECT * from $names[$i]");
$i++;
}
for($a = 0; $a > $i; $a++)
{

echo "<table width=xx border=?>"; // you deside width and border

Anon

So you want two even colums....
Well.. One easy way to do it (I'm going to use MySql in this example):

$DBname = 'myDB';
$result = mysql_list_tables($DBname);
$i = 0;
while($names[$i] = mysql_tablename($result, $i)) {
$nresult = mysql_query("SELECT * from $names[$i]");
$numbs[$i] = mysql_num_rows($nresult);
$i++;
}
echo "<table width=xx border=?>"; // you deside width and border
for($a = 0; $a > $i; $a += 2)
{
echo "<tr><td>$names[$a]</td>";
echo "<td>$names[$a+1]</td></tr>";
echo "<tr><td>$numbs[$a]</td>";
echo "<td>$numbs[a+1]</td></tr>";
}
echo "</table>";

Sorry about the last post.. It wasn't done yet

Anon

Ehhmm... I tested this myself and it doesn't work... I'll post new code shortly

Anon

Here's the new code.. Tested and ready to go... All it needs is just to make the design a little better... It's a little ugly now...

<body>

<?php

mysql_connect("localhost", "php", "");

$DBname = 'my_database';
$result = mysql_list_tables($DBname);
$i = 0;
while($i < mysql_num_rows($result)) {
$names[$i] = mysql_tablename($result, $i);
$nresult = mysql_query("SELECT * from $names[$i]");
$numbs[$i] = mysql_num_rows($nresult);
$i++;
}
echo "<table width=100 border=1>"; // you deside width and border
for($a = 0; $a < $i; $a += 2)
{
$b = $a + 1;
echo "<tr><td>$names[$a]</td>";
echo "<td>$names[$b]</td></tr>";
echo "<tr><td>$numbs[$a]</td>";
echo "<td>$numbs[$b]</td></tr>";
}
echo "</table>";

Andreas Bernhardsen
Graficonn

Anon

k thanks a lot. i'll be coming up to that part in my code in a little bit, so I'll try implementing it then. Thanks man. if i have nay problems or questions, i'll post them here....thanks!

Anon

Andreas, that's a -LOT- of querying... what if you've got over 100 entries to go on that front page, and a couple users a minutes hitting it?

Something closer to the first solution was better. Query -once-, process from an array result...