RE: [PHP-DB] Find out a pic size?

2002-11-11 Thread Snijders, Mark
check this out:

http://www.php.net/manual/en/ref.image.php


you need de GD limbrary you can check with phpinfo() if you already got
it


good luck



___ 

Mark Snijders, Developer 
Atos Origin 
Groenewoudeseweg 1, Room VN-515 
5621 BA  Eindhoven, The Netherlands 
*   : [EMAIL PROTECTED] 
*:+31 (0)40 - 2785992 (tel) 
* : +31 (0)40 - 2788729 (fax) 

The information in this mail is intended only for use of the individual or
entity to which it is addressed and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
Access to this mail by anyone else than the addressee is unauthorized. If
you are not the intended recipient, any disclosure, copying, distribution or
any action taken omitted to be taken in reliance of it, is prohibited and
may be unlawful.



-Original Message-
From: [EMAIL PROTECTED] [mailto:joakim.andersson;cybercom.se]
Sent: maandag 11 november 2002 8:56
To: [EMAIL PROTECTED]
Subject: SV: [PHP-DB] Find out a pic size?


 Hi, 
  
 I'm working with a lot of picture in a website and the size is not
 always the same.
  
 I need some help on how to find out the size (width and height) of a
 picture. Is there any way to do this (especially with PHP)? 
  
 I need it so I can calculate the width and height to be 
 specified on the
 HTML img tag.
  
 Thanks,
  
 Hansen
 IndoInformatika

Did you try the manual at all?
GetImageSize() is what you're looking for.

Regards
Joakim

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




SV: [PHP-DB] Find out a pic size?

2002-11-11 Thread joakim . andersson
 -Ursprungligt meddelande-
 Från: Snijders, Mark [mailto:Mark.Snijders;atosorigin.com]
 Skickat: måndag den 11 november 2002 09:03
 Till: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
 Ämne: RE: [PHP-DB] Find out a pic size?
 
 
 check this out:
 
 http://www.php.net/manual/en/ref.image.php
 
 
 you need de GD limbrary you can check with phpinfo() if 
 you already got
 it
 
 
 good luck

getimagesize(), which is the function he needs, does actually work without
GD.

Joakim

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] php array max value pr. year

2002-11-11 Thread Martin Allan Jensen
Hi evryonei have a problem that i hope you can help me with.

Here it goes!

I have two arrays one called y adn one called v 
Togeather they hold a year(Y) and a value(V)

The array looks like this:

v:
10
20
40
60
320
780
890
920

y:
2002
2002
2002
2002
2002
2003
2003
2003

-

V represents a climping value
Y represents the year of the value


So  the values 10, 20, 40, 60, 320 etc. grows until a new year is reachet. And then it 
schould start again in the new year.
So MAXIMUM ONE VALUE PER YEAR

How can i make it return this out of the earlier menchent array :

(Arrays)
Y:
2002
2003

V:
320
920

So much thanks peoplei tried now for two days and i just can't come up with 
anything...

P.S. Sorry for my bad english!

Martin Allan Jensen


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] MySql limits - WAS [PHP-DB] ROugh idea of speed

2002-11-11 Thread Peter Lovatt
Hi

I am interested in the limits of MySql.

I have a site which is growing. The biggest tables are currently about 750K
but this will grow to the 3-10M record mark over the next 6 months. The
databases are well designed and are currently running smoothly on 2x1GHz
PIII and 512MB RAM.

I am planning and specifying hardware for the next phase of growth and had
assumed MySql would handle this size of table comfortably. What are the
problems to look out for?

Is it tables that have heavy write use that are prone to problems or are
read only tables a problem too?

The site has an abstraction layer so moving databases is not out of the
question, but would involve work and expense not currently budgeted for.

I am a moderately skilled DBA and we have the budget for hardware. I don't
anticipate going beyond 10M records and would rather stick with MySql unless
we are heading for big trouble.

Thoughts and advice appreciated


Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] php array max value pr. year

2002-11-11 Thread Jason Wong
On Monday 11 November 2002 17:24, Martin Allan Jensen wrote:
 Hi evryonei have a problem that i hope you can help me with.

 Here it goes!

 I have two arrays one called y adn one called v
 Togeather they hold a year(Y) and a value(V)

 The array looks like this:

Can I ask, how you did get these arrays? Did you define these or did come from 
somewhere else?  And why are they in two separate arrays? ...

 v:
 10
 20
 40
 60
 320
 780
 890
 920

 y:
 2002
 2002
 2002
 2002
 2002
 2003
 2003
 2003

 -

... In most cases you're better off using a single array to hold both pieces 
of information.

 V represents a climping value
 Y represents the year of the value
 

 So  the values 10, 20, 40, 60, 320 etc. grows until a new year is reachet.
 And then it schould start again in the new year. So MAXIMUM ONE VALUE PER
 YEAR

Right, do you actually do anything with the non-maximum values? Are they used 
anywhere in your code, or do you really just want the maximum value for each 
year?

 How can i make it return this out of the earlier menchent array :

 (Arrays)
 Y:
 2002
 2003

 V:
 320
 920

There may be an easy way to solve your problem, but first you need to:

1) explain why you're using 2 arrays
2) state whether the non-maximum values are used at all, if they are being 
used, /how/ are they being used.

-- 
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *


/*
You have literary talent that you should take pains to develop.
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] php array max value pr. year

2002-11-11 Thread Ignatius Reilly
Hi Martin,

I am sure that many would love to help you, but really you must explain your
problem more clearly! Can you give more details?

Ignatius

- Original Message -
From: Martin Allan Jensen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 11, 2002 10:24 AM
Subject: [PHP-DB] php array max value pr. year


Hi evryonei have a problem that i hope you can help me with.

Here it goes!

I have two arrays one called y adn one called v
Togeather they hold a year(Y) and a value(V)

The array looks like this:

v:
10
20
40
60
320
780
890
920

y:
2002
2002
2002
2002
2002
2003
2003
2003

-

V represents a climping value
Y represents the year of the value


So  the values 10, 20, 40, 60, 320 etc. grows until a new year is reachet.
And then it schould start again in the new year.
So MAXIMUM ONE VALUE PER YEAR

How can i make it return this out of the earlier menchent array :

(Arrays)
Y:
2002
2003

V:
320
920

So much thanks peoplei tried now for two days and i just can't come up
with anything...

P.S. Sorry for my bad english!

Martin Allan Jensen


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Are there any Oracle vs Postgresql official benchmarks

2002-11-11 Thread Manos Papagelis
Hello to all,

I have searched enough to find some official benchmarks about oracle and
postgresql but it seems that don't exist any (mostly because oracle license
don't permit it). If someone has something in mind it would be very helpful
to keep me informed.
I am stressly interested about official performance benchamarks of Oracle
9.1 vs Postgresql 7.2.*, however any older benchmark that can give a sense
is welcomed.

thanx in advance,

- Manos Papagelis



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks

2002-11-11 Thread Maxim Maletsky

I can already say that Oracle is faster. But official benchmark I have
never seen. Have you wondered aboout ACID test results for both?


--
Maxim Maletsky
[EMAIL PROTECTED]



Manos Papagelis [EMAIL PROTECTED] wrote... :

 Hello to all,
 
 I have searched enough to find some official benchmarks about oracle and
 postgresql but it seems that don't exist any (mostly because oracle license
 don't permit it). If someone has something in mind it would be very helpful
 to keep me informed.
 I am stressly interested about official performance benchamarks of Oracle
 9.1 vs Postgresql 7.2.*, however any older benchmark that can give a sense
 is welcomed.
 
 thanx in advance,
 
 - Manos Papagelis
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks

2002-11-11 Thread Manos Papagelis
Any kind of results are precious although I would prefer some official
benchmarks.
If I can give a hint I would say that I am mostly interested to Object
features of both and how well they do when transitive closure queries are
concerned (queries that combine many tables and relations - extended use of
unions etc...).
That's because of path expressions used in my queries. (e.g. where is
something that someone has created that has create something else and is
also find somwhere else ...blah blah blah)

- Manos Papagelis

Maxim Maletsky [EMAIL PROTECTED] wrote in message
news:2002134207.1DAE.MAXIM;php.net...

 I can already say that Oracle is faster. But official benchmark I have
 never seen. Have you wondered aboout ACID test results for both?


 --
 Maxim Maletsky
 [EMAIL PROTECTED]



 Manos Papagelis [EMAIL PROTECTED] wrote... :

  Hello to all,
 
  I have searched enough to find some official benchmarks about oracle and
  postgresql but it seems that don't exist any (mostly because oracle
license
  don't permit it). If someone has something in mind it would be very
helpful
  to keep me informed.
  I am stressly interested about official performance benchamarks of
Oracle
  9.1 vs Postgresql 7.2.*, however any older benchmark that can give a
sense
  is welcomed.
 
  thanx in advance,
 
  - Manos Papagelis
 
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] arrays db

2002-11-11 Thread Martin Allan Jensen
Okey people, i try again!!

I have a table in a mysql database that holds this:
+++++--+
| id | maaler | aflaest| vaerdi | pris |
+++++--+
| 21 | 11 | 2002-01-01 |  15160 | 0.00 |
| 22 | 11 | 2002-02-01 |  15180 | 0.00 |
| 23 | 11 | 2002-03-01 |  15200 | 0.00 |
| 24 | 11 | 2002-04-01 |  15240 | 0.00 |
| 25 | 11 | 2002-05-01 |  15250 | 0.00 |
| 27 | 10 | 2002-11-14 |210 | 0.00 |
| 30 | 10 | 2002-12-19 |230 | 0.00 |
+++++--+

Each maaler have it's own start registration witch is:
++--+---+
| id | nummer   | start |
++--+---+
| 10 | 56456|   200 |
| 11 | 02   | 15150 |
++--+---+

I then made a script that takes start for each maaler if it have any 
registrations. Then it does this:
if its first field then it takes the vaerdi(THE VALUE) and - it with the start 
(THE STARTREGISTRATION) For the next fields it takes the vaerdi - the last vaerdi. 
My problem is that after the script has ran it have lets say 20 yeas 2002 (the 
registration year called aflaest in the table) and lets say two 2003. I only need 
ONE value vaerdi per year, witch is the one it just calculated in a loop. But it 
have all the values and years in the array. How do i only take ONE value per year in 
PHP NOT SQL??

I really hope this is discriping enough!!

THANKS ALL!


Martin Allan Jensen



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] arrays db

2002-11-11 Thread Ignatius Reilly
Why don't you want to do this with SQL?

Ignatius

- Original Message -
From: Martin Allan Jensen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 11, 2002 2:48 PM
Subject: [PHP-DB] arrays  db


Okey people, i try again!!

I have a table in a mysql database that holds this:
+++++--+
| id | maaler | aflaest| vaerdi | pris |
+++++--+
| 21 | 11 | 2002-01-01 |  15160 | 0.00 |
| 22 | 11 | 2002-02-01 |  15180 | 0.00 |
| 23 | 11 | 2002-03-01 |  15200 | 0.00 |
| 24 | 11 | 2002-04-01 |  15240 | 0.00 |
| 25 | 11 | 2002-05-01 |  15250 | 0.00 |
| 27 | 10 | 2002-11-14 |210 | 0.00 |
| 30 | 10 | 2002-12-19 |230 | 0.00 |
+++++--+

Each maaler have it's own start registration witch is:
++--+---+
| id | nummer   | start |
++--+---+
| 10 | 56456|   200 |
| 11 | 02   | 15150 |
++--+---+

I then made a script that takes start for each maaler if it have any
registrations. Then it does this:
if its first field then it takes the vaerdi(THE VALUE) and - it with the
start (THE STARTREGISTRATION) For the next fields it takes the vaerdi -
the last vaerdi. My problem is that after the script has ran it have lets
say 20 yeas 2002 (the registration year called aflaest in the table) and
lets say two 2003. I only need ONE value vaerdi per year, witch is the one
it just calculated in a loop. But it have all the values and years in the
array. How do i only take ONE value per year in PHP NOT SQL??

I really hope this is discriping enough!!

THANKS ALL!


Martin Allan Jensen



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks

2002-11-11 Thread Maxim Maletsky
I don't think these two are very comparable. True, PgSQL is getting
closer and closer to Oracle, but Oracle is still ahead, especially in
how it handles objects, PL/SQL and relational logic.

But, doesn't it matter to you whether you have to pay the license or
not? pgSQL is an Open Source, Oracle is a lot of money... So, if there
are no budget problems (means you spend no cent extra) go for Oracle,
otherwise choose pgSQL as it is also very powerfull.


--
Maxim Maletsky
[EMAIL PROTECTED]



Manos Papagelis [EMAIL PROTECTED] wrote... :

 Any kind of results are precious although I would prefer some official
 benchmarks.
 If I can give a hint I would say that I am mostly interested to Object
 features of both and how well they do when transitive closure queries are
 concerned (queries that combine many tables and relations - extended use of
 unions etc...).
 That's because of path expressions used in my queries. (e.g. where is
 something that someone has created that has create something else and is
 also find somwhere else ...blah blah blah)
 
 - Manos Papagelis
 
 Maxim Maletsky [EMAIL PROTECTED] wrote in message
 news:2002134207.1DAE.MAXIM;php.net...
 
  I can already say that Oracle is faster. But official benchmark I have
  never seen. Have you wondered aboout ACID test results for both?
 
 
  --
  Maxim Maletsky
  [EMAIL PROTECTED]
 
 
 
  Manos Papagelis [EMAIL PROTECTED] wrote... :
 
   Hello to all,
  
   I have searched enough to find some official benchmarks about oracle and
   postgresql but it seems that don't exist any (mostly because oracle
 license
   don't permit it). If someone has something in mind it would be very
 helpful
   to keep me informed.
   I am stressly interested about official performance benchamarks of
 Oracle
   9.1 vs Postgresql 7.2.*, however any older benchmark that can give a
 sense
   is welcomed.
  
   thanx in advance,
  
   - Manos Papagelis
  
  
  
   --
   PHP Database Mailing List (http://www.php.net/)
   To unsubscribe, visit: http://www.php.net/unsub.php
  
 
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Pgsql Vs. Mysql

2002-11-11 Thread Leif K-Brooks
Sorry for the off-topic post, but it would be highly annoying to have to 
subscribe to a new mailing list for just one topic.

I'm currently using mysql, but I'm considering switching to pgsql.  I'm
wondering which is better.  Also, how hard would Pgsql be to install?
 Php seems to have pgsql support, but there's currently no pgsql server.

--
The above message is encrypted with double rot13 encoding.  Any 
unauthorized attempt to decrypt it will be prosecuted to the full extent 
of the law.




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Pgsql Vs. Mysql

2002-11-11 Thread bbonkosk
Have you tried checking out the archives?  I think this one would have a 
million plus one hits.  Also has been discussed on Slashdot, as well as other 
forums.

As far as difficulty to install, try it out.  I would say it it relative as 
I'm sure a linux expert would say it is simple, whereas a linux newbie may say 
it is tough, I know there is plenty of excellent documentation out there.

PHP has support for most everything you could want to do with pgsql.  
-Brad

 Sorry for the off-topic post, but it would be highly annoying to have to 
 subscribe to a new mailing list for just one topic.
 
 I'm currently using mysql, but I'm considering switching to pgsql.  I'm
 wondering which is better.  Also, how hard would Pgsql be to install?
   Php seems to have pgsql support, but there's currently no pgsql server.
 
 -- 
 The above message is encrypted with double rot13 encoding.  Any 
 unauthorized attempt to decrypt it will be prosecuted to the full extent 
 of the law.
 
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks

2002-11-11 Thread Peter Beckman
EWeek compared MySQL to Oracle 9i and a few others, and they both came out
on top.

http://www.eweek.com/article2/0,3959,293,00.asp
http://www.eweek.com/slideshow/0,3670,p=1s=1590a=23120po=1i=1,00.asp
http://www.eweek.com/slideshow/0,3670,p=1s=1590a=23120po=2i=1,00.asp

On Mon, 11 Nov 2002, Maxim Maletsky wrote:


 I can already say that Oracle is faster. But official benchmark I have
 never seen. Have you wondered aboout ACID test results for both?


 --
 Maxim Maletsky
 [EMAIL PROTECTED]



 Manos Papagelis [EMAIL PROTECTED] wrote... :

  Hello to all,
 
  I have searched enough to find some official benchmarks about oracle and
  postgresql but it seems that don't exist any (mostly because oracle license
  don't permit it). If someone has something in mind it would be very helpful
  to keep me informed.
  I am stressly interested about official performance benchamarks of Oracle
  9.1 vs Postgresql 7.2.*, however any older benchmark that can give a sense
  is welcomed.
 
  thanx in advance,
 
  - Manos Papagelis
 
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 


 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php


---
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED] http://www.purplecow.com/
---


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks

2002-11-11 Thread John W. Holmes
Interesting Quote:

MySQL's great performance was due mostly to our use of an in-memory
query results cache that is new in MySQL 4.0.1. When we tested without
this cache, MySQL's performance fell by two-thirds.

---John Holmes...

 -Original Message-
 From: Peter Beckman [mailto:beckman;purplecow.com]
 Sent: Monday, November 11, 2002 12:29 PM
 To: Maxim Maletsky
 Cc: Manos Papagelis; [EMAIL PROTECTED]
 Subject: Re: [PHP-DB] Are there any Oracle vs Postgresql official
 benchmarks
 
 EWeek compared MySQL to Oracle 9i and a few others, and they both came
out
 on top.
 
 http://www.eweek.com/article2/0,3959,293,00.asp

http://www.eweek.com/slideshow/0,3670,p=1s=1590a=23120po=1i=1,00.asp

http://www.eweek.com/slideshow/0,3670,p=1s=1590a=23120po=2i=1,00.asp
 
 On Mon, 11 Nov 2002, Maxim Maletsky wrote:
 
 
  I can already say that Oracle is faster. But official benchmark I
have
  never seen. Have you wondered aboout ACID test results for both?
 
 
  --
  Maxim Maletsky
  [EMAIL PROTECTED]
 
 
 
  Manos Papagelis [EMAIL PROTECTED] wrote... :
 
   Hello to all,
  
   I have searched enough to find some official benchmarks about
oracle
 and
   postgresql but it seems that don't exist any (mostly because
oracle
 license
   don't permit it). If someone has something in mind it would be
very
 helpful
   to keep me informed.
   I am stressly interested about official performance benchamarks of
 Oracle
   9.1 vs Postgresql 7.2.*, however any older benchmark that can give
a
 sense
   is welcomed.
  
   thanx in advance,
  
   - Manos Papagelis
  
  
  
   --
   PHP Database Mailing List (http://www.php.net/)
   To unsubscribe, visit: http://www.php.net/unsub.php
  
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 
 


--
 -
 Peter BeckmanSystems Engineer, Fairfax Cable Access
 Corporation
 [EMAIL PROTECTED]
 http://www.purplecow.com/


--
 -
 
 
 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] arrays db

2002-11-11 Thread Jason Wong
On Monday 11 November 2002 21:48, Martin Allan Jensen wrote:
 Okey people, i try again!!

 I have a table in a mysql database that holds this:
 +++++--+

 | id | maaler | aflaest| vaerdi | pris |

 +++++--+

 | 21 | 11 | 2002-01-01 |  15160 | 0.00 |
 | 22 | 11 | 2002-02-01 |  15180 | 0.00 |
 | 23 | 11 | 2002-03-01 |  15200 | 0.00 |
 | 24 | 11 | 2002-04-01 |  15240 | 0.00 |
 | 25 | 11 | 2002-05-01 |  15250 | 0.00 |
 | 27 | 10 | 2002-11-14 |210 | 0.00 |
 | 30 | 10 | 2002-12-19 |230 | 0.00 |

 +++++--+

 Each maaler have it's own start registration witch is:
 ++--+---+

 | id | nummer   | start |

 ++--+---+

 | 10 | 56456|   200 |
 | 11 | 02   | 15150 |

 ++--+---+

I still don't understand what you're doing :-/

 I then made a script that takes start for each maaler if it have any
 registrations. Then it does this: if its first field then it takes the
 vaerdi(THE VALUE) and - it with the start (THE STARTREGISTRATION) For
 the next fields it takes the vaerdi - the last vaerdi. My problem is
 that after the script has ran it have lets say 20 yeas 2002 (the
 registration year called aflaest in the table) and lets say two 2003.

But why are you keeping all those transient values ...

 I only need ONE value vaerdi per year, witch is the one it just calculated

... why don't you just keep the 'latest' value -- which should be the maximum 
value?

 in a loop. But it have all the values and years in the array. How do i only
 take ONE value per year in PHP NOT SQL??

 I really hope this is discriping enough!!

-- 
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *


/*
A lot of people are afraid of heights.  Not me.  I'm afraid of widths.
-- Steven Wright
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks

2002-11-11 Thread Peter Beckman
So install 4.0.1 and turn on in-memory query results cache! :-)

Peter

On Mon, 11 Nov 2002, John W. Holmes wrote:

 Interesting Quote:

 MySQL's great performance was due mostly to our use of an in-memory
 query results cache that is new in MySQL 4.0.1. When we tested without
 this cache, MySQL's performance fell by two-thirds.

 ---John Holmes...

  -Original Message-
  From: Peter Beckman [mailto:beckman;purplecow.com]
  Sent: Monday, November 11, 2002 12:29 PM
  To: Maxim Maletsky
  Cc: Manos Papagelis; [EMAIL PROTECTED]
  Subject: Re: [PHP-DB] Are there any Oracle vs Postgresql official
  benchmarks
 
  EWeek compared MySQL to Oracle 9i and a few others, and they both came
 out
  on top.
 
  http://www.eweek.com/article2/0,3959,293,00.asp
 
 http://www.eweek.com/slideshow/0,3670,p=1s=1590a=23120po=1i=1,00.asp
 
 http://www.eweek.com/slideshow/0,3670,p=1s=1590a=23120po=2i=1,00.asp
 
  On Mon, 11 Nov 2002, Maxim Maletsky wrote:
 
  
   I can already say that Oracle is faster. But official benchmark I
 have
   never seen. Have you wondered aboout ACID test results for both?
  
  
   --
   Maxim Maletsky
   [EMAIL PROTECTED]
  
  
  
   Manos Papagelis [EMAIL PROTECTED] wrote... :
  
Hello to all,
   
I have searched enough to find some official benchmarks about
 oracle
  and
postgresql but it seems that don't exist any (mostly because
 oracle
  license
don't permit it). If someone has something in mind it would be
 very
  helpful
to keep me informed.
I am stressly interested about official performance benchamarks of
  Oracle
9.1 vs Postgresql 7.2.*, however any older benchmark that can give
 a
  sense
is welcomed.
   
thanx in advance,
   
- Manos Papagelis
   
   
   
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
   
  
  
   --
   PHP Database Mailing List (http://www.php.net/)
   To unsubscribe, visit: http://www.php.net/unsub.php
  
 
 
 
 --
  -
  Peter BeckmanSystems Engineer, Fairfax Cable Access
  Corporation
  [EMAIL PROTECTED]
  http://www.purplecow.com/
 
 
 --
  -
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php



 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php


---
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED] http://www.purplecow.com/
---


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] Find out a pic size?

2002-11-11 Thread Davy Obdam
Hi There,

You could also use the getimagesize(); function for this

?php
$image=getimagesize(images/image01.jpg);
Echo
img src=\image01.jpg .image['3'].;
?

This will give img src=image01.jpg width=  height= 

Hope this helps

Best regards,
 
Davy Obdam
mailto:info;davyobdam.com


 -Oorspronkelijk bericht-
 Van: milisphp [mailto:milis;indoinformatika.com] 
 Verzonden: maandag 11 november 2002 7:38
 Aan: [EMAIL PROTECTED]
 Onderwerp: [PHP-DB] Find out a pic size?
 
 
 Hi, 
  
 I'm working with a lot of picture in a website and the size 
 is not always the same.
  
 I need some help on how to find out the size (width and 
 height) of a picture. Is there any way to do this (especially 
 with PHP)? 
  
 I need it so I can calculate the width and height to be 
 specified on the HTML img tag.
  
 Thanks,
  
 Hansen
 IndoInformatika
 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Access a Flat File DB - How?

2002-11-11 Thread Crony
I have written a few small apps in PHP and MySQL. These were mostly copy,
paste and change and fairly easy. I now wnat ot connect to a flat file dbase
that is used by another enterprise app. Then I want to start normal PHP
programming. Is there any risk in doing this? Where do I start?




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] forum test

2002-11-11 Thread dwalker
Went to your page.  You might try to implement client side browser testing
and redirect visitors to functional pages rather than display a message
suggesting your page can't be viewed.  Most people would probably prefer not
to 'upgrade' just to see a single site they hadn't visited before.


script language=JavaScript
!--
function
checkBrowser(NSvers,NSpass,NSnoPass,IEvers,IEpass,IEnoPass,OBpass,URL,altURL
) { file://v4.0
  var newURL='', verStr=navigator.appVersion, app=navigator.appName, version
= parseFloat(verStr);
  if (app.indexOf('Netscape') != -1) {
if (version = NSvers) {if (NSpass0) newURL=(NSpass==1)?URL:altURL;}
else {if (NSnoPass0) newURL=(NSnoPass==1)?URL:altURL;}
  } else if (app.indexOf('Microsoft') != -1) {
if (version = IEvers || verStr.indexOf(IEvers) != -1)
 {if (IEpass0) newURL=(IEpass==1)?URL:altURL;}
else {if (IEnoPass0) newURL=(IEnoPass==1)?URL:altURL;}
  } else if (OBpass0) newURL=(OBpass==1)?URL:altURL;
  if (newURL) { window.location=unescape(newURL);
document.returnValue=false; }
}
file://--


html
body bgcolor=#FF text=#00
onLoad=checkBrowser(4.0,1,2,4.0,1,2,2,'www.someplaceelse.com','Goto%20to%20
some%20other%20location');return document.returnValue
/html




-Original Message-
From: Seabird [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, November 06, 2002 1:22 PM
Subject: [PHP-DB] forum test


Hi everyone, I just uploaded my forum and would like to have it field
tested
by everyone. It'll prob still have some bugs in there.
http://seabird.jmtech.ca
go to website and then click on forum. please ignore the login in the left
top for now,

Jacco


--
http://seabird.jmtech.ca

Attitude is Everything!
But Remember, Attitudes are Contagious!
Is Yours worth Catching



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP-DB] forum test

2002-11-11 Thread Seabird
Thanx for the feedback. I was still working on the NN4 compatibility, and
had that message there until I got it solved. As you can see on my site,
most things are not near completion.

Thanx, for the script, I'll use it if my NN4 compatibility fales.

Jacco
--
http://seabird.jmtech.ca

Attitude is Everything!
But Remember, Attitudes are Contagious!
Is Yours worth Catching
Dwalker [EMAIL PROTECTED] wrote in message
news:01c289ec$74f20360$3650decf;b...
 Went to your page.  You might try to implement client side browser testing
 and redirect visitors to functional pages rather than display a message
 suggesting your page can't be viewed.  Most people would probably prefer
not
 to 'upgrade' just to see a single site they hadn't visited before.


 script language=JavaScript
 !--
 function

checkBrowser(NSvers,NSpass,NSnoPass,IEvers,IEpass,IEnoPass,OBpass,URL,altURL
 ) { file://v4.0
   var newURL='', verStr=navigator.appVersion, app=navigator.appName,
version
 = parseFloat(verStr);
   if (app.indexOf('Netscape') != -1) {
 if (version = NSvers) {if (NSpass0) newURL=(NSpass==1)?URL:altURL;}
 else {if (NSnoPass0) newURL=(NSnoPass==1)?URL:altURL;}
   } else if (app.indexOf('Microsoft') != -1) {
 if (version = IEvers || verStr.indexOf(IEvers) != -1)
  {if (IEpass0) newURL=(IEpass==1)?URL:altURL;}
 else {if (IEnoPass0) newURL=(IEnoPass==1)?URL:altURL;}
   } else if (OBpass0) newURL=(OBpass==1)?URL:altURL;
   if (newURL) { window.location=unescape(newURL);
 document.returnValue=false; }
 }
 file://--


 html
 body bgcolor=#FF text=#00

onLoad=checkBrowser(4.0,1,2,4.0,1,2,2,'www.someplaceelse.com','Goto%20to%20
 some%20other%20location');return document.returnValue
 /html




 -Original Message-
 From: Seabird [EMAIL PROTECTED]
 To: [EMAIL PROTECTED] [EMAIL PROTECTED]
 Date: Wednesday, November 06, 2002 1:22 PM
 Subject: [PHP-DB] forum test


 Hi everyone, I just uploaded my forum and would like to have it field
 tested
 by everyone. It'll prob still have some bugs in there.
 http://seabird.jmtech.ca
 go to website and then click on forum. please ignore the login in the
left
 top for now,
 
 Jacco
 
 
 --
 http://seabird.jmtech.ca
 
 Attitude is Everything!
 But Remember, Attitudes are Contagious!
 Is Yours worth Catching
 
 
 
 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Thanks

2002-11-11 Thread milisphp
Thanks for all the help, and sorry, I didn't pay attention that this is
a DB mailing list.
 
Thanks again. It's a huge help!