query parameter error in php query

Question

Here elow is my query.Its working fine on my local server but when I push it on live server it give me error as

"Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/softlogics/public_html/development.php on line 5"

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/softlogics/public_html/development.php on line 6

Here below is my piece of code

<ul id="top-menu" class="nav navbar-nav navbar-right mu-main-nav">
<?php
  $menu = "SELECT * FROM `menu` WHERE page = '' OR page = 
  'development' AND block = '0' ";
   $result = mysqli_query($conn, $menu);
   while ($row = mysqli_fetch_array($result)) {
   ?>
   <li><a href="#<?php echo $row['section_id'];?>"><?php echo 
   $row['name'];?></a></li>
   <?php
   }
   ?>
   <li><a class="mu-orange-btn" href="training.php">Training</a></li>
   </ul>

Thanks in advance for any assistance.

Please do a search before asking a question. Google search for `mysqli_fetch_array()/mysqli_fetch_assoc()/mysqli_fetch_row() expects parameter 1 to be` would give you a whole page of results.... **all of which are on StackOverflow** — RiggsFolly, Sep 21 '17 at 09:26
Basically `$conn` is not a valid connection to your database. Did you do a `mysqli_connect()` ??? — RiggsFolly, Sep 21 '17 at 09:27
NOTE: you also need brackets around your `OR` like this `$menu = "SELECT * FROM `menu` WHERE (page = '' OR page = 'development') AND block = '0' "` — RiggsFolly, Sep 21 '17 at 09:29

score -2 · Answer 1 · answered Sep 21 '17 at 09:26

-2

you can print error from sql statement by using

<?php 
     mysqli_query($conn, $menu) or die("Error description: " . mysqli_error($conn));
 ?>

answered Sep 21 '17 at 09:26

Pritamkumar

680
1
10
27

query parameter error in php query

1 Answers1