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
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
Code: Select all
this is ment to just show the records off the person logged in but seems to get an error.
$sql = 'SELECT * FROM orders LIMIT '.$page1.', 4';
Code: Select all
$sql = 'SELECT * FROM orders WHERE OrderBy = '$username'LIMIT '.$page1.', 4';