Displaying records in 2 columns

[jonnym]

I would like to display my query results in a 2 column html table. 2 records per row then move to the next row. How is this done in PHP?

[ir4z0r]

// query stuff

$count = 0;
while ($row = mysql_fetch_array($result))
{
  if (!$count) echo "<tr>";
  echo "<td>" . $row['mycolumn'] . "</td>";
  if ($count)
  {
    echo "</tr>";
    $count = 0;
  }
  else $count++;
}

[jonnym]

I get a parse error on the first line you gave me.

Thanks for your help!

[stolzyboy]

you should be able to figure out parse errors, look at semicolons, brackets and such, alot of us give you the right idea, but don't test it for sake of time, anyway, all the problem was, was that he forgot the {}'s around the if block, you only don't need the {}'s when the if block if it is only one line

// query stuff

$count = 0;
while ($row = mysql_fetch_array($result))
{
if (!$count)
{
echo "<tr>";
echo "<td>" . $row['mycolumn'] . "</td>";
}
if ($count)
{
echo "</tr>";
$count = 0;
}
else $count++;
}

[ir4z0r]

but this way it's wrong, there's no need for {} since I wanted
only ONE statement in the if-clause

please post the error message and assure, you did all mysql_query() and stuff correctly

[jonnym]

Here's my code. The query statement works with my other code. But once I add your code, it just says parse error on line 16

<?php

$db = mysql_connect("servername", "user", "pass");
mysql_select_db("dbname",$db);

$result = mysql_query("SELECT manufacturer, item_name, stock_no, ww_item_no FROM products WHERE subclass = 't-shirts' ORDER BY item_name ASC",$db);

$count = 0;
while( $row = mysql_fetch_array ($result ))
{
if(! $count )echo "<tr>" ;
echo "<td>" . $row ['mycolumn' ]. "</td>" ;
if( $count )
{
_echo "</tr>" ;
$count = 0;
}
__else_ $count ++;
}

?>

[ir4z0r]

I can't see any errors 😕 please post code by using [.php] before and [./php] after your code (WITHOUT the .)

another version:

//query

if ($result)
{
  for ($i=0; $i < mysql_num_rows($result); $i +=2)
  {
    $row = mysql_fetch_array($result);
    echo "<tr>";
    echo "<td>" . $row['acolumn'] . "</td>";
    if ((mysql_num_rows($result) % 2) == 0)
    {
      $row = mysql_fetch_array($result);
      echo "<td>" . $row['acolumn'] . "</td>";
    }
    echo "</tr>";
  }
}

[jonnym]

Still getting an error. This time it's your 2nd line of code. Could I have a different version of PHP than you? I'm using PHP Version 4.2.3

$db = mysql_connect("servername", "user", "pass");
mysql_select_db("dbname",$db);

$result = mysql_query("SELECT manufacturer FROM products WHERE subclass = 'sticks' ORDER BY item_name ASC",$db);

if_( $result )
{
  for_( $i =0;_ $i_ <_ mysql_num_rows ($result );_ $i_ += 2)
  { 
    $row_ =_ mysql_fetch_array ($result ); 
    echo_ "<tr>" ;
    echo_ "<td>"_ ._ $row ['manufacturer' ]_._ "</td>" ;
    if_(( mysql_num_rows ($result )_%_ 2)_==_ 0)
    { 
        $row_ =_ mysql_fetch_array ($result ); 
    echo_ "<td>"_ ._ $row ['manufacturer' ]_._ "</td>" ;
    } 
    echo_ "</tr>" ;
  } 
}

[stolzyboy]

make this

$db = mysql_connect("servername", "user", "pass");
mysql_select_db("dbname",$db);

$result = mysql_query("SELECT manufacturer FROM products WHERE subclass = 'sticks' ORDER BY item_name ASC",$db);

into

$db = mysql_connect("servername", "user", "pass");
$conn = mysql_select_db("dbname");

$result = mysql_query("SELECT manufacturer FROM products WHERE subclass = 'sticks' ORDER BY item_name ASC");

and if you are still getting an error, tell us the exact error and tell us where the error occurs, not just line number, put a comment where it is

[jonnym]

Same error.
"Parse error: parse error in /opt/web/sitename/webshare/test.php on line 18"

$db = mysql_connect("servername", "user", "pass");
$conn_= mysql_select_db("dbname");
$result = mysql_query("SELECT manufacturer FROM products WHERE subclass = 'sticks'");


if_( $result )
//the error is on the next line.
{
  for_( $i =0;_ $i_ <_ mysql_num_rows ($result );_ $i_ += 2)
  { 
   $row_ =_ mysql_fetch_array ($result ); 
    echo_ "<tr>" ;
    echo_ "<td>"_ ._ $row ['manufacturer' ]_._ "</td>" ;
    if_(( mysql_num_rows ($result )_%_ 2)_==_ 0)
    { 
      $row_ =_ mysql_fetch_array ($result ); 
    echo_ "<td>"_ ._ $row ['manufacturer' ]_._ "</td>" ;
    } 
    echo_ "</tr>" ;
  } 
}

[ir4z0r]

what are these _ everywhere? what editor do you use?
please post the whole script, and assure to have set the [ php] tags correctly

[jonnym]

I don't know what was causing the underscores. It could be that I'm on a mac using the Safari browser.

Anyway, for some reason, the script worked fine as long as I put the connect and query statements in seperate dilimiters from the rest. Any idea why that worked?

[ir4z0r]

err .. no, could this be a mac specific issue?

what exactly did you do?

[EddieFoyJr]

I noticed the same thing happening to me. I use BBedit Lite 6.1 for Mac OS X.