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