Where the error in my query

Question

Please help me with this code :

<?php
                require 'connection.php';
                $by = "Batch";
                $query = 'SELECT * FROM post ORDER BY count DESC WHERE kategori="Batch" LIMIT 4';
                $exquery = mysqli_query($conn,$query);
                while($get = mysqli_fetch_array($exquery)){
                    echo '<div class="w3-container w3-quarter w3-mobile">';
                    echo '<a href="viewbatch.php?idpost='.$get['idpost'].'"target="_blank">';
                    echo '<div class="column w3-mobile w3-border-blue w3-bottombar w3-border">';
                    echo '<div class="post-module">';
                    echo '<div class="thumbnail"><img src="'.$get['pictsource'].'" />';
                    echo '</div>';
                    echo '<div class="post-content">';
                    echo '<h1 class="title">'.smart_wordwrap($get['judulpost'], 11).'</h1>';
                    echo '<h2 class="sub_title">'.$get['tanggalpost'].'</h2>';
                    echo '<p class="description">'.smart_wordwrap(substr($get['sinopsis'], 0, 12)).'....'.'</p>';
                    echo '<div class="post-meta"><span class="comments"><i class="fa fa-user"></i><a href="#"> '.$get['adminposting'].'</a></span></div>';
                    echo '</div></div></div></a></div>';
                }
            ?>

I had a php error with that code :

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /storage/ssd3/441/2169441/public_html/newennime/index.php on line 110

whats wrong with that code, please tell me how to fix it

Sorry for my bad english

I think you have to rearrange the query, the part "ORDER BY" has to be the last parameter — Tom Kuschel, Jul 15 '17 at 08:25
You should also use double quotes around the query and single quotes around the params. You've got it the other way around. — M. Eriksson, Jul 15 '17 at 08:28

Kunal Awasthi · Accepted Answer · 2017-07-15T08:26:53.817

2

WHERE clause will come first then ORDER BY and at any scenario LIMIT wil comes very last. Hoping this helps.

$query = "SELECT * FROM post WHERE kategori='Batch' ORDER BY count DESC LIMIT 4";

edited Jul 15 '17 at 08:26

answered Jul 15 '17 at 08:25

Kunal Awasthi

345
2
14

score 1 · Answer 2 · answered Jul 15 '17 at 08:27

1

Order by should be after Where:

SELECT * FROM post WHERE kategori="Batch" ORDER BY count DESC LIMIT 4

answered Jul 15 '17 at 08:27

Gulmuhammad Akbari

1,828
1
13
27

score 0 · Answer 3 · answered Jul 15 '17 at 08:28

0

'Order by' is before 'where' in the sql query. Also count is a mysqli function so needs to be inside . Should be SELECT * FROM post WHERE kategori="Batch" ORDER BYcount` DESC LIMIT 4

answered Jul 15 '17 at 08:28

adman9000

41
1
5

score 0 · Answer 4 · answered Jul 15 '17 at 08:30

You have to respect the syntax of the query...

This is incorrect :

SELECT * FROM post ORDER BY count DESC WHERE kategori="Batch" LIMIT 4

This one is correct (from what I saw in your code) :

SELECT * FROM post WHERE kategori="Batch" ORDER BY count DESC LIMIT 4

Where the error in my query

4 Answers4