Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

SQL query help - ORDER BY 'paid links'

Quote Reply
SQL query help - ORDER BY 'paid links'
Hi,

Im using Glinks 3.1.0 with payments enabled.
I need to write an sql query outside of Glinks and i need the results to display the paid links before the free ones.

Lets say my SQL query is as follows:
SELECT * FROM glinks_Links Where State = 'CA' ORDER BY <insert paid links criteria here>, price ASC.

so what i need to figure out is how to find out which links are paid.

Any ideas?