Hello Pablo,
I made a Typo:
change this: while ($key<80) echo "$lastgroup." . ($key++) . " is free\n";
for this: while ($key<255) echo "$lastgroup." . ($key++) . " is free\n";
;)
--
Best regards,
Pablo
--
PHP Database Mailing List (http://www.php.net/)
To unsu
Hello redhat,
Hey... look at this:
CREATE TABLE `testip` (
`id` int(10) unsigned NOT NULL auto_increment,
`theip` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `theip` (`theip`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;
SELECT theip, SUBSTRING_INDEX( theip, ".", 1
[snip]
The IP's (for example 192.168.1.1) are all in a single field.
[/snip]
If it is a possiblity, I would store each IP in its own row, with a
column in that row being some kind of flag, like: is_issued as a logical
column.
Can you change you db layout or is it set in stone?
--
PHP Database M
I have a small script that I mangled together to enable me to input user
IP addresses into a MySQL db. The IP's (for example 192.168.1.1) are
all in a single field. The IP field is set to VARCHAR(100) Unique but
it is not the primary key. I have found that my IPs are not consecutive
and I would
