How to add a automatically after every 2

Question

i am retrieving results from MySQL with PHP based on user search

i want to add a automatically after every 2 s in the result

<?php
include_once("config.php");
isset( $_REQUEST['name'] ) ? $name=$_REQUEST['name'] : $name='';
$name = mysql_real_escape_string( $name );
if (strlen($name) >= 4) {

     $sql = "select * from places where speciality like '%$name%'";

     $rs = mysql_query( $sql ) or die('Database Error: ' . mysql_error
    $num = mysql_num_rows( $rs );

    if($num >= 1 ){     
        echo "<table id='result-table'><tr>";           
while($row = mysql_fetch_array( $rs )){

    echo "<td>row[cname]</td>"; //here i want to add </tr><tr> after 2 <td>s

 }

    }else{
        echo "no records found</table>";
    }
}
?>

possible duplicate of [Insert tr after every third loop](http://stackoverflow.com/questions/9008522/insert-tr-after-every-third-loop) and many others — JJJ, Jul 29 '13 at 11:29

score 2 · Answer 1 · answered Jul 29 '13 at 11:27

2

echo "<table id='result-table'><tr>";
$currentCount = -1;
while($row = mysql_fetch_array($rs))
{
    echo "<td>row[cname]</td>";
    $currentCount = ($currentCount + 1) % 2;
    if($currentCount == 1)
    {
        echo '</tr><tr>';
    }
}

answered Jul 29 '13 at 11:27

mdziekon

3,531
3
22
32

score 2 · Accepted Answer · answered Jul 29 '13 at 11:29

Used $i = 1; if ($i % 2 == 0) and $i++;

<?php 
include_once ("config.php");
isset ($_REQUEST['name']) ? $name = $_REQUEST['name'] : $name = '';
$name = mysql_real_escape_string($name);
if (strlen($name) >= 4) {
  $sql = "select * from places where speciality like '%$name%'";
  $rs = mysql_query($sql) or die('Database Error: '.mysql_error $num = mysql_num_rows($rs);
  if ($num >= 1) {
    $i = 1;
    echo "<table id='result-table'><tr>";
    while ($row = mysql_fetch_array($rs)) {
      echo "<td>row[cname]</td>"; //here i want to add </tr><tr> after 2 <td>s
      if ($i % 2 == 0)
        echo "</tr><tr>";
      $i++;
    }
  }
  else {
    echo "no records found</table>";
  }
}
?>

score 0 · Answer 3 · answered Jul 29 '13 at 11:30

0

I suggest not putting them into a table at all; instead simply put them into <div> elements, with float:left and width:50% styles.

If you must put them into a table, and you want to do it the way you asked, you can use PHP's modulo operator (%) to divide the current record number by 2 and get the remainder. If it's 1, then add the <tr> tag:

if(++$rowNum % 2) {print "</tr><tr>";}

answered Jul 29 '13 at 11:30

Spudley

166,037
39
233
307

@AdamTester: Surely no, this really isn't tablular. Or, well if it is, he's not asking for it to be laid out out like tablular data; it's just a list of matching names. He wants it in two columns, but that doesn't change the fact that it's basically just a single dimensional data set. – Spudley Jul 29 '13 at 11:37

How to add a automatically after every 2

3 Answers3