I am getting a 0 when echoing the variable from the code snippet below, and I am sure it has something to do with the LIKE portion on the SQL query, but I cannot figure it out.. The goal is to print the percentage of free IPs on our local network, but it's showing a zero. Is the answer glaringly simple?
$ipb10 = '10.'; $query1 = "SELECT SUM(no_ips) AS totalip FROM ips WHERE INET_NTOA(sip) LIKE '.$ipb10.' "; $result = mysql_query($query1); $r = mysql_fetch_array($result); $free = 16777216; $pctg1 = ($r['totalip']/$free*100); echo number_format($pctg1, 2);