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) [EMAIL PROTECTED] [EMAIL PROTECTED] W: 902 450 5500 C: 902 430 8498 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php