I am trying to select database data based on membership levels. If a member is level 1 he/she will be shown level 1 data, and if he/she is level 2 then they will see both level 1 and level 2 data.
Here is a table example:
member| membership_level
------|----------------
john | 1
------|-----------------
andy | 2
Then I have PHP code that presents data based on membership_level, like so:
<?php if($userMember_level == 1) { ?>
Show data for membership level 1
<?php }elseif($userMember_level == 2) { ?>
Show data for membership level 1 And membership level 2
And here is my Mysqli statement:
//connect to database
require_once("../../db_query/connection.php");
$sql = "SELECT id,title,postdate FROM getting_started WHERE membership_level = ? AND active = ? AND membership_level = ? ORDER BY id DESC";
$stmt = $con->prepare($sql);
$stmt->bind_param('iii',$b=1,$a=1,$c=2);
$stmt->execute();
$stmt->store_result();
$numrow = $stmt->num_rows;
if($numrow >0){
$stmt->bind_result($id, $title, $postdate);
while($stmt->fetch()){ }
?>
<div class="resultWrap"> ...
I'm not getting any errors, but I'm not getting any results either.
Thanks for any help.
The SQL you are looking for is:
$sql = "
SELECT id,title,postdate
FROM getting_started
WHERE membership_level IN (?,?)
AND active = ?
ORDER BY id DESC
";
$stmt->bind_param('iii',1,2,1);