RE: Desc question

2002-12-09 Thread Anderson, Alan R
> From: Alex Behrens [mailto:[EMAIL PROTECTED]] > ...How can I make it so only one form > selection adds a DESC tag to the query, is this possible? > > I'm using this code: > > $fetch = mysql_query("SELECT * FROM players ORDER BY $var"); > > > Name > Position > Number > Grade > > I want only t

Re: Desc question

2002-12-08 Thread Jocelyn Fournier
Hi, if ($var=='grade_num') $filter='DESC'; else $filter='ASC'; $fetch = mysql_query("SELECT * FROM players ORDER BY $var $filter"); should work. Regards, Jocelyn - Original Message - From: "Alex Behrens" <[EMAIL PROTECTED]> To: "MYSQL" <[EMAIL PROTECTED]> Sent: Monday, December 09