Probably the problem is in php, or, more probably, in how you store first and then look for the IP address in your query. You should try your query in the mysql console; varchars work almost with anything and I put this example where I look for an IP address with your table, and it finds it correctly.
Hope this helps; if you can't find the problem, try little steps with select * from portal_forums_users where ip = '192.168.1.0'; To try and find where you have a problem. You can even try select * from portal_forums_users where ip like '%192.168.1.0%'; The % are wildcards, and that would take care of periods you inadvertenly added/erased. I really think this is not a MySQL problem. mysql> describe portal_forums_users; +---------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+----------------+ | user_id | bigint(255) | | PRI | NULL | auto_increment | | ip | varchar(200) | YES | | NULL | | | signup_date | varchar(30) | YES | | NULL | | | city | varchar(200) | YES | MUL | NULL | | | state | varchar(100) | YES | | NULL | | | email_address | varchar(200) | YES | | NULL | | | username | varchar(100) | YES | | NULL | | | password | varchar(100) | YES | | NULL | | | yim | text | YES | | NULL | | | aol | text | YES | | NULL | | | web_url | text | YES | | NULL | | | post_count | varchar(255) | YES | | NULL | | | info | text | YES | | NULL | | | sig | text | YES | | NULL | | | avatar | text | YES | | NULL | | | css_id | int(11) | YES | | NULL | | | mod_f | varchar(20) | YES | | NULL | | | admin | varchar(20) | YES | | NULL | | +---------------+--------------+------+-----+---------+----------------+ 18 rows in set (0.00 sec) mysql> select * from portal_forums_users; +---------+-------------+-------------+------+-------+---------------+----------+----------+------+------+---------+------------ | user_id | ip | signup_date | city | state | email_address | username | password | yim | aol | web_url | post_count +---------+-------------+-------------+------+-------+---------------+----------+----------+------+------+---------+------------ | 1 | 192.168.1.0 | x | x | x | x | x | x | x | x | x | x | x | x | x | 0 | x | x | | 2 | 10.100.1.1 | y | y | y | y | y | y | y | y | y | y +---------+-------------+-------------+------+-------+---------------+----------+----------+------+------+---------+------------ 2 rows in set (0.00 sec) mysql> select * from portal_forums_users where ip = '192.168.1.0'; +---------+-------------+-------------+------+-------+---------------+----------+----------+------+------+---------+------------ | user_id | ip | signup_date | city | state | email_address | username | password | yim | aol | web_url | post_count +---------+-------------+-------------+------+-------+---------------+----------+----------+------+------+---------+------------ | 1 | 192.168.1.0 | x | x | x | x | x | x | x | x | x | x | x | x | x | 0 | x | x | +---------+-------------+-------------+------+-------+---------------+----------+----------+------+------+---------+------------ 1 row in set (0.00 sec) -----Mensaje original----- De: CodeHeads [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 22 de febrero de 2006 17:35 Para: Ariel Sánchez Mora CC: mysql@lists.mysql.com Asunto: RE: Number Searches On Wed, 2006-02-22 at 16:49 -0600, Ariel Sánchez Mora wrote: > So far i've been able to store ip addresses as strings like you would > type them in DOS, for ex, '192.168.0.1'. This serves me great since my > application uses IP addresses as strings in all cases. I've done > queries with the IP column , for example, select office_name from > table_1 where ip='10.100.1.1'; and have never had any problems. > However, if you plan on sorting based on this column, strings with > periods do not behave correctly, and the answers to my previous > question on this list do not apply; it makes a good aproximation, > though. > > Hope this helps, but I must admit I am not sure if this answers your > question. An example in the mysql console would be great for clearing > up your objetive. > > Regards, > > Ariel OK, I think I did not explain things right the first time. :( I have a table like so: CREATE TABLE `portal_forums_users` ( `user_id` bigint(255) NOT NULL auto_increment, `ip` varchar(200) default NULL, `signup_date` varchar(30) default NULL, `city` varchar(200) default NULL, `state` varchar(100) default NULL, `email_address` varchar(200) default NULL, `username` varchar(100) default NULL, `password` varchar(100) default NULL, `yim` text, `aol` text, `web_url` text, `post_count` varchar(255) default NULL, `info` text, `sig` text, `avatar` text, `css_id` int(11) default NULL, `mod_f` varchar(20) default NULL, `admin` varchar(20) default NULL, PRIMARY KEY (`user_id`), FULLTEXT KEY `full_index` (`city`,`state`,`username`,`email_address`,`ip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Notice the FULLTEXT; I have the ip listed to be indexed. Using a PHP script I have it will not grab the IP that I am searching for, even though it *is* in the database. The ip's are entered into the database as 192.168.1.10. When I search for a username it works great. Is it because of the "." (periods) in the search string?? Hopefully I explained that right this time!! :) LOL -- Best regards, ~WILL~ Key: http://code-heads.com/keys/ch1.asc Key: http://code-heads.com/keys/ch2.asc Linux Commands: http://code-heads.com/commands Linux Registered User: 406084 (http://counter.li.org/) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
