You *can* get away with using your product numbers, but to be on the safe side (in case you ever need to make them alphanumeric or decimal (e.g your product code becomes 1073.1 or 99a) which would mean changing other fields as well) you should have an autoinc field.
Ian ----- Original Message ----- From: under_my_forbidden_rock To: [email protected] Sent: Monday, October 24, 2005 2:11 AM Subject: [php-list] Database Question Please forgive me if this sounds stupid. I'm new to the programming world. I want to start creating a database of products, their descriptions, images, etc. to be pulled up from individual product pages (well over 100), programmed with PHP. From the examples that I've seen out of books and on the net, the ID number is usually automatic. However, the products have numbers. Should it be a row for: Product ID (1, 2, 3, etc) and then Item Number; or should there be only a row for Item number to serve as the identifying number. Thanks in advance!! Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list ------------------------------------------------------------------------------ YAHOO! GROUPS LINKS a.. Visit your group "php-list" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------------------------------------------------------------ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/HKFolB/TM --------------------------------------------------------------------~-> Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
