<div>
Great stuff, thank you<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
I am creating a shop and my client has just asked if they can have a next and previous button when viewing a product. These two links would also feature the names of the next and previous products.<br />
When the products are listed they are listed on the page in the order of the primary key descending.<br />
So when they are viewing a product with a particular id what is the easiet way to find the next a previous product in the databse and display their details (name).<br />
Many thanks<br />
Matt
</div>
</div>


Hi
I am creating a shop and my client has just asked if they can have a next and previous button when viewing a product. These two links would also feature the names of the next and previous products.
When the products are listed they are listed on the page in the order of the primary key descending.
So when they are viewing a product with a particular id what is the easiet way to find the next a previous product in the databse and display their details (name).
Many thanks
Matt

MySQL search, previous record

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.