PHP - Check First 2 Digits

How do I get the number as pairs? (i.e. 05, 20, 01, 70)

$query = "SELECT statez, COUNT(statez)FROM distributors GROUP BY statez";
   
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
   echo $row['COUNT(statez)'] ." Distributors in ". $row['statez'];
   echo "<br />";
}
?>

I need a way to find numbers 0000-9999 where no number has more than 2 digits in the same place in common. I know PHP but this is a little beyond me, can anyone help?

Below is some PHP code that looks at a DB and outputs a value within the user declared time and date period, via user recall using a web app attached to it.  The code is rounding the numbers but I want it to include 2 of the decimal places. The original numbers in the DB have up to 5 decimal digits.  This code is making them whole numbers.  i would like to include the first 2 digits.  I suspect the float should somehow be float(2) .  Not sure how to do that. 

thanks in advance   

<?php
$sql = ";WITH TOTAL_FULL_ENERGY_SUM_BASE_WEEKDAY_SUMMER AS
(
SELECT cdate, datepart(hh, cdate) as trans_hour, datepart(mi, cdate) as trans_minute, comm_id, 
max(cast(total_full_energy_b AS FLOAT)/1000) * meter_multiplier AS totalUsage, meter_multiplier
  FROM [radiogates].[dbo].[purge_data] LEFT OUTER JOIN [radiogates].[dbo].[ops_invoice] on [radiogates].[dbo].[purge_data].[comm_id] = [radiogates].[dbo].[ops_invoice].[meter_id] 
  where comm_id='$comm_id' and meter_multiplier is not null
  group by comm_id, cdate, meter_multiplier
)
SELECT top 1 *, datepart(weekday, cdate) as trans_date_day, 
datepart(month, cdate) as trans_date_month, datepart(hour, cdate) as trans_date_hour, DATEPART(minute, cdate) as trans_date_minute
FROM TOTAL_FULL_ENERGY_SUM_BASE_WEEKDAY_SUMMER 

where datepart(weekday, cdate) IN ('2', '3', '4', '5', '6') 
AND DATEPART(MONTH, cdate) IN ('5','6','7','8','9','10') 
and cdate between '$base_date $base_start_time' and '$base_date $base_end_time'

ORDER BY totalUsage desc";
$query = sqlsrv_query($conn, $sql);if ($query === false){  exit("<pre>".print_r(sqlsrv_errors(), true));}while ($row = sqlsrv_fetch_array($query)){  	$sumUsageWKW += $row[totalUsage];}sqlsrv_free_stmt($query);?> 

Edited by Butterbean, 15 October 2014 - 01:31 PM.

I have an integer that I'd like to validate to ensure that it is a valid number between 1 and 99999999999999999999(20 digits).

I'm thinking about using the following, but I'm not sure what the max range is on the FILTER_VALIDATE_INT options.

return filter_var($_REQUEST['r'], FILTER_VALIDATE_INT, array("options" => array("min_range"=>1, "max_range"=>99999999999999999999)));

Can someone advise the edit required to include validation of US phone numbers ($phone_number3) when entered with no spaces between the area code and/or prefix.

Note: I have working code (regular expression) that validates phone numbers that enclose the area code with parenthesis or having a space, hyphen, or dot between area code, prefix, or last four digits.

Examples:  all three shown below are validated based on regular expresion
(123) 456-7890
123.456.7890
123 456 7890

However, I want to also include the option for 1234567890 (phone number have NO spaces) as valid.

I know the edit will be within ( |-|.)  using the PIPE but not sure how to denote the "no space" syntax within the regular expression.

See the regular expression: $good_phone = "^\(?[0-9]{3}\)?( |-|.)[0-9]{3}(-|.)[0-9]{4}$";

and if you wan to view the entire php snippet


// function which validates an American phone number

function validate_phone($phone_number) {
   $good_phone = "^\(?[0-9]{3}\)?( |-|.)[0-9]{3}(-|.)[0-9]{4}$";

   if (preg_match("/$good_phone/", $phone_number)) {
  echo "$phone_number is valid.<br/>";
   }
   else echo "$phone_number is NOT valid.<br/>";
}

$phone_number1 = "123.456.7890";
validate_phone($phone_number1);

$phone_number2 = "(123) 456-7890";
validate_phone($phone_number2);

$phone_number3 ="1234567890";
validate_phone($phone_number3);