Yeah, that's what i'm trying to print is the missing numbers in the db.
That's what I've been trying to figure out this whole time.
----- Original Message -----
From: "Xavier Casto" <xavier@xxxxxxxxx>
To: "'Rob W.'" <rob@xxxxxxxxxxxxxxx>
Cc: <php-general@xxxxxxxxxxxxx>
Sent: Monday, June 19, 2006 6:34 PM
Subject: RE: Still trying to figure this out...
Are there any numbers missing in your database table between 0 and the
number you assigned to $maxport?
-----Original Message-----
From: Rob W. [mailto:rob@xxxxxxxxxxxxxxx]
Sent: Monday, June 19, 2006 6:26 PM
To: php-general@xxxxxxxxxxxxx
Subject: Re: Still trying to figure this out...
Yep, and still nothing output's.
----- Original Message -----
From: "Xavier Casto" <xavier@xxxxxxxxx>
To: "'Rob W.'" <rob@xxxxxxxxxxxxxxx>
Cc: <php-general@xxxxxxxxxxxxx>
Sent: Monday, June 19, 2006 6:20 PM
Subject: RE: Still trying to figure this out...
You did make sure to assign a numerical value to $maxport?
-----Original Message-----
From: Rob W. [mailto:rob@xxxxxxxxxxxxxxx]
Sent: Monday, June 19, 2006 6:15 PM
To: php-general@xxxxxxxxxxxxx
Subject: Re: Still trying to figure this out...
This also didnt work, Still giving me no output just like the last try.
----- Original Message -----
From: Xavier Casto
To: Rob W.
Cc: php-general@xxxxxxxxxxxxx
Sent: Monday, June 19, 2006 4:33 PM
Subject: Re: Still trying to figure this out...
Have you ever thought of doing something like this:
for($i = 0; $i <= $maxport; $i++)
{
$query="SELECT switchport FROM network WHERE switchport = ".$i;
$result=mysql_query($query);
if(empty($result))
{
echo "<p>$i</p>";
}
}
It should only return the ones that aren't in the table and they will
automatically be sorted in ascending order.
On 6/19/06, Rob W. <rob@xxxxxxxxxxxxxxx> 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 General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
