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); select name='var' size='1' style='border-style: solid;

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, 2002