displaying by username

[Markob]

hello

im using this to display my records in a table with pagination but it will show all the records but i want it do it only shows the records that the username put in to the database i tried this.

below shows all the records

$sql = 'SELECT * FROM orders LIMIT '.$page1.', 4'; 

this is ment to just show the records off the person logged in but seems to get an error.

CODE: SELECT ALL

$sql = 'SELECT * FROM orders  WHERE OrderBy = '$username'LIMIT '.$page1.', 4'; 

[HarshShah]

Hello Markob,

Try this code...

<?php
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
$start_from = ($page-1) * $results_per_page;
$sql = "SELECT * FROM ".$datatable." ORDER BY ID ASC LIMIT $start_from, ".$results_per_page;
$rs_result = $conn->query($sql); 
?>

For more Clarification refer this site https://www.phpjabbers.com/php--mysq...ges-php25.html