I'm trying to extend the code :
SELECT uid, affiliate_uid FROM user ORDER BY affiliate_uid
To bring back all matching results but first listing rows where user.affiliate_uid=$affid and then listing all remaining results (where $affid is not necessarily the maximum or the minimum value $affid can take).
Any pointers would be welcome.
Many thanks,
C
SELECT uid, affiliate_uid FROM user ORDER BY affiliate_uid
To bring back all matching results but first listing rows where user.affiliate_uid=$affid and then listing all remaining results (where $affid is not necessarily the maximum or the minimum value $affid can take).
Any pointers would be welcome.
Many thanks,
C
Help with ORDER BY and expressions?