Re: [PHP-WIN] Array Question

2007-08-17 Thread tg-php
I assume you're getting fields with the same name from pulling data from two or more tables. Something like "SELECT * FROM TABLE1, TABLE2 WHERE TABLE1.id = TABLE2.id" or something like that. At any rate, if you can.. it's always good to name the fields you want to pull instead of using "SELECT

Re: [PHP-WIN] ORDER BY is not sorting

2007-07-31 Thread tg-php
Spaces would affect sorting if the spaces appeared in the actual rowID data. If rowID is stored as text of some kind, then yeah, maybe he'd have an issue. But I have a feeling you're talking about the code itself and whether to put the quer into a variable or not (rebuting what I said). Here'

Re: [PHP-WIN] ORDER BY is not sorting

2007-07-31 Thread tg-php
I can't really see anything wrong with what you have there. It shouldn't matter that your SQL is inside the query function, although I like to build the query in a variable outside the query function, but either way it should work. And you're obviously getting data and not an error, right? Wha

Re: [PHP-WIN] photo gallery plugin

2007-07-26 Thread tg-php
Gallery2 and Coppermine are two big PHP photo gallery apps. http://gallery.menalto.com/ http://coppermine-gallery.net/index.php = = = Original message = = = Does anyone have a recommendation on a photo gallery plug in that works with php and mySQL. I have a car club and want to allow members

RE: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1'ANDfieldname2='fieldvalue2'

2007-05-22 Thread tg-php
`` shouldn't react the same as ''. If it does though, maybe try using them but putting your variables outside the quotes: $query = "SELECT `" . $field_name . "` FROM `classifieds` WHERE `" . $field_name1 ."` = '" . $field_value1 . "' AND `" . $field_name2 . "` ='" . $field_value2 . "'"; And

Re: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1'ANDfieldname2='fieldvalue2'

2007-05-22 Thread tg-php
Couple of things.. I'm not sure (and too lazy to look it up) if something like "category" is a reserved word, but you can try enclosing your field/table names in backticks (? whatever they're called.. the single quote looking character on the tilde) SELECT * FROM `classifieds` WHERE `trans_typ

Re: [PHP-WIN] PHP generated Excel Spreadsheets

2007-05-22 Thread tg-php
I don't see why you'd have compatibility issues with Excel 2007. In theory, Excel_Writer (which we've used where I work but it's been a while since I've messed with it) creates either 97 or 2000 style Excel spreadsheets, which should be importable into Excel 2007 with no problem. I've used the

Re: [PHP-WIN] Fw: COM surgery

2007-01-17 Thread tg-php
Ok, I see two main questions/problems.. 1. An example of COM with Excel 2. How do you use COM with Word to set font size 20 and centered text? Keep in mind that there may be better ways to solve the problems you have, but for the time being we'll use this as an excuse to play with COM. #1 - T

Re: [PHP-WIN] Fw: COM surgery

2007-01-16 Thread tg-php
There's thousands of things you can access via COM. Windows uses it extensively. Every application in Microsoft Office uses COM. I've used COM between Excel and MapPoint to generate maps (and yeah, I created a PHP script to access MapPoint directly.. but it was just easier to do it via Excel)

Re: [PHP-WIN] php installed on IIS: changes to php.ini not taking affect

2007-01-11 Thread tg-php
Try checking out phpinfo() when it works and compare that to what's in your php.ini and look for the differences. Maybe some option or extension or something you're trying to run is exploding. Maybe print out the successful phpinfo() and your php.ini that's causing the trouble and go over both

Re: [PHP-WIN] php installed on IIS: changes to php.ini not taking affect

2007-01-10 Thread tg-php
Could be a permissions issue with reading the new php.ini file you created. On this page, it tells you how to figure out what user your IIS is executing as: http://www.php.net/manual/en/install.windows.iis.php " 1. In IIS Admin, go to Application Pools 2. Right click on the pool your site is runn

Re: [PHP-WIN] php installed on IIS: changes to php.ini not taking affect

2007-01-10 Thread tg-php
I had a similar issue a couple years ago when I was running Apache/PHP on a Windows box at a previous job. The information below helped. Check all the locations (regardless of what PHP is reporting it's using for php.ini's path). Try making some simple change that will show up on phpinfo().

Re: [PHP-WIN] Problem with removable media

2006-11-15 Thread tg-php
Styve, Here's a block of code I borrowed (see comment block) and use to scan active drives on a Windows PC. It uses the is_dir() which may still not work for you, but maybe it does it differently than you did. Also, I believe you can access Windows API functions that can return the status of

RE: [PHP-WIN] @mssql_connect() versus mssql_connect()

2006-10-13 Thread tg-php
As mentioned, the @ suppresses any errors, warnings, notices, etc that the command will give. This is typically considered really bad programming practice. If you resort to using an @ to suppress, one of two things is an issue: 1. Either error reporting is set to high and you're getting warnin

Re: [PHP-WIN] Cam control

2006-04-18 Thread tg-php
There's probably libraries out there for dealing with serial and parallel operations with PHP and I'm sure someone will point one out. In the meantime and maybe as an addition to it, you might check out Winbinder (http://www.winbinder.com) it's a native Windows API interface for PHP that's ju

[PHP-WIN] Re: [PHP] PDF printing under windows.

2005-10-25 Thread tg-php
This is really dumb and overly simple, which is probably why it was missed/not brought up, but it just occurred to me that, assuming you have a browser-based interface to your app, why don't you just send the PDF to the browser for printing? Then it should use the Acrobat Reader plugin to open

[PHP-WIN] Re: [PHP] PDF printing under windows.

2005-10-25 Thread tg-php
David.. I think I accidentally deleted your last message, but I believe you said something about Acrobat not closing after it gets done printing. Here are a few thoughts: 1. If you right click on something and select "print" and it performs the command line action listed in the registry as men

[PHP-WIN] Re: [PHP] PDF printing under windows.

2005-10-25 Thread tg-php
Two (and a half) things: 1. Even though DOS/Windows machines don't have, specifically, /dev/printer or /dev/lpr or whatever the *nix specific is, it does have a LPTx: device According to the page listed below, it may be possible to do: copy /b filename LPTx The /b indicates it's a binary file.

Re: [PHP-WIN] Is this a PHP bug?

2005-10-17 Thread tg-php
Thanks for the vote of confidence, Ross. hah. *shrug* At any rate, I was wrong about one thing. Mis-remembered something about converting a string to a int. It doesn't pull all numbers out of the string, it only pulls leading numbers. $address = "123 Main St Apt 45"; echo intval($address);

[PHP-WIN] Re: [PHP] Removing Items from an Array

2005-10-13 Thread tg-php
Thanks for the addition Jochem.. one reason I post here, even if it's a basic example, is because if there's a better way or a chance to learn something new, I want to have that opportunity. Thanks again! -TG = = = Original message = = = Id like to continue where TG left off ... hth. [EMAI

[PHP-WIN] Re: [PHP] Re: Storing CCN's Again...

2005-02-09 Thread tg-php
Yeah, Richard's got it exactly right. Companies like Amazon NEED to have a million precautions in place because it's not just the possible money lost to their customers, but the excessive amounts of BUSINESS lost (and trust in Amazon as a reliable and secure financial institution). One inciden

Re: [PHP-WIN] outlook calendar

2005-02-07 Thread tg-php
You know, I forgot but I think that depending on the version of Outlook, you might have to replace the "outlook.application" with something else. Maybe not.. hmm.. I can't find any examples where something other than 'outlook.application' is used. Maybe I'm wrong there. At any rate, I'd check

Re: [PHP-WIN] outlook calendar

2005-02-07 Thread tg-php
= = = Original message = = = > Good morning, > > Is it possible to reach the data of the outlook calendar (on a server > exchange) with php? > > Thank you for advance I've never tried using PHP to connect to an Exchange server directly, but I've done some stuff with using PHP to connect via CO

Re: [PHP-WIN] From Browser to Print - ?????

2005-01-27 Thread tg-php
Check into maybe using CSS2 page breaks. I don't see any way to make PHP do it, but CSS2 has facilities for that. Try this: Requires IE 5.5 if I remember right. -TG = = = Original message = = = I have some PHP scripts that put output to the browser. I can then print them. However, I want

Re: [PHP-WIN] Re: PHP MS-DOS

2005-01-26 Thread tg-php
I think people get confused when they talk about "Windows apps" and such. I'm not sure that I can clarify things that much, but I wanted to point out some stuff that might help people understand a little better. Please, anyone who has more intimate knowledge of this, feel free to correct me or

Re: [PHP-WIN] Re: SpreadSheet_Excel_Writer PEAR package

2005-01-19 Thread tg-php
First, I have to admit that I don't have any experience with PEAR's Excel Writer, but I have quite a bit of Excel experience (including Excel+VBA so I got some experience with the internal workings via code). foreground color should be for the text and/or pattern color. bgcolor should be for t

[PHP-WIN] RE: [PHP] php editor

2005-01-13 Thread tg-php
It's true that googling would produce a list of PHP-happy editors, but the intended question seems to be more along the lines of "What does everyone like? Use? Prefer?" That's not something that's always found on lists you'd get off of google. Helpful responses aren't always ones that are t

RE: AW: [PHP-WIN] Word COM Object

2005-01-07 Thread tg-php
No prob, hope it helps. Usually, if Word or whatever application you're working with knows how to do something then usually you can work it backwards (start with the finished product and trace it back a little) to figure out how they do it or what standard they use get the job done. Sometimes

RE: AW: [PHP-WIN] Word COM Object

2005-01-07 Thread tg-php
Creating a new document in Word, inserting Page Breaks then saving it as a web page revealed that Word seems to use CSS tags to show the line breaks in HTML. The only odditiy I see is that when I load the HTML back into Word, mine is still set to "View -> Web Page Layout" or something (Word 2003

Re: [PHP-WIN] Substr function

2004-12-13 Thread tg-php
In addition to substr() and explode() already mentioned, check out some of these: basename() - Returns filename component of path http://us2.php.net/manual/en/function.basename.php strrpos() - Find position of last occurrence of a char in a string http://us2.php.net/manual/en/function.strrpos.ph