Constant for maximum integer value?

Hi,

I'm using PHP 5 with MySql 5. I have a MySQL InnoDB table with a
column of type INTEGER UNSIGNED. Is there a constant in PHP to insert
the maximum value possible into the column? The underlying OS is Red
Hat Linux, but I'm not sure about the version.

Any help you can provide is appreciated, - Dave

re: Constant for maximum integer value?

laredotornado@zipmail.com wrote:The maximum in PHP does not necessarily equate to the maximum in MySQL.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

re: Constant for maximum integer value?

On Nov 15, 4:32*pm, Jerry Stuckle <jstuck...@attglobal.netwrote:When I said "to insert the maximum value in the column", I meant the
maximum value that MySQL will allow. Is there a PHP expression that
can evaluate to the maximum unsigned integer in MySQL or do I just
need to hard code the maximum number in my code? - Dave

re: Constant for maximum integer value?

laredotornado@zipmail.com wrote:What you need then is the maximum MySQL value, not the maximum PHP
value. They are two different things.

Try comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

re: Constant for maximum integer value?

nadia schreef:Nadia, just curious: Are you claiming you didn't have enough room in a
32 bit integer to store the file size of a video?
If not, what did go wrong?

Anyway, if you need Big Numbers and want to be excact, try BC Math
Functions:
http://nl3.php.net/manual/en/ref.bc.php

Regards,
Erwin Moller


--
"There are two ways of constructing a software design: One way is to
make it so simple that there are obviously no deficiencies, and the
other way is to make it so complicated that there are no obvious
deficiencies. The first method is far more difficult."
-- C.A.R. Hoare

re: Constant for maximum integer value?

Erwin Moller escribió:Let me answer. Believe it or not, that's true. But that's not all. There
doesn't seem to be any simple way to get the size of file that's larger
than 4GB (i.e., 2^32 bytes). Function filesize() won't return the right
size.



--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--

re: Constant for maximum integer value?

nadia schreef:Hi,

Hmm, I never worked with such huge files, but I imagine that must be
really annoying.
How do you solve that problem?
Do you resort to *nix commands (and pass them to exec() and the like) to
get the info you want?

Regards,
Erwin Moller


--
"There are two ways of constructing a software design: One way is to
make it so simple that there are obviously no deficiencies, and the
other way is to make it so complicated that there are no obvious
deficiencies. The first method is far more difficult."
-- C.A.R. Hoare

re: Constant for maximum integer value?

nadia schreef:Hi,

I don't want to be picky, but I believe I only build serious webapps in
PHP.
I don't think you can say in general that if you need to build anything
serious you cannot use PHP.

Allthough I feel your pain when you cannot get the filesize when a fileCan you give me more problems you encountered with PHP that made you
'fallback' to Delphi? (No pun intended to Delphi at all)
I am curious since it is better to know this kind of things before I
screw up some project. ;-)

Regards,
Erwin Moller


--
"There are two ways of constructing a software design: One way is to
make it so simple that there are obviously no deficiencies, and the
other way is to make it so complicated that there are no obvious
deficiencies. The first method is far more difficult."
-- C.A.R. Hoare