Re: Still trying to figure this out...
| From: | Robert Cummings | Date: | Mon, 19 Jun 2006 23:34:44 +0000 |
| Subject: | Re: Still trying to figure this out... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-238342@lists.php.net to get a copy of this message | ||
On Mon, 2006-06-19 at 16:39, Rob W. wrote:
> Ok, I am still trying to get this figured out from what I tried doing last night. If anybody
> wants to try it, please be my guest. This is the deal. Create an INTEGER table. Put the numbers 1 -
> 24 in it. Leave out like number 8, 9, 22, 23 ect.. Now create a php statement that will take and
> pull that out of the database, find out the missing numbers and display them as an html drop down
> selection.
>
> And tedd in response to why, is because the values that are already located in the database
> represent in use already. They represent a server port that a server is sitting on, so that's
> not the problem. I could have done that along time ago.
>
> Any help is appreciated but here is the current code that I have.
>
>
$query="SELECT switchport FROM network";
> $result=mysql_query($query);
> $sql_range=mysql_fetch_array($result);
> $true_range=range(1,24);
> $next_range=array_diff($true_range,$sql_range);
> foreach ($next_range as $final_range) {
> echo "<option value='$final_range'>$final_range\n";
> }
<?php
$range = array_flip( range( 1, 24 ) );
$query = "SELECT switchport FROM network ";
if( ($result = mysql_query( $query )) !== false )
{
while( ($row = mysql_fetch_array( $result )) !== false )
{
unset( $range[$row[0]] );
}
}
foreach( $range as $switchport => $foo )
{
echo '<option
value="'.$switchport.'">'.$switchport.'</option>'."\n";
}
?>
Cheers,
Rob.
--
.------------------------------------------------------------.
| InterJinn Application Framework - http://www.interjinn.com
|
:------------------------------------------------------------:
| An application and templating framework for PHP. Boasting |
| a powerful, scalable system for accessing system services |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for |
| creating re-usable components quickly and easily. |
`------------------------------------------------------------'