Quite an interesting task to set up a method to easily allow the Shop Owner to see if a model name for a product has already been used whilst adding a new product.
This type of checking is done a lot for usernames in forums and blogs etc. With a bit of thought, it’s easy to replicate in osCommerce.
I used jQuery, linking to MySQL to interrogate the database and then return a message, and easy to see CSS changes (green if OK, red if not).
In the video I used MG200MMS as a test as this model number exists in the database. As it exists, the entry field turns red and gives an error message with a stop image;
If I then change it to something else (that doesn’t already exist), it turns green with a nice message and image;
Nice, I think!