Project Detail

Description

I have a mySQL table in my database which I wanted linked to a popular AJAX Table Editor.

The SQL statement to generate the table is attached as a pdf.

The AJAX editor that should be used can be found here and downloaded for free:
http://www.mysqlajaxtableeditor.com/Documentation.php

The initial query should read as follows:
SELECT * FROM PRODUCTS WHERE systemuserid=$_COOKIE[‘systemuserid’]

While ProductID is the primary key, I don’t want it displayed – used ProductCode instead.
Also when inserting a new product, check that the combination of systemuserid and ProductCode is unique. (that is, there can be only one productcode=5000A for systemuserid=2, but there can be several productcode=5000A in the table)

The fields ImageActive and Link3_Active should be checkboxes. The Image field should take an URL.

This should be very straightforward – the code provided by the above link does absolutely everything needed. You just need to rename/replace the fields accordingly.

So bid accordingly, since this should take an experienced programmer very little time!


Additional files submitted:
tablestructure+-+Copy.pdf