apoligies if this query in wrong section .....
 

Hi, if this query is in the wrong section I do apologise. My query is this, I have written a database for an small company involving personal records. The database consists of the normal tables (first name, surname, contact details, phone number, email address, work number, department etc...). Now when I search the surname smith (for example) 5 smith records are displayed on the same screen, which means I have to scroll down to view them all. Is there a way that one record could be displayed at a time, then you press a button which will then display the next record and so on until all the smith have been displayed on the same screen without scrolling down. Hope you all understand what I mean. Thanks in advance

Re: apoligies if this query in wrong section .....
 

Which Database you are using.

LIMIT 1 can be an option.

mysql .....
 

I'm using a mysql database with php, html & css files

Re: apoligies if this query in wrong section .....
 

Use LIMIT 1 and that would only give you one record.

Re: apoligies if this query in wrong section .....
 

I'm not quite sure where to insert limit 1 yet but I'll work on that, so it's as simple as that, by inserting limit 1 it will display one record at a time and go to the next record when I click on a button. Knowledge certainly is power cheers mate I'll try that this afternoon