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:
[url removed, login to view]
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!