June 28th, 2009, 08:50 PM
|
|
Registered User
|
|
Join Date: Jul 2003
Location: New Jersey
Posts: 3
Time spent in forums: 34 m 53 sec
Reputation Power: 0
|
|
Limiting DB Values Shown
Hey everyone quick DB question, I have this
Code:
if( $userMonster > 0 ) {
$res = query("SELECT * FROM `usertable` WHERE `upower`>0 AND `userid`!=$user AND `ufights`>0");
list($total) = mysql_fetch_array($res);
if( $total > 0 ) {
$res = query("SELECT * FROM `usertable` WHERE `upower`>0 AND `userid`!=$user ORDER BY RAND() LIMIT 0,10");
now that works just fine, but what I want to do is set it so that it shows WHERE `upower` any value from 0-49 can be shown
I tried 0>49 but that didn't work, any suggestions?
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
