You can see my content page here:
http://led-pwr.com/powergatellc/index.php?option=com_content&view=article&id=106&Itemid=202
The plugin is enabled but I can not get a table to display for the life of me. Just for testing, I used this syntax:
{artsqltable query="SELECT title,alias from jos_categories" headerNames="title,alias" headers="title,alias" } {/artsqltable}
Once i can get any table to display, I think I'll need help writing the syntax to display a table that pulls from my sql database with the following specifics:
table = jos_j_cat1_series
Filter = where category_id = 3
Display = name, col1_value, col2_value, col3_value, col4_value, col5_value, length, width, height
Sorted by = col1_value
Headers = Series, Watts, Vin, Vout, Type, Case, Length, Width, Height
If you could provide me the syntax for this one type of query, I can figure it out for the dozens of other queries I might need.
Your help is deeply appreciated,
Gorden