[PHP-DB] xml, PHP, MYSQL

2005-04-05 Thread J. Connolly
I think i was dropped from the mailing list. So this message is twofold. My second part is... Is there a performance difference in returning a MySQL query in XML format? Is it a matter of preference whether the conversion takes place in php or mysql? I didn't even know mysql was capable of this

[PHP-DB] Object relational mapping in PHP

2005-04-05 Thread Hendy Irawan
Hi all... Would anyone be kind enough to provide me some pointers about object relationship mapping [libraries] in PHP? All I know is there are some DB APIs available: PEAR DB, MDB, ADOdb, Creole... I currently use MDB for its excellent DB schema management capabilities. And I use ORM manually,

[PHP-DB] How to Disable Daylight Savings Time on RedHat 9.0

2005-04-05 Thread dpgirago
We have created a MySQL/ C application that gathers environmental data and does inserts into the db once per minute. A set of PHP applications reads this data and does some graphical display of the values. Changing from Standard Time to Daylight Savings Time causes minor problems, but in the

[PHP-DB] number on the quene, or how to get rank?

2005-04-05 Thread emre
hi everyone, I' ve a table named as 'highscores', inserting result scores of a game and players name(each player can only play once) what I want to do is to get the current rank of a player over a listing of all rows ordered by scores desc. id -name - score 1 - userA - 8 2 - userB - 3 3 -

[PHP-DB] Exporting pictures to Excel

2005-04-05 Thread Perry, Matthew (Fire Marshal's Office)
I am having some difficulties exporting images to excel. I am using the following header: ?PHP header (Content-type: application/vnd.ms-excel); header (Content-Disposition: attachment ); ? Then I just create a table with my data. This works beautifully and generates the file correctly

Re: [PHP-DB] number on the quene, or how to get rank?

2005-04-05 Thread Philip Hallstrom
You could try something like this perhaps... SELECT score FROM highscores WHERE name = 'userD' then use the result of that to do this: SELECT COUNT(*) FROM highscores WHERE score 2 rank would then be the result of the above query plus one. -philip On Tue, 5 Apr 2005 [EMAIL PROTECTED] wrote: hi

[PHP-DB] GD Question

2005-04-05 Thread Craig Hoffman
Hello Everyone, I wrote a GD function that resizes some images and displays them as thumbnails. When I put the function in the index.php page I receive an error Warning: Headers have already been sent... then it shows a bunch of binary. I do not want re-save the file, I just want resize and

Re: [PHP-DB] GD Question

2005-04-05 Thread Philip Hallstrom
Probably nothing really. When it complains about headers already being sent is the line number the same as your header() line below? If so, that means you're outputting something back to the browser prior to that line. I'd make sure you don't have any white space before your initial opening

Re: [PHP-DB] GD Question

2005-04-05 Thread Craig Hoffman
The script works fine when I test it on a stand alone page. I'm just not sure how to include with the rest of the site. On Apr 5, 2005, at 1:17 PM, Philip Hallstrom wrote: Probably nothing really. When it complains about headers already being sent is the line number the same as your header()

Re: [PHP-DB] GD Question

2005-04-05 Thread Simon Rees
On Tuesday 05 April 2005 19:19, Craig Hoffman wrote: The script works fine when I test it on a stand alone page. I'm just not sure how to include with the rest of the site. You can't do it all from the same script (AFAIK). This is because of the way http/browsers work - each image is requested

Re: [PHP-DB] GD Question

2005-04-05 Thread Craig Hoffman
Thanks - it works perfectly! On Apr 5, 2005, at 1:33 PM, Simon Rees wrote: On Tuesday 05 April 2005 19:19, Craig Hoffman wrote: The script works fine when I test it on a stand alone page. I'm just not sure how to include with the rest of the site. You can't do it all from the same script (AFAIK).

Re: [PHP-DB] GD Question

2005-04-05 Thread Craig Hoffman
Hi Wendell, If its not too much trouble, I have one more question. How can I get GD to give me the correct image name and pass a variable to another page. So the image corresponds with the correct title in the DB. Does that make sense? Thanks again. Craig On Apr 5, 2005, at 1:41 PM, Wendell

Re: [PHP-DB] GD Question

2005-04-05 Thread Bastien Koert
img src=doimage.php?id=$some_id Bastien From: Craig Hoffman [EMAIL PROTECTED] To: Wendell Frohwein [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB] GD Question Date: Tue, 5 Apr 2005 14:10:50 -0500 Hi Wendell, If its not too much trouble, I have one more question. How can I get GD

[PHP-DB] Pre-Include File -- Global Include Pre/Post by filename

2005-04-05 Thread Peter Beckman
Back in 2000 I remember there being a file that could be created in the include path that, if existed, would be called and executed before any other PHP script was executed. There was also a script that if named correctly and put in the include path, would execute AFTER the called script was

Re: [PHP-DB] Pre-Include File -- Global Include Pre/Post by filename

2005-04-05 Thread Peter Beckman
Dear Peter -- Had you waited two more minutes to post (after looking for only a paltry 47 minutes), you would have found the auto_prepend_file and auto_append_file php.ini configuration directives which do what you want. Though it is a little difficult to find them on the PHP site, and Google

Re: [PHP-DB] Pre-Include File -- Global Include Pre/Post by filename

2005-04-05 Thread dpgirago
Peter, Perhaps you are referring to these directive in php.ini: ; Automatically add files before or after any PHP document. auto_prepend_file = auto_append_file = David Peter Beckman [EMAIL PROTECTED] 04/05/2005 03:39 PM To: PHP-DB Mailing List php-db@lists.php.net cc:

Re: [PHP-DB] How to Disable Daylight Savings Time on RedHat 9.0

2005-04-05 Thread dpgirago
We have created a MySQL/ C application that gathers environmental data and does inserts into the db once per minute. A set of PHP applications reads this data and does some graphical display of the values. Changing from Standard Time to Daylight Savings Time causes minor problems, but