Re: [PHP] Piping and the CLI parser

2003-08-09 Thread Jason Wong
On Wednesday 06 August 2003 21:29, Nicolas Frisby wrote: Regardless of that, do you know anything of how the piping mechanism works? Not really. I do know that what you're trying to do doesn't work for bash scripts either. IE you cannot use a pipe to pass command line arguments to a bash

Re: [PHP] Problem sortiing dyn query

2003-08-09 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);

Re: [PHP] magical file writing truncation

2003-08-09 Thread skate
[snip] $newFile = xml/.$type./.$now..xml; while(file_exists($newFile)) $newFile = xml/.$type./.$now++..xml; $text = $_POST['text']; $text = urlencode(stripslashes(nl2br($text))); [/snip] At this point (for testing putposes) I would echo $text; and start looking for clues. If I

Re: [PHP] Max script size

2003-08-09 Thread Jeff Held
Transfering data between mysql servers. I create a mysql insert file via file system, ftp the file to another server, then exe it...all on a schedule. I know there is a better way, but this way is very fast, well until the file got to big. My solution now is to break it over two files (easy).

Re: [PHP] setting function variables

2003-08-09 Thread CPT John W. Holmes
From: Mark [EMAIL PROTECTED] I seem to learn something new every time you or Jennifer post (many others as well). I never knew about variable functions. Cool! You're welcome. I wouldn't recommend that solution exactly (an abstraction class would be better), but the functions do come in handy.

[PHP] Max script size

2003-08-09 Thread Jeff Held
I have a 6MB PHP script that just won't exe on the live server. It works on the local one. Any ideas on a setting that may limit the script. It is not timing out, it only takes about 3 sec to exe. Jeff -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] where are my errors?

2003-08-09 Thread David T-G
Hi, all -- ...and then John W. Holmes said... % % David T-G wrote: % % My partner and I have done something that gets rid of our error messages, ... % % is display_errors ON for one machine and OFF for the other? Now that I've confirmed that display_errors is on (1), are there any other

Re: [PHP] for the love of god, remove me

2003-08-09 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... It's not usless if you read the page. [EMAIL PROTECTED] As I said, the page is useless. This doesn't work either. J. You may be trying to unsubscribe from a different email address that the one used originally to subscribe.

Re: [PHP] Old version of PHP

2003-08-09 Thread Dan Phiffer
Thanks for all the feedback, guys. Is there an errata page somewhere that lists known bugs in the PHP interpretter? Thanks, -Dan Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Friday 08 August 2003 09:43, Justin French wrote: i think the best reason to keep

Re: [PHP] magical file writing truncation

2003-08-09 Thread skate
obviously there's no simple solution here... can anyone point me in the way of an alternative way of doing this? i could try the file write in 3 stages, first part of content, text, end of content, as they seem to write fine seperatly. this is magical, evening seperating the file open, and

RE: [PHP] magical file writing truncation

2003-08-09 Thread Jay Blanchard
[snip] i really can't get my head around this one at all. could it possibly be a windows issue??? i know windows can be an arse in dealing with files, but i can't see how it could pick up on a variable inside PHP and truncate it? [/snip] I just have one more thought because you brought up

[PHP] Re: funcky parse error message due to { } or not sure what else mightcause

2003-08-09 Thread Shena Delian O'Brien
Can you post the entire error? Is that a or a '' ? if a , you need a closing to go with it. Jim M Gronquist wrote: I added one term to a listing - if ( $follow_up == ) { $error=true; } and now I'm getting a parse error Ugh I

RE: [PHP] Best PHP CMS

2003-08-09 Thread Matt Schroebel
-Original Message- From: Anthony [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 9:52 AM To: [EMAIL PROTECTED] Subject: [PHP] Best PHP CMS I'm just looking for some opinions. I've been going though sourceforge looking at different CMS systems. There are a lot of

[PHP] Question on class syntax

2003-08-09 Thread Luis Lebron
I am currently using a php class that uses the following syntax: $value= htmlcleaner::cleanup($value); What exactly is the :: used for? Is there a different syntax for :: ? thanks, Luis R. Lebron Project Manager Sigmatech, Inc

Re: [PHP] easier than switch

2003-08-09 Thread Nicholas Robinson
As, in this case, only one of the variables is non-null, then you could use the string concatenation operator and this would return what you want. i.e. type = $_POST['news'] . $_POST['dreams'] . $_POST['storys']... I think I've used the same variable name in different forms on the same page,

Re: [PHP] Mail

2003-08-09 Thread Sean
Thanks for the quick response. 1 and 2 work 3 does not giving unable to relay for I had slight doubts about what to use for [EMAIL PROTECTED] I used my normal email address. 1.. Type helo me and press ENTER. The output resembles the following: 250 OK

Re: [PHP] Command line php....

2003-08-09 Thread Ray Hunter
Technically, yes it should however, I think this is a bug...are you running php 5b? -- BigDog - Original Message - From: John Nichel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 9:07 PM Subject: [PHP] Command line php Can someone tell me why php waits

Re: [PHP] setting function variables

2003-08-09 Thread Micah Montoy
Tried this and it returns errors of type: Warning: Wrong parameter count for mssql_result() in c:\inetpub\wwwroot\webpage10\example\utilities\dsp_del_images.php on line 78 Warning: mssql_result(): supplied argument is not a valid MS SQL-result resource in

Re: [PHP] where did my errors go?

2003-08-09 Thread Curt Zirzow
* Thus wrote David T-G ([EMAIL PROTECTED]): What kind of call would suppress error messages from a require()d file? I don't know his codebase, and he's never seen anything like this before, @require $ENGINE_PATH/file-to-include.php ; Curt -- I used to think I was indecisive, but now I'm not

Re: [PHP] Question on class syntax

2003-08-09 Thread Robert Cummings
The :: operator is used to access a static class method. In other words you can use the class method without creating an instance of the class. Alternatively you could have used the following less effcient syntax: $cleaner = new htmlcleaner(); $value = $cleaner-cleanup( $value );

[PHP] RE: funcky parse error message due to { } or not sure what else might cause

2003-08-09 Thread Gronquist, Jim M
I added one term to a listing - if ( $follow_up == ) { $error=true; } and now I'm getting a parse error Ugh I can't see anything that is causing this. The script worked before. Any idea where I might start to debug? When

Re: [PHP] Is PHP cable of handling ASCII characters???

2003-08-09 Thread Curt Zirzow
* Thus wrote Scott Fletcher ([EMAIL PROTECTED]): Yea, receiving the data in a serial stream through cURL from someplace into an array() by using exec() function. PHP is in general can handle binary strings, now if cURL can handle it is a different story. Of course I'm stabbing in the dark at

[PHP] Page URL from a inc?

2003-08-09 Thread Jed R. Brubaker
I am having a bit of a problem with pathinfo. I am looking for a way to generate a URL from within an included class that would return the URL for the script that called the class. Pathinfo returns the class file. Is there a way to get what I need? Thanks in advanced, Jed R. Brubaker -- PHP

Re: [PHP] Is PHP cable of handling ASCII characters???

2003-08-09 Thread Scott Fletcher
I don't see how. The data when recevied is already in pieces through the exec() to PHP which convert the PHP variable into an array. Can not store the data into a file on the machine because it is illegal to do so. Jay Blanchard [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] [snip]

Re: [PHP] array method attributes (OO)

2003-08-09 Thread David Nicholson
Hello, This is a reply to an e-mail that you wrote on Fri, 8 Aug 2003 at 15:54, lines prefixed by '' were originally written by you. array $SESSION; near the beginning gives the error Parse error: parse error, unexpected T_ARRAY, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in

RE: [PHP] FDF support in RedHat

2003-08-09 Thread Jay Blanchard
[snip] I'm ready for step 2. =) [/snip] './configure' '--host=i686-pc-linux-gnu' '--build=i686-pc-linux-gnu' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share'

RE: [PHP] Mail

2003-08-09 Thread Mike Brum
Do you have an SMTP server installed on your machine? If not, add one to IIS (probably the simplest way to do it in Win2k). -M -Original Message- From: Sean [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 11:11 PM To: [EMAIL PROTECTED] Subject: [PHP] Mail I cannot get mail()

Re: [PHP] Passing Values between Pages : $_SESSION / $_GET

2003-08-09 Thread Pushpinder Singh Garcha
Hello again, I would appreciate if someone could help me out with this one. Thanks again --Pushpinder On Friday, August 8, 2003, at 11:46 AM, Pushpinder Singh Garcha wrote: Hello All, I am using php and mysql in my application which allows users to search/query a database. The database

Re: [PHP] Passing Values between Pages : $_SESSION / $_GET

2003-08-09 Thread Pushpinder Singh Garcha
Hello Jay , I am attaching snippet of the Form Code that displays the results of the first query meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head ? echo Hello ::: .$company.br; ? body bgcolor=aa leftmargin=14 topmargin=10 form name=form1 method=POST

Re: [PHP] Is PHP cable of handling ASCII characters???

2003-08-09 Thread Scott Fletcher
Yea, receiving the data in a serial stream through cURL from someplace into an array() by using exec() function. Jay Blanchard [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] [snip] Is PHP cable of handling the ASCII characters? Back then, I had no problem with it when there are

[PHP] Formatting an ascii characters in php?

2003-08-09 Thread Scott Fletcher
Hi! I use the cURL to send and receive data regardless of what data format is the data in. There are certian ascii characters in the data, like 'LF' for line feed, 'CR' for carriage return, etc. This time I came upon a problem where one of those ascii character caused PHP to get tripped up.

[PHP] Possible bug w/ open_basedir?

2003-08-09 Thread Dan Brown
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm running a Mitel SME Server v5.6, which is based on RedHat 7.3, on which I've upgraded PHP to version 4.3.2 (stock PHP version is 4.1.2). Since I upgraded to 4.3.2, I've encountered a recurring, but intermittent, problem with any of my

[PHP] hanmir!!

2003-08-09 Thread Chris W. Parker
hanmir!! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Can't change include_path in php.ini

2003-08-09 Thread Machiste' N. Quintana
Hi. I want to change the include_path of the php.ini. I tried uncommenting it, and changing the path, but everytime I use phpinfo() to check if it changed, it displays this as the include_path: .;c:\php4\pear And when it loads, it loads then reloads and reloads and etc. to give the effect of

Re: [PHP] FDF support in RedHat

2003-08-09 Thread Cesar Cordovez
Jay: Thanks for your help. I have only one question for you... Where is the PHP directory (where the php library files are) ... Cesar PD. How can you know if I have the sources for php in my machine? And where are they? Jay Blanchard wrote: 2. In the PHP directory (where the php library

Re: [PHP] Old version of PHP

2003-08-09 Thread Justin French
On Friday, August 8, 2003, at 09:21 AM, Dan Phiffer wrote: I'm working on an ongoing project that depends on a shared webserver running an old version of PHP (4.1.2 I believe). Is there any good reason to stick with an older version of PHP, or might it be a valid suggestion to have it

RE: [PHP] com obj from php

2003-08-09 Thread Jay Blanchard
[snip] Does anyone know if ti is possible or not to create a com object from php?? [/snip] Please refer to the manual at http://www.php.net/manual/en/faq.com.php for a start. Have a pleasant and magical day! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP] gzip to max 9

2003-08-09 Thread Decapode Azur
Dear All, ?php function wrl2wrz($buffer) { return gzencode ($buffer, 9); } ob_start(wrl2wrz); /* here the file */ ob_end_flush(); # end of the output buffering ? In this exemple with output beffering it is possible to select the maximum compression level, is it possible to select the

Re: [PHP] Problem occurs when included file includes anther file.

2003-08-09 Thread Nicholas Robinson
You can set the path(s) in php.ini Edit the file and search on 'include' HTH Nick On Friday 08 Aug 2003 6:38 am, CaiYongzhou wrote: The directory structure is as follows: / |-- demo.php |-- inc/ | |-- inc1.php |-- inc2.php === file demo.php == ?php require 'inc/inc1.php';

RE: [PHP] Best PHP CMS

2003-08-09 Thread Chris W. Parker
Matt Schroebel mailto:[EMAIL PROTECTED] on Tuesday, August 05, 2003 12:14 PM said: -Original Message- From: Anthony [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 9:52 AM To: [EMAIL PROTECTED] Subject: [PHP] Best PHP CMS [snip] Do us a favor and install Outlook

[PHP] www.php.net

2003-08-09 Thread Tom Miller
Clear Daywww.php.net has an error on the main page. Tom -- == -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] FDF support in RedHat (make error)

2003-08-09 Thread Jason Wong
On Saturday 09 August 2003 02:49, Cesar Cordovez wrote: Exactly! I agree with you 100%. That's why, even if you RTFM, google your question and search the archives, you need to ask some (very basic) questions to the list. Questions like: If the manual says fdftk.h is a header file, why it

RE: [PHP] magical file writing truncation

2003-08-09 Thread Jay Blanchard
[snip] okay, the first few lines of raw text are as follows... it's a chat log btw... Session Start (Yahoo! - fatcubanskate:the_lady_in_waiting1982): Thu Jul 10 21:23:42 2003 [21:23] the_lady_in_waiting1982: hey sexy!!! [21:24] fatcubanskate: hey sugar [21:24] fatcubanskate: how\'s thing? [21:25]

RE: [PHP] Is PHP cable of handling ASCII characters???

2003-08-09 Thread Jay Blanchard
[snip] Yea, receiving the data in a serial stream through cURL from someplace into an array() by using exec() function. [/snip] I would suggest receiving the data intact, explode into an array, and then go from there. That eliminates any serialization issue. -- PHP General Mailing List

[PHP] Problem in configuring freetds

2003-08-09 Thread Dipesh khacharia
Hi, I am Dipesh from BG Broadband, India. I am working on linux-php. I am trying to configure freetds with php, but it does not allow me to connect to mssql server 2000. The problem is not related to login. I can ping the server.Using command 'tsql' i can connect to the

Re: [PHP] php source code//php-imap/ php-devel ..etc

2003-08-09 Thread Jason Wong
On Saturday 09 August 2003 04:31, Nabil wrote: Please fix your clock, its too fast. When I dowload the source code of php and i compiled it in linux ... Does the full source code has everything i need , Depends on what your needs are! If you read the beginning of each (mostly each) chapter

Re: [PHP] Flash Actionscript List or Forum

2003-08-09 Thread Peter James
Not sure about a list, but this site has a boatload of tutorials and answered lots of questions that I had. http://actionscript.org/tutorials.shtml -- Peter James [EMAIL PROTECTED] php|architect The Magazine for PHP Professionals http://www.phparch.com - Original Message - From: Joe

[PHP] Table listing of months

2003-08-09 Thread Ashley M. Kirchner
I have the following snippet of code: ?php // contents of $monthlyarchivereverse is generated by a different // piece within a content managent system. The data, or format // can not be changed. $monthlyarchivereverse = array(/08/index.html August 2003,

RE: [PHP] Max script size

2003-08-09 Thread Jay Blanchard
[snip] I have a 6MB PHP script that just won't exe on the live server. It works on the local one. Any ideas on a setting that may limit the script. It is not timing out, it only takes about 3 sec to exe. [/snip] I'll take a SWAG at itare the PHP versions the same? Do the ini files have the

Re: [PHP] FDF support in RedHat

2003-08-09 Thread Jason Wong
On Friday 08 August 2003 23:12, Cesar Cordovez wrote: Now I have 4 versions: FDFTK.H, fdftk.h, FdfTk.h, Fdftk.h. Same problem. Where on earth did you get all those versions from? And did you follow the installation instructions in the manual -- in particular the bit about copying the header

[PHP] Imagick

2003-08-09 Thread Jacob Marble
Hello all- Does anyone here use Imagick in PHP? I've tried the example .php files using a miriad of version combinations and I always get this error: Fatal error: Call to undefined function: imagick_readimage() in /usr/local/lib/php/docs/imagick/examples/border.php on line 5 -- PHP

RE: [PHP] dev style guide

2003-08-09 Thread Miles Thompson
At 11:27 AM 8/6/2003 -0500, Jay Blanchard wrote: [snip] Just a remark but isn't it pointless to use Hungariannotation in a language that is by default typeless??? [/snip] We use it becuase we have a group of programmers, so the notation makes it easier for one in the group to understand the

RE: [PHP] trying to match the front and end...

2003-08-09 Thread Dan Joseph
Hi, Question: Where is this number coming from? Couldn't you just use a substr() based upon it's length and not deal with a regular expression? Its a bank account number coming from a database. We're reformatting it for ACH processing. The number could be: 23408234980423

[PHP] php source code//php-imap/ php-devel ..etc

2003-08-09 Thread Nabil
Hi all; When I dowload the source code of php and i compiled it in linux ... Does the full source code has everything i need , because when i serach the rmps i found many packeges like php-imap / php-mssql /php-devel / php-mysql / php-ldap /php-odbc... and if i want php to be compiled with gd ,,

Re: [PHP] where are my errors?

2003-08-09 Thread Curt Zirzow
* Thus wrote David T-G ([EMAIL PROTECTED]): John -- ...and then John W. Holmes said... % % David T-G wrote: % % My partner and I have done something that gets rid of our error messages, % and we're not quite sure what. The identical code base (I copied it over % myself; I'm sure)

RE: [PHP] Question on class syntax

2003-08-09 Thread Luis Lebron
Thanks for the information. I checked the manual but wasn't able to find it. Luis -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:35 PM To: Luis Lebron; Php-General (E-mail) Subject: Re: [PHP] Question on class syntax From: Luis

Re: [PHP] Simple cookie question

2003-08-09 Thread Jim Lucas
Assuming that you have a process page that stores the submitted choice, have the process page make the cookie setting and then redirect back to the first page. Or better yet, I like it when my original page never leaves and a popup window is openned to save my choice and then show me the results

RE: [PHP] Stop neurotic posting

2003-08-09 Thread Jay Blanchard
[snip] I love that I can shoot off a question while at work and get an answer quick. It's too bad that my novice questions annoy people, but I'm just learning, and that's WHY I joined this list. It's a resource, just like the manual. [/snip] Generally you present a well thought out question due

Re: [PHP] Simple cookie question

2003-08-09 Thread Mike Migurski
There are two ways round your problem... 1. Set your cookie right at the top of the script, so as your first line have something like: if(isset($_POST['vote'])){ setcookie(); } 2. Use output buffering, this will make PHP buffer all of your content and not send it till you tell it to (or

[PHP] Repopulating forms

2003-08-09 Thread Gerard L Petersen
Hi My code looks like this. ?PHP $test = gerard's name is \gerard\; echo $test.br; echo 'input type=text name=test2 value='.$test.'br'; ? form action=test2.php method=post input type=text name=foo value= / input type=submit name=sub value=submit /form When i run it the bit after the quotes

Re: [PHP] session bug or feature

2003-08-09 Thread Curt Zirzow
* Thus wrote Christian Calloway ([EMAIL PROTECTED]): register_global is currently on. The problem is, I am hacking into someone else's (awful awful) code, and if I turned off register_globals, the whole application would go kaput. I am not even using the old session_x functions, just the new

[PHP] Re: [ERR] DEAD MAILBOX

2003-08-09 Thread John Manko
arrg. [EMAIL PROTECTED] wrote: Transmit Report: To: [EMAIL PROTECTED], 402 Local User Inbox Full ([EMAIL PROTECTED]) Subject: Re: [PHP] Still can't pass variable through url From: John Manko [EMAIL PROTECTED] Date:

Re: [PHP] FDF support in RedHat

2003-08-09 Thread Cesar Cordovez
manual You must compile PHP with --with-fdftk[=DIR]. /manual Maybe for you, Jay, this is crystal clear, but for me, is like greek. =) I will ask again... how do you compile php with fdf support in red hat? Jay Blanchard wrote: [snip] the manual is so far away [/snip] The manual is right here,

[PHP] [Fwd: [ERR] Re: [PHP] Configuring PHP to use aspell]

2003-08-09 Thread daniel
how do we get this guy off the list Original Message Subject: [ERR] Re: [PHP] Configuring PHP to use aspell From: [EMAIL PROTECTED] Date: Sun, August 10, 2003 11:17 am To: [EMAIL PROTECTED] Transmit Report: To: [EMAIL PROTECTED], 402 Local User Inbox Full ([EMAIL PROTECTED])

[PHP] PHP5 class constants

2003-08-09 Thread Cristiano Duarte
This code: ? class Priority { const DEBUG = 0; const INFO = 1; const WARN = 2; const ERROR = 3; const FATAL = 4; const MAX_PRIORITY = FATAL; } class ExtendedPriority extends Priority { const REMOTE = Priority::MAX_PRIORITY + 1;

[PHP] How to point at a spot and get relevant information?

2003-08-09 Thread Yao, Minghua
Dear all, Anybody knows how to write a graphic plotting code such that when users point at that spot, they can get the information relevant to that spot? Thanks in advance. -MY -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Passing Values between Pages : $_SESSION / $_GET

2003-08-09 Thread Jay Blanchard
[snip] My question here is How do I get the name of the company that was passed to this script as a $_GET Parameter. I cannot use the $company because it is out of scope. [/snip] How about $_GET['company'] ? Or am I missing something? Have a pleasant day. -- PHP General Mailing List

[PHP] Re: Pls Help-Looking for PHP Product for Articles

2003-08-09 Thread Alexandru COSTIN
Hello, You could take a look at Komplete Lite - allows you to publish articles and associate forums on them. Even if the user roles are not very powerful in the open version - basically you will have what you want. http://www.interakt.ro/products/KompleteLite/

Re: [PHP] htmlspecialchars() and HTML code

2003-08-09 Thread John W. Holmes
Thaddeus J. Quintin wrote: CPT John W. Holmes wrote: --SNIP-- Try this: textarea name=textThis is lt;somegt; text/textarea If you submit that text and then print $_REQUEST['text'], you'll see that you have This is some text --SNIP-- Ok, but that only makes me realize the further

[PHP] hanmir.com

2003-08-09 Thread daniel
http://www.hanmir.com/ anyone know korean , we need to speak to the administrator of the server to turn this bloody annoying message off , i've never seen anything like this before how rude to send auto messages back -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] checking the return value of member function with empty

2003-08-09 Thread andu
On Sat, 09 Aug 2003 20:00:57 -0500 Edward Rudd [EMAIL PROTECTED] wrote: I am having this rather annoying syntax problem. I have this.. if (!empty($this-GetParam('someparameter')) { // OK do something since the parameter is set. } if (!empty($this-GetParam('someparameter'))) { // OK

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_tracking ORDER BY %s