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
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'
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
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
`` 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
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
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
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
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)
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
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
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().
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
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
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
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
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
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.
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);
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
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
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
= = = 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
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
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
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
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
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
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
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
30 matches
Mail list logo