Print MySQL results in 2 Columns

EddieFoyJr

I want to display the results of my query in 2 columns, alphabetical order top to bottom. First column 1 then column 2.

For example:

Column 1[COLOR=F1F1F1].............[/COLOR] Column 2
A[COLOR=F1F1F1]........................[/COLOR] D
B[COLOR=F1F1F1]........................[/COLOR] E
C[COLOR=F1F1F1]........................[/COLOR] F

I must be a total idiot! I've read several tutorials on this subject, each with a different approach, and I'm totally lost. I know this is a PHP 101 question but I'd be eternally grateful if someone could help me with this code:

<tr align="center" valign="middle">
<td width="50%" height="30"><?php
$sql="select *";
$sql .= " from $pntable[yp_assns] a ";
$sql .= " where (catid = $category AND regionid = $region) OR (catid = -1 AND regionid = -1) OR (catid = -1 AND regionid = $region)";
$sql .= " order by abreviation";
$result = mysql_query($sql);

   if (!ypSqlError($sql,$result,mysql_errno(),mysql_error(),"60")) {
   $numcat = mysql_numrows($result);
   $numbercol = 2 ;

   $numrows = floor($numcat / $numbercol);
   $numextrarows = $numcat - ($numrows*$numbercol);
   $colstogo = $numbercol;
   $numrows++;
while($colstogo-- > 0){

$rowstogo = $numrows;
$numextrarows--;
?>

 <table width="100%" border="0" cellspacing="0" cellpadding="0">

<?php
while($rowstogo-- > 0) {
if ($rowstogo < 1 and $numextrarows < 0) {

    } else {
    $catarray = mysql_fetch_array($result);
    echo "\n<tr><td>\n";
    $boxstuff = "";
    $boxTitle = "".ifconstant($assnarray[abreviation])."";
    $sql="select * from $pntable[yp_assns] where (catid = $category AND regionid = $region) OR (catid = -1 AND regionid = -1) OR (catid = -1 AND regionid = $region) order by abreviation";
    $result2=mysql_query($sql);
    while ($assnarray = mysql_fetch_array($result2)) {
           $boxstuff .= "<input type=checkbox name=assnid$assnarray[catid] value=1>&nbsp;";
           $boxstuff .= "\n<font class=\"pn-normal\">".ifconstant($assnarray[abreviation])."<br>\n";
           }
    $boxstuff .= "";
    $row[title] = $boxTitle;
    $row[content] = $boxstuff;
    themesidebox($row);
    echo "\n</td></tr>\n";
    }

}
}
}
?>

</table></td>
</tr>

Blob

If you put php between php tags, it's easier to read - and find errors. 😛

Why do you keep adding to the sql variable???
Couldn't you just do:

$sql = "select * from $pntable[yp_assns] a where (catid = $category AND regionid = $region) OR (catid = -1 AND regionid = -1) OR (catid = -1 AN regionid = $region) order by abreviation"

It's shorter and easier to read in my opinion. 😛

shareaweb

I've always found this faster to ditch the math....

Run your original query and get the numrows()

Divide the numrows() by the number of cols (as you did with floor was ok.) [Say as $firstrow]

Run the same query again, this time += "LIMIT 0, $firstrow";
Output the first in it's own table,

then run the third query "LIMIT $firstrow, $numrows"

and output that..

For this to work though and look good your tables should have the attribute "style='display:inline' added.. for better appearance, or put both tables at %100 height into another table to line up nice.

The overhead of the math is probably more than the multiple queries in terms of tick execution speed. Haven't tested it tho...

EddieFoyJr

The code is from an old nuke module that hasn't been supported for years.

I appreciate your replies but I'm just learning and none of this makes sense. Of course it probably doesn't help that I just had surgery and am pretty doped up right now.

shareaweb

Something like this...

$sql .= " order by abreviation";
$result = mysql_query($sql);
if (!ypSqlError($sql,$result,mysql_errno(),mysql_erro
r(),"60")) {
$numtotrows = mysql_numrows($result);
$numfirstrow = ($numtotrows / 2 );
$sql2 = $sql." LIMIT 0, $numfirstrow";
$sql3 = $sql." LIMIT $numfirstrow, $numtotrows";
$result2 = mysql_query($sql2);
$result2 = mysql_query($sql3);

Now you have three results... the total rows, result 2 which has info for the first table to iterate out, and result 3 which has the next table info.. then side-by-side the tables to look like a single table.

If your bent on the math, test first for the total / numcols,
then do the same as a modulus total % numcols.. if the modulus result is not 0, then you know to add a result to the last column... get it??

Maybe I need what you have 😉

EddieFoyJr

I get the query part but I still don't understand how to take that and output the checkboxes so it's compatible theme-wise with the rest of the postnuke module. The checkboses were reviously written as,

$boxstuff .= "<input type=checkbox name=assnid$assnarray[catid] value=1>_";
$boxstuff .= "\n<font class=\"pn-normal\">

While we're at it, can someone explain why the query was written twice and what "boxstuff", "boxTitle" and "themesidebox"is all about? Maybe if I'd understood that, the gaps in my understanding the original logic would be resolved.

I'm talking about this,

$boxstuff = "";
$boxTitle = "".ifconstant($assnarray[abreviation])."";
$sql="select * from $pntable[yp_assns] where (catid = $category AND regionid = $region) OR (catid = -1 AND regionid = -1) OR (catid = -1 AND regionid = $region) order by abreviation";
$result2=mysql_query($sql);
while ($assnarray = mysql_fetch_array($result2)) {
$boxstuff .= "<input type=checkbox name=assnid$assnarray[catid] value=1>_";
$boxstuff .= "\n<font class=\"pn-normal\">".ifconstant($assnarray[abreviation])."<br>\n";
}
$boxstuff .= "";
$row[title] = $boxTitle;
$row[content] = $boxstuff;
themesidebox($row);
echo "\n</td></tr>\n";