Dynamic Dropdowns inserting ID value instead of text value
I almost got this working very quickly. The drop downs themselves work on the page correctly, but I have gotten the fields wrong somewhere. Looking through the tutorial I think I've followed it correctly, but must have gone wrong somewhere.
The tables are:
Parent - categoriesFull
CategoryID (PK)
Category
eg 12, Best Safari Cuisine
Child - categoriesShort
CategoryShortID (PK)
CategoryShort
CategoryFullID
eg 12, cuisine, 12
And I have this as my insert:
$ins_nominations->addColumn("Category", "STRING_TYPE", "POST", "Parent");
$ins_nominations->addColumn("Category_Short", "STRING_TYPE", "POST", "Child");
Which is inserting the 12, 12 instead of Best Safari Cuisine, cuisine.
Have attached a copy of the file.
Thanks.