Re: [jenolan] Curly one .. video database
Hi Larry,
Sounds like you're a programmer. :) Sometimes it can be a lot easier to have the data a little less normalized. Are the videos specific to a single record? Would it be possible to just add a field for them to the product and files section?
If not, the first step would be to figure out a query to list the tablenames and setup a list field with "Get options from MySQL Query (advanced)."
Next, you'd need another query to load the record numbers from a specified tablename. You can setup a second list field with "Get options from MySQL Query (advanced)." with this option set: Advanced Filter: Refresh list when this field changes:
yourTableNameFieldAnd then insert the tablename in the second query like this: <?php echo $ESCAPED_FILTER_VALUE ?>
When you select "Get options from MySQL Query (advanced)." it will show some advanced notes on how to do this. And it will updated field2 dynamically with ajax when field 1 changes and re-execute the mysql query for field 2 with the new value from field 1.
Hope that helps! Let me know how it goes.
Dave Edis - Senior Developer
interactivetools.com