PHP: Split results of query into 2 columns

Question

I want to load contacts from a query, Whilst I have found ways to split by the amount of rows I want the result to be split into two columns as below as well as them being a sort of clickable button.Is it possible to display the query results as described below by the use of HTML or by the query itself? :

Contacts
------------------------------
Albert Smith   | Ben Marshall
Benjamin Jones | Chris Jones

I have tried the code below

<? 
$rowcount = mysql_num_rows($records);
echo "<div id='column1'>";
$i = 0;
while ($d = mysql_fetch_object($records)) {
  echo $d->name;
  $i++;

  if ($i == floor($rowcount / 2)) {
      echo "</div><div id='colums2'>";
  }
}
echo "</div>";
?>

But this splits the columns by reaching half of the results in 1 column and the rest in another column

Albert Smith | Benjamin Jones

Ben Marshall | Chris Jones

Put here some test datas and your query or what have you tried till now — Marek Maszay
– Marek Maszay, Commented Aug 18, 2017 at 9:36
Have you tried using subqueries and filtering by odd and even? — NullPointerException
– NullPointerException, Commented Aug 18, 2017 at 9:38

Thibault Dumas · Accepted Answer · 2017-08-18 09:40:09Z

2

This is not possible by query itself. You must parse the result with an html <table>, every two results make a new <tr> and double <td>

answered Aug 18, 2017 at 9:40

Thibault Dumas

1,0802 gold badges11 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

NullPointerException Over a year ago

It is possible to achieve those results by SQL but I'm agree with you, using a table is more efficient.

Chanter Over a year ago

So using php I parse the result and whenever the number is divisble by 2 a new table is created for the following sets?

Thibault Dumas Over a year ago

if ($i % 2 == 0 && $i != count($records)) { // do ur thing }

Mwangi Thiga · Accepted Answer · 2017-08-18 10:00:48Z

1

I'm guessing you are conversant with coding: Check this algorithm

get results
declare an even/odd check variable
loop through your result-set
List item

increment the counter in each loop

ii. check counter value in the loop
- iii. if counter variable value is even give it a different class
- To make them a clickable button, you can use bootstrap as (ie. give an tag the style of a button)

Let me know on how it works out. Have fun coding.

answered Aug 18, 2017 at 10:00

Mwangi Thiga

1,37918 silver badges23 bronze badges

3 Comments

Chanter Over a year ago

Altough I am close to what I need, Im having a bit of trouble, the columns are not being placed as they should for some reason the even column is being put in a new row and in the 2 columns of that row

Mwangi Thiga Over a year ago

Could you please upload a screenshot of the same. It will be helpful

Mwangi Thiga Over a year ago

Image isn't loading

Collectives™ on Stack Overflow

PHP: Split results of query into 2 columns

2 Answers 2

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related