need help morphing this to a useable query
Posted: Sat Aug 23, 2003 6:07 pm
this link below is sli.
http://24.91.157.113/findyourdesire/SQLqueryissue
it shows the response i got..
what i'm trying to do for the forums i'm making is have one query that returns threads by the date they were made ... first giving me the ones that are stickied, both in descending order.
i'm not sure that's possible but figured that with getting this on the test db i made that someone might be able to tell me how to adjust it to work. on that i'm using the tid instead of the date. obviously it's not a real table, the real ones are MUCH more complicated
http://24.91.157.113/findyourdesire/SQLqueryissue
it shows the response i got..
what i'm trying to do for the forums i'm making is have one query that returns threads by the date they were made ... first giving me the ones that are stickied, both in descending order.
i'm not sure that's possible but figured that with getting this on the test db i made that someone might be able to tell me how to adjust it to work. on that i'm using the tid instead of the date. obviously it's not a real table, the real ones are MUCH more complicated