I have had 40+ virused emails to the address I use for this list. Possible
they came from another source but this is the most likely.
Curious - I've not seen any, so it must be someone
harvesting rather than using the list? Lets see if my
posting brings some actions ;)
Please check your virus
I upgraded my server to RedHat 9 and the problem was solved.
Thanks
Emery
- Original Message -
From: Micah Stevens [EMAIL PROTECTED]
To: PHP-DB List [EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 22:32
Subject: Re: [PHP-DB] Queries probably timing out
IF it's a linux server
I saw it, at first I didn't think it would work but it's great - just what
I need. I guess I was just surprised that there isn't an easier way to do
this in PHP by switching from the default. I also like to write my own code
rather than use someone else's, since it's the best way to learn, but
I've just done a search on goolge for this, and found several products
that do it, but I'm convinced there's gotta be an open source option?
Anyone able to point me in the right direction with this?
*
The information contained
have you tried saving the data as a set of comma separated values (CSV
file)?
Microsoft Excel can open/import these files.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 4:58 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Saving
you can also send the appropraite headers to output directly to excel from the
browser, i.e something like this:-
? if($_GET['FORMAT'] == 'XLS'){
header(Content-Type: application/vnd.ms-excel);
header(Content-Disposition: inline; filename=\file.xls\);
}
?
this needs to be at the very start of
if you're looking for a little more control over your documents, i'd try
this class. Its based on the WriteExcel Perl Module. Perl class docs can
be found
here---http://search.cpan.org/author/JMCNAMARA/Spreadsheet-WriteExcel-0.41/WriteExcel.pm.
I've found _very_ few things for my needs that
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
OK, I'll apologize in advance if this is a little off topic, but I think
it'll be close enough.
I have a form (searchform.php) that collects data for a search (e.g.,
firstname, lastname). That form submits to a separate PHP script
http://www.beamhost.co.uk/hosting.html
I'm moving hosts with our site at work...
I found these guys and am very impressed.
Has anyone had any dealings with them? Know if they are any good?
Tris...
*
The information contained
I would advise making your search.php a function. This offers a lot
of other flexibility.
On your searchform.php page just have an if() function to determine if
any search parameters were passed. If there are parameters, perform the
search. If there are results, display them, otherwise display
First FreeTDS should have built support for TDS protocol version 8.0.
The tds protocol version should also be set to 8.0 in interface file.
Details about this is included with the FreeTDS source distribution.
-- bob
On Mon, 18 Aug 2003, vish.kohli wrote:
Thanks for your response.
My script is
I've solved the immediate problem by doing another temp query to make the
big table smaller - first doing the WHERE clause and the CONCAT to cut down
the work on the second temp query.
Thanks for all the suggestions.
However, while setting PHP/MySQL/Apache up on my computer to try solve this
It tells PHP which way to format various locale specific functions. (date
stuff, money stuff, etc..)
-Micah
On Wednesday 20 August 2003 2:23 am, Lisi wrote:
I saw it, at first I didn't think it would work but it's great - just what
I need. I guess I was just surprised that there isn't an
See the attached file for details
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 1:24 PM
Subject: [PHP-DB] Host check?
http://www.beamhost.co.uk/hosting.html
I'm moving hosts with our site at work...
I found these guys and am very impressed.
Has anyone had any
Hi All,
I've been working on a database with a web interface for the past few
years in my spare time, and as you can guess, I haven't had much time
lately, and they people I'm doing this for would like to get it
wrapped up if possible.
I'm looking for someone to help me understand/write PHP
Hello,
On 08/20/2003 03:23 PM, John Stoffel wrote:
I've been working on a database with a web interface for the past few
years in my spare time, and as you can guess, I haven't had much time
lately, and they people I'm doing this for would like to get it
wrapped up if possible.
You may want to
Hi,
In a small part of my database I have two tables as follows:
# -- MySQL dump --
#
# Table structure for table 'WMS_Data'
#
CREATE TABLE WMS_Data (
Data_ID int(11) DEFAULT '' NOT NULL auto_increment,
Booking_ID int(11) DEFAULT '0' NOT NULL ,
Data_Field_1 varchar(100) ,
I have a script that is going into semi-production and during this
process a new problem was uncovered. I have the table a couple of table
fields setup as Not NULL with a Default value. The problem is that if
the user fails to select anything I get garbage in one of the fields and
could any body hlep me in this.
how to run a shell script with suexec in php.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is it easy?? Is it possible?? Should I just run 2 different queries and
output their results in the PHP script and make it look like it's all from
the same table
I cant grasp JOIN for the life of me
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
select t1.name,t2.salary from personal t1,sal t2
where t1.id=t2.id;
- Original Message -
From: John Ryan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 4:41 PM
Subject: [PHP-DB] SELECT FROM 2 or more tables
Is it easy?? Is it possible?? Should I just run 2
John,
It sounds like you need to read basic documentation on combining SQL queries.
Basically, you need to have a column that is common across both tables.
Eg., in TABLE1 have a column named TABLE1ID. Have the same ID cross referenced in TABLE2.
The ID would be sequenced in some way
A join merges every record in one table with every record in another
table, which is something you rarely want to do. So you want to set a
filter on the merged records, which can be anything, but is usually a
match between a field in one table and a field in another table.
That's a join in two
No, he meant rarely want to join entire tables without a cross referencing ID column.
That's definitely something you wouldn't want to do very often. It's impractical and
extremely inefficient.
Ben Lake wrote:
Rarely want to do joins? That's a new one.
Ben
-Original Message-
From:
Hehe, ok, that was bad there for a second :)
Ben
-Original Message-
From: Brian Dailey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 3:24 PM
To: Ben Lake; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] SELECT FROM 2 or more tables
No, he meant rarely want to join entire tables
Hi,
I have to manage a large amount of images uploaded by users on my site.
Using php/mysql I don't know if I should store the images in a directory
within the server or in a dedicated table.
What is the most suited method?
Thanks, best regards.
--
PHP Database Mailing List
Hi there,
Why not do both? Store the images themselves in a dir, but reference them
from a table, so that way you can control them pretty much totally via PHP
and MySQL. You could them write a system to create thumbnails from selected
items in the database or delete certain images etc .
I store alot in databases.. when you deal with filesystem there can be
issues with multiple webservers (need replication using something like
rsync, etc).. I've used the db/filesystem link method before aswell but
typically go with database nowdays..
You do have to query each time to get
Hi there everyone,
I am storing images in the filesystem and in a MySQL DB, my question is, I know when
you upload the images you can do the image width, height etc .. from the image, is
it possible to also do a pixel count and image color depth?
Any help would be REALLY appreciated :-)
Hello, I installed MMCache on one of our boxes here and did a few timing
tests. I have to say I'm very unimpressed given the hype and the benchmarks
on their servers. Am I missing something? (and yes, phpinfo() shows the
module is loaded). I was the only person hitting the pages on this test box.
You could use sudo and add 'apache' as a user who can run 'mount'...
Add this to /etc/sudoers:
apache ALL=NOPASSWD: /bin/mount
Daevid Vincent
http://daevid.com
-Original Message-
From: pete M [mailto:[EMAIL PROTECTED]
Sent: Friday, August 15, 2003 4:59 AM
To:
Hello,
On 08/20/2003 09:10 PM, Daevid Vincent wrote:
Hello, I installed MMCache on one of our boxes here and did a few timing
tests. I have to say I'm very unimpressed given the hype and the benchmarks
on their servers. Am I missing something? (and yes, phpinfo() shows the
module is loaded). I
The pages are very mySQL intensive. No classes used. Many includes though.
-Original Message-
From: Manuel Lemos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 5:44 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: MMCache Benchmarks don't show much improvement?
Hello,
On 08/20/2003 10:06 PM, Daevid Vincent wrote:
The pages are very mySQL intensive. No classes used. Many includes though.
That explains it. No PHP cache will make your database execute the
queries faster. Your scripts will be most of the time waiting for the
database to respond.
What you
Hi,
quoted from 'function.odbc-connect.php'.Perhaps it might helps:
--
cs at coolspot dot de
10-Jul-2001 08:01
We've tried hard to connect from php to our IBM DB2 RS/6000 Server. It
worked after we compiled with --ibm-db2= option, but it was unbelievable
slow.
Unfortunately it doesn't really work... It depends on what ODBC they
happen to be running -
http://www.phpbuilder.com/mail/php-db/2001071/0395.php
Thierry B. wrote:
Hi,
quoted from 'function.odbc-connect.php'.Perhaps it might helps:
--
cs at coolspot dot
ive heard that before, and its in the mysql manual, to have something like
WHERE table1.id = table2.id
But does make any sense to me.
What Im doing is providing a search form for customers that allows them to
search each individual table for content or all tables. all tables have a
common field,
hi,
i try
$serdb=LOCALMACHINE; #the name of the SQL Server
$dbdb=dbname; #the name of the database
$userdb=userdb; #a valid username
$passdb=passdb; #a password for the username
# one line
$con=odbc_connect(Driver={SQL
Server};Server=.$serdb.;Database=.$dbdb,$userdb,$passdb)or die(
connessione
39 matches
Mail list logo