Re: [PHP] Problem sortiing dyn query

2003-08-14 Thread John W. Holmes
Creative Solutions New Media wrote: Hi Can someone give me some indication why this might not be working? $query_Recordset1 = sprintf("SELECT * FROM sti_tracking ORDER BY '%s' '%s'", $query_Recordset1 = sprintf("SELECT * FROM sti_tracking ORDER BY %s %s", $reSort_Recordset1,$direction_Recordset1

RE: [PHP] Problem sortiing dyn query

2003-08-10 Thread Creative Solutions New Media
D] Subject: Re: [PHP] Problem sortiing dyn query Creative Solutions New Media wrote: > Hi > > Can someone give me some indication why this might not be working? > > $query_Recordset1 = sprintf("SELECT * FROM sti_tracking ORDER BY '%s' '%s'", $query_Re

RE: [PHP] Problem sortiing dyn query

2003-08-09 Thread Mark
--- Creative Solutions New Media <[EMAIL PROTECTED]> wrote: > Hi John, > > Thanks. > > Just wanted to make sure we were on the same page as the line of > code in > question wrapped in my original message. > > You saying the solution is > > $query_Recordset1 = sprintf("SELECT * FROM sti_trackin

Re: [PHP] Problem sortiing dyn query

2003-08-08 Thread John W. Holmes
Creative Solutions New Media wrote: Just wanted to make sure we were on the same page as the line of code in question wrapped in my original message. You saying the solution is $query_Recordset1 = sprintf("SELECT * FROM sti_tracking ORDER BY %s %s",$reSort_Recordset1,$direction_Recordset1); Correc

Re: [PHP] Problem sortiing dyn query

2003-08-08 Thread John W. Holmes
Mark wrote: $query_Recordset1 = sprintf("SELECT * FROM sti_tracking ORDER BY %s %s",$reSort_Recordset1,$direction_Recordset1); I'm curious. Is there an advantage to using the above format, rather than $query_Recordset1 = "SELECT * FROM sti_tracking ORDER BY $reSort_Recordset1 $direction_Record