I'm having trouble displaying my results in different rows using SQL

Question

I would like to display 2 rows of 5 but i can't seem to think of the logic behind. Help is appreciated.

$sql = " SELECT  KEYWORD, COUNT(*) Count_Duplicate
FROM {$_POST['btn']}
GROUP BY KEYWORD
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC
LIMIT 10";

This is my SQL query part and i echo it like this,

echo   $row['KEYWORD'] .", " ."  "  ;

what do you mean display 2 rows of 5 ? you only have 5 rows in the db? change LIMIT 10 to LIMIT 5 ?? — MarkP
– MarkP, Commented Jan 31, 2016 at 6:37
The results now show 10 words because i limit it to 10. I want to break the 10 words into 2 rows of 5. — Lim Xing Wei
– Lim Xing Wei, Commented Jan 31, 2016 at 6:42

Vadivel S · Accepted Answer · 2016-01-31 06:53:36Z

1

try this code.

$sql = " SELECT  KEYWORD, COUNT(*) as Count_Duplicate FROM {$_POST['btn']} GROUP BY KEYWORD
HAVING COUNT(*) > 1 ORDER BY COUNT(*) DESC LIMIT 2";

use loop for display results

answered Jan 31, 2016 at 6:53

Vadivel S

6608 silver badges15 bronze badges

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

Comments

Mr. Engineer · Accepted Answer · 2016-01-31 07:03:52Z

1

You can use limit with offset value it will help you for lazy-loading also. Limit can be change in this way.

$sql = " SELECT  KEYWORD, COUNT(*) Count_Duplicate 
          FROM {$_POST['btn']} GROUP BY KEYWORD HAVING COUNT(*) > 1 
            ORDER BY COUNT(*) DESC LIMIT 2,OFFSET 10";

Offset shows the index upto which the rows will be select, and you can ignore OFFSET use limit as LIMIT 2, 10; only.

edited Jan 31, 2016 at 7:03

Mr. Engineer

3,5254 gold badges20 silver badges34 bronze badges

answered Jan 31, 2016 at 6:51

Lawakush Kurmi

3,1261 gold badge18 silver badges29 bronze badges

Collectives™ on Stack Overflow

I'm having trouble displaying my results in different rows using SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related