On Thu, 2006-02-23 at 10:49 -0600, Ariel Sánchez Mora wrote: > 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 >
I will have to agree with you on this. I will have to see what I can come up with. Thank you all for your help in this! I just wanted to make sure that it was not a mysql problem. I can fix the php code better then the mysql database! LOL :) Thanks again! :) -- 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/)
signature.asc
Description: This is a digitally signed message part