In message <[EMAIL PROTECTED]>, under_my_forbidden_rock <[EMAIL PROTECTED]> writes >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.
A *row* is for one item... You could use one *column* or field if you know that the codes are different - they usually are - but I would use two columns, one for internal identification, probably never seen by the public, but used by PHP, and one for the Item ID, which is the one that would be recognised by human staff. Depending on the layout of the item ID field, a numeric Product ID could be marginally easier and faster to handle. But it would certainly be future proof. -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/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/
