MYSQL multiple select query in one php page

Question

I'm trying for days now to catogorize my videos on a browsepage, but when i try. One sql gives results and the other one says it has 0 results.

    <?php
include("db-conct.php");

$cato = "SELECT * FROM movies WHERE `cato` = 'cato' ORDER BY views DESC";
$result = $conn->query($cato);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
    }
}else{
echo "0 results";
}

$conn->close();
?>
<?php
$cato1 = "SELECT * FROM movies WHERE `cato` = 'cato' ORDER BY views DESC";
$result = $conn->query($cato1);

if ($result->num_rows > 0) {
    // output data of each row
    while($row1 = $result->fetch_assoc()) {
    }
}else{
    echo "0 results";
}

$conn->close();
?>

I hope someone knows what the problem is.

Add ini_set('display_errors', 1); ini_set('log_errors',1); error_reporting(E_ALL); mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); to the top of your script. This will force any mysqli_ errors to generate an Exception that you can see on the browser and other errors will also be visible on your browser. — RiggsFolly
– RiggsFolly, Commented Aug 30, 2018 at 2:24
@Funk I'm so sorry i forgot about it. I had to wait for 10 minutes so i start coding again. I've added the solved answer and i try to remember for the next time not to edit my question. Seems logic :) Thanks — LonnyBrum
– LonnyBrum, Commented Sep 1, 2018 at 13:31

Devon Bessemer · Accepted Answer · 2018-08-29 23:39:20Z

3

You're closing your connection after the first query:

$conn->close();

You should add error handling to your queries. http://php.net/manual/en/mysqli.error.php

answered Aug 29, 2018 at 23:39

Devon Bessemer

35.6k10 gold badges77 silver badges102 bronze badges

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

3 Comments

LonnyBrum Over a year ago

You're right man. It worked. Such a simple thing that i didnt saw. I use error handling but i tought maybe i waste ur time. Thank you so much

Devon Bessemer Over a year ago

The error should say something more useful than your 0 results, like the connection was closed.

LonnyBrum Over a year ago

This is a really good one ini_set('display_errors', 1); ini_set('log_errors',1); error_reporting(E_ALL); mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

Collectives™ on Stack Overflow

MYSQL multiple select query in one php page

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related