SELECT * FORM table_name WHERE ID IS NULL LIMIT 1;
Steve Osborne wrote:
SO: Date: Thu, 13 Dec 2001 12:47:26 -0800
SO: From: Steve Osborne <[EMAIL PROTECTED]>
SO: To: "MySQL (E-mail)" <[EMAIL PROTECTED]>
SO: Subject: SELECT'ing only 1st matching row
SO:
SO: Is there a way to SELECT only the first matching row of a query? I would
SO: like to allow the registration of identical products (unique serial numbers
SO: / owned by one user), without the user having to re-enter all their data.
SO: I've set up a page that allows them to just enter their login info (username
SO: and password) and the serial number of the product they want to register.
SO: What I need to do is grab their product preferences to be duplicated in the
SO: new record, however is they have more than one registered product, it throws
SO: off my plan. I only need one record to get the values that I need. (I know
SO: that duplicating values is not proper database form, however I need to allow
SO: the user to change their preferences on each owned product.)
SO:
SO: Any advice,
SO:
SO: Steve Osborne
SO: Database Programmer
SO: Chinook Multimedia Inc.
SO: [EMAIL PROTECTED]
SO:
SO:
SO: ---------------------------------------------------------------------
SO: Before posting, please check:
SO: http://www.mysql.com/manual.php (the manual)
SO: http://lists.mysql.com/ (the list archive)
SO:
SO: To request this thread, e-mail <[EMAIL PROTECTED]>
SO: To unsubscribe, e-mail
<[EMAIL PROTECTED]>
SO: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SO:
--
Sherzod Ruzmetov <[EMAIL PROTECTED]>
http://www.UltraCgis.com, Consultant
989.774.6265
+----------------------------------------+
| There is nothing wrong with your tools.|
| But we can make a better one. |
+----------------------------------------+
---------------------------------------------------------------------
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
