I believe what you want is to put a limit clause at the end of your sql query.
ie Select .... Limit 1 That will only return one record that matches your query. hope this helps... --shak Steve Osborne wrote: >Is there a way to SELECT only the first matching row of a query? I would >like to allow the registration of identical products (unique serial numbers >/ owned by one user), without the user having to re-enter all their data. >I've set up a page that allows them to just enter their login info (username >and password) and the serial number of the product they want to register. >What I need to do is grab their product preferences to be duplicated in the >new record, however is they have more than one registered product, it throws >off my plan. I only need one record to get the values that I need. (I know >that duplicating values is not proper database form, however I need to allow >the user to change their preferences on each owned product.) > >Any advice, > >Steve Osborne >Database Programmer >Chinook Multimedia Inc. >[EMAIL PROTECTED] > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Shakeel Sorathia Systems Administrator (626) 660-3502 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
