Problema su wishlist

[Ferb]

Taigi turiu tokia problema su wishlist  kad idejus daikta su viena paskyra  matai ta daikta wishliste kai prisijungi su kita paskyra.

<?php 
include('db.php');
include "header.php";
?>
<div class="container text-white">
    <h2 class='text-center text-white'>Patinkančios prekės</h2>
    <section id="content">
		<div class="content-blog content-account">
			<div class="container">
			<div class="row">		 
					<div class="col-md-12">
			<br>
			<table class="cart-table account-table table table-bordered bg-white text-dark">
				<thead>
					<tr>
						<th>Pavadinimas</th>
						<th>Kaina</th>
						<th>Laikas</th>
						<th></th>
					</tr>
				</thead>
				<tbody>
				<?php
				$c_id = $_SESSION['uid'];
				$sql = "SELECT * FROM wishlist JOIN products on products.product_id=wishlist.pid";
				$result = mysqli_query($con, $sql);
				if (mysqli_num_rows($result) > 0) {
				 // output data of each row
				 while($row = mysqli_fetch_assoc($result)) {
 			?>
			<?php if($_SESSION['uid']) {?>
					<tr>
						<td>
                        <a href="product.php?p=<?php echo $row["product_id"] ?>">	<?php echo $row["product_title"] ?></a>
						</td>
						<td>
						<?php echo $row["product_price"] ?>
						$
						</td>
						<td>
						<?php echo date('M j g:i A', strtotime($row["timestamp"]));  ?>		
						</td>
						<td>
							<a href="delete-wishlist.php?pid=<?php echo $row["product_id"] ?>&cid=<?php echo $_SESSION['uid'] ?>">ištrinti</a>  
						</td>
					</tr>
			<?php
				 }}
			  }  else {
				 echo "Nėra patinkančių prekių";
			   }
			 ?>
				</tbody>
			</table>		
			</div>
					</div>
				</div>
			</div>
		</div>
	</section>
</div>

<?php
include "footer.php";
?>

 

[nogalosa]

SQL užklausoje nėra WHERE statement tad atvaizduojama tiesiog visa wishlist lentelė.

[Ferb]

prieš 1 valandą, nogalosa parašė:

SQL užklausoje nėra WHERE statement tad atvaizduojama tiesiog visa wishlist lentelė.

dq fixed