Problem sortiing dyn query
| From: | Creative Solutions New Media | Date: | Thu, 07 Aug 2003 22:04:46 +0000 |
| Subject: | Problem sortiing dyn query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-158741@lists.php.net to get a copy of this message | ||
Hi
Can someone give me some indication why this might not be working?
$query_Recordset1 = sprintf("SELECT * FROM sti_tracking ORDER BY '%s'
'%s'",
$reSort_Recordset1,$direction_Recordset1);
the values for $reSort_Recordset1 and $direction_Recordset1 are passed
through from another page. $reSort_Recordset1 is the files to sort on and
$direction_Recordset1 is the direction (ASC or DESC).
Thanks
Tim Winters
Manager, Creative Development
Sampling Technologies Incorporated (STI)
webmaster@samplingtechnologies.com
csnm@samplingtechnologies.com
W: 902 450 5500
C: 902 430 8498