php forum
php mysql forum
php mysql smarty
 
Topic Options
#221318 - 07/17/02 04:16 AM how2 find all posters with a certain ip number
mario2 Offline
Enthusiast

Registered: 07/08/99
Posts: 470
Loc: Los Angeles, Rio de Janeiro, M...

   how2 find all posters with a certain ip number to Del.icio.us Add to del.icio.us
  Digg how2 find all posters with a certain ip number Digg it
I need a database command to find all posters from a certain ip number<br /><br />are wildcards possible?<br /><br />like 215.224.4.*<br />?? or just all starting with 214.224.4.<br /><br />Thanks!!!! <img src="/forum/images/icons/confused.gif" alt="" />

Top
#221319 - 07/17/02 07:59 AM Re: how2 find all posters with a certain ip number [Re: Jared]
Dave_L_dup1 Offline
Addict

Registered: 04/23/02
Posts: 1929
Loc: Virginia, USA
In MySQL, _ matches any single character, and % matches any string. <br /> <br />SELECT U_Username,U_RegIP <br />FROM w3t_Users <br />WHERE U_RegIP LIKE '215.224.4.%'
_________________________
UBB.threads beta tester / threadsdev.com moderator
Software consulting services including UBB.threads problem resolution / installs / upgrades / customization.

Top


Top Posters Last 30 Days
AllenAyres 12
Gizmo 10
S7ARBVCK 2
Cambridge 1
Murphdog 1
MattUK 1
Kevin H 1
Who's Online
0 Registered (), 41 Guests and 8 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
BeyondCompare v3.00
by blaaskaak
Yesterday at 02:46 PM
Noob - need help, or a reality check!
by Gizmo
09/04/08 03:21 AM
Here I am! Rock me like a Hurricane!
by AllenAyres
09/02/08 03:05 PM
[7.x] Generic Page Outside of forum directory
by Gizmo
08/30/08 05:43 PM
Team UBBDev Rides Again!
by Gizmo
08/28/08 11:45 PM
Multiple Identity Detector
by MattUK
08/28/08 04:10 PM
[7.3.x] ubb.links
by AllenAyres
08/26/08 09:57 AM
New Mods
Installing FlashChat with 7.3
by Paug
08/23/08 12:14 AM
[7.3.x] ubb.links
by AllenAyres
06/20/08 11:50 PM
[7.2.1] - Naked shoutbox
by sirdude
08/17/07 10:36 PM
[7.x] Generic Page Outside of forum directory
by
01/14/07 10:58 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
Newest Members
veedubb8, twentyseven, Claus1, welcomeback1, Paug
13327 Registered Users

 

 

 
fusionbb message board php hacks