Re: [GENERAL] MOD

[Len Morgan]

>Not asking you to figure it out in this context,
>but just what does MOD do?
>
>
>$sqh = $dbh->prepare("select
>name,namelink,address,city,state,zip,email
>from company where MOD(nextscreen,2)=1 order
>by $sort_selection;");
>$sqh->execute();
>

I believe it's just trying to figure out if "nextscreen" is odd or even.  1
would odd, 0 even.

len morgan

Re: [GENERAL] MOD

[Chris Bitmead]

MOD is the remainder after division.

MOD(10, 3) = 1
MOD(11, 3) = 2
MOD(12, 3) = 0
MOD(13, 3) = 1

etc.

Tyler Wood wrote:
> 
> Hello,
> I'm updating an existing postgres database, and using
> perl with dbi to
> access it.
> 
> Everything works fine,
> I'm just not sure what this MOD command means.
> Not asking you to figure it out in this context,
> but just what does MOD do?
> 
> $sqh = $dbh->prepare("select
> name,namelink,address,city,state,zip,email
> from company where MOD(nextscreen,2)=1 order
> by $sort_selection;");
> $sqh->execute();
> 
> thank you,
> 
> Tyler Wood
> [EMAIL PROTECTED]
> 
> __
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/

[GENERAL] MOD

[Tyler Wood]

Hello,
I'm updating an existing postgres database, and using
perl with dbi to
access it.

Everything works fine,
I'm just not sure what this MOD command means.
Not asking you to figure it out in this context,
but just what does MOD do?


$sqh = $dbh->prepare("select
name,namelink,address,city,state,zip,email 
from company where MOD(nextscreen,2)=1 order
by $sort_selection;");
$sqh->execute();



thank you,

Tyler Wood
[EMAIL PROTECTED]

__
Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere!
http://mail.yahoo.com/