If you are using perl/DBI you can usee my @row = $dbh->fetchrow_array() instead of the usual while()... it will only take the first row returned.
Etienne Ron Jamison wrote: > > Tack on a "LIMIT 1" on the end of your query to limit the returned rows to > 1. > > Reference: > http://www.mysql.com/doc/S/E/SELECT.html > > -----Original Message----- > From: Steve Osborne [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 13, 2001 12:47 PM > To: MySQL (E-mail) > Subject: SELECT'ing only 1st matching row > > 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 > > --------------------------------------------------------------------- > 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 --------------------------------------------------------------------- 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
