Hello, I'm working on a web site which have a page for the admin to browse the clients table in a database.
To facilitate the interaction, I'm ORDERing BY Name... The pagination buttons in this page are something like: href=".....?Page=7" and when loaded, it will "SELECT * FROM Clients ORDER BY Name LIMIT 7,1" This is working perfectly but now I have a problem. I've done a page to find a client and I display the clients names in a table (Using CSS) but I don't know where to link to??? I apply a query and retrieve let's say 14 clients that match. What should the LIMIT value??? This is what I don't know how to do... Please help? Is there a way to know the position of a certain row if all the rows are selected and in a specific order? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]