mysqli display rows based on row value - (if row value=1 display, else hide)

Question

I want to display 30 rows from an data base,on an TABLE, but just the approved entries. This "approved entries" are defined for an row with values "1 for approved" and "0 for NOT approved"

This is the code wath I need to change:

<?php
$servername = "localhost";
$username = "username ";
$password = "password";
$dbname = "name";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT id, label, title_id, season, episode, approved FROM links order by id desc LIMIT 30 OFFSET 1";
$result = $last_id = $conn->query($sql);


if ($result->num_rows > 0)
 {
    echo "<table><tr><th>ID</th><th>Audio</th><th>URL</th><th>Temporada</th><th>Episodio</th><th>Aprobado</th></tr>";
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "<tr><td>".$row["id"]."</td><td>".$row["label"]."</td>";
        echo "<td><a href=";
        if (empty($row['episode'])) {
     echo '/peliculas-online/'.$row["title_id"];
    }
    else {
     echo '/series-online/'.$row['title_id'].'/seasons/'.$row['season'].'/episodes/'.$row["episode"];
        }
        echo ">".$row["title_id"]."</a></td>";
        echo "<td>".$row["season"]."</td><td>".$row["episode"]."</td><td>".$row["approved"]."</td></tr>";
    }
    echo "</table>";
} else {
    echo "0 results";
}
$conn->close();
?>

Like you can see, this code list all (approved or not)... how to get something like this:

if row approved=1 display rows, else hide (hide all not just the approved row)

Need to HIDE all entries from this table row if entry is not approved -> id-label-title_id-season-episode-approved

Thanks

so what exactly is the problem? you've already got the necessary pseudo-code... — Marc B
– Marc B, Commented Jun 29, 2015 at 18:29

Funk Forty Niner · Accepted Answer · 2015-06-29 18:42:06Z

1

You should know about the MySQL WHERE clause in SELECT.

Something like:

"SELECT id, label, title_id, season, episode, approved 
 FROM links 
 WHERE approved = 1 
 ORDER BY id desc 
 LIMIT 30 OFFSET 1";

Reference:

https://dev.mysql.com/doc/refman/5.0/en/select.html

edited Jun 29, 2015 at 18:42

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Jun 29, 2015 at 18:32

James John

4152 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

mysqli display rows based on row value - (if row value=1 display, else hide)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related