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;
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