<div>
if we have 800-1000 users on 1 company what are the likely chances of someone getting the same invoice number at the same time?<br />
<br />
Regards<br />
Ben
</div>


<div>
Use separate tables for each company.
</div>


<div>
the system will be generally for sale online for companies to use the product, so using seperate tables is not realy something i want to explore, as if you have 900 companies it can become very messy as there is about 9 tables which require sequential numbering.
</div>


<div>
If you have &quot;9 tables which require sequential numbering&quot;, then you should reconsider your plan. &nbsp;It's already messy. &nbsp;In addition, there is a risk of exposing one company's info to the other companies if they are all in the same database, not to mention the same table. &nbsp;If I was me, each company would have it's own database.
</div>


<div>
i was going to do checks based on the logged on users id number so that only data relating their company is then displayed,<br />
<br />
What would be your guys best option for easy updates to all the systems without spending days doing manual upgrades to each installation when new features are added?<br />
<br />
Regards<br />
Ben
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Currently developing a system that will require multi company use, what would you advise the best way to get sequential invoice numbers for each company for there orders, so for example<br />
<br />
Company A)<br />
Order: &nbsp;A1, A2, A3<br />
<br />
Company B)<br />
Order: B1,B2,B3<br />
<br />
Best Regards<br />
Benji
</div>
</div>


Hi,

Currently developing a system that will require multi company use, what would you advise the best way to get sequential invoice numbers for each company for there orders, so for example

Company A)
Order:  A1, A2, A3

Company B)
Order: B1,B2,B3

Best Regards
Benji

Multiuser System with Sequential Numbers

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

HTML (HyperText Markup Language) is the main markup language for creating web pages and other information to be displayed in a web browser, providing both the structure and content for what is sent from a web server through the use of tags. The current implementation of the HTML specification is HTML5.

HTML

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.