Comparing IPs...
Posted: Wed Jan 03, 2007 5:54 pm
I have 2 questions...
1) Which data type should i store IPs as? At the moment i am using VARCHAR. Is this recommended?
2) I have a table with the following rows...
login_id, user_id, ip, success, time
I was wondering how i can select the user_ids that have been logged into by an IP that has also logged into another user_id.
Thank you
Shears
1) Which data type should i store IPs as? At the moment i am using VARCHAR. Is this recommended?
2) I have a table with the following rows...
login_id, user_id, ip, success, time
I was wondering how i can select the user_ids that have been logged into by an IP that has also logged into another user_id.
Thank you
Shears