[MYSQL]$disp_ip = "SELECT * FROM `disp_ips` WHERE ScopeName LIKE '%arm%' ORDER BY ScopeName";[/MYSQL] y la visualizo asi
Código PHP:
if ($totIP> 0) {
# $rowIP['reemplazo'];
# while ($rowIP = mysql_fetch_assoc($resIP)) {
while ($rowIP = mysql_fetch_assoc($resIP)) {
echo "<TR>";
echo "<TD>".$rowIP['SubnetMask']."</TD>";
echo "<TD>".$rowIP['ScopeName']."</TD>";
echo "<TD>".$rowIP['%Free']."</TD>";
echo "<TD>".$rowIP['TotalDynamic']."</TD>";
echo "<TD>".$rowIP['TotalReserved']."</TD>";
echo "<TD>".$rowIP['Leased']."</TD>";
echo "<TD>".$rowIP['Avail']."</TD>";
echo "<TD>".$rowIP['sql']."</TD>";
echo "</TR>";
Código PHP:
SELECT REPLACE(ScopeName, if(SUBSTRING(ScopeName,1,17)='pc_basico128k_arm',ScopeName,'"#$%&'),'pc_basico512k_mex') FROM disp_ips;