Thank you, all, for the responses. I was able to complete my project with your help!!! :o)
The only reason I wanted the messages to go to my other email address is because I am so overworked at the moment and rarely have time to breathe let alone check lists, however, with this I made an exception! Thank you again! This group is extremely helpful! Suzi --- In [email protected], Pete <[EMAIL PROTECTED]> wrote: > > 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/
