Re: Tricky Sorting

2007-04-02 Thread Shannon Appelcline
le structure, so you'll need to change the names. - Original Message - From: "Shannon Appelcline" <[EMAIL PROTECTED]> To: Sent: Saturday, March 31, 2007 1:32 AM Subject: Tricky Sorting > I'm trying to figure out the best way to do a tricky bit of sorting. > I&

Re: Tricky Sorting

2007-04-02 Thread Brent Baisley
edate, issuenum,... FROM tablename ORDER BY sortfield. I don't know your field names and table structure, so you'll need to change the names. - Original Message - From: "Shannon Appelcline" <[EMAIL PROTECTED]> To: Sent: Saturday, March 31, 2007 1:32 AM Subjec

Tricky Sorting

2007-03-30 Thread Shannon Appelcline
I'm trying to figure out the best way to do a tricky bit of sorting. I'm pretty sure it's entirely possible with an IFNULL or something, but I always feel like I hit a barrier when I get to a certain level of complexity in my MYSQL. In any case, I have some magazines, each of which has a DATE, a