Increments

[raouleduke]

I want to find the next 3000 mile increment, from the Maximum Service date, I can get it to work but only when I put it in the query is there a way to do it after the query.
I works just fine like this but I want to figure it out after the query, because I am selecting the MAX(Mileage) in the query.

$query1 = "SELECT 3000 - MOD($mileage, 3000) nextservice FROM 

Something like this.

$mileage = $row["MAX(MILEAGE)"];
$nextservice = 3000 - MOD($mileage, 3000);

Thanks in advance.

[Shrike]

The modulus operator in PHP is % :

$nextservice = 3000 ($mileage % 3000);

[raouleduke]

I keep getting parse errors when I use that.

[Weedpacket]

Originally posted by raouleduke
I keep getting parse errors when I use that.

Yes; there is a typo in it, but a bit of thought about it should clear things up.

[Shrike]

Oops keep losing those damn pesky operators.