In message <[EMAIL PROTECTED]>, Suzi <[EMAIL PROTECTED]> writes >I am working with a MySQL database and PHP. I need to do a count of >the records in the database table and output them to a script. I need >a simple way to do this. The table is called "manufacturers".
SELECT COUNT(*) FROM manufacturers >I will also need to do a list of the manufacturers and number them. >Using their auto-assigned ID numbers will not do because we will be >adding and subtracting manufacturers from time to time and there will >be holes in the sequential numbers. Wasn't this discussed here just a few weeks ago? (perhaps it was another group). Ignore the holes. >Can anyone help me with this? If you are able to, please email >[EMAIL PROTECTED] All replies should be sent to this list, it's good manners, unless there is a special reason that you need replies to be private. -- Pete Clark Andalucia in Sunny Southern Spain http://www.hotcosta.com/comm_1.htm 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/
