|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
Dell PowerEdge Servers
|
|
#1
June 15th, 2005, 04:58 AM
|
|||
|
|||
|
Help With PHP-Nuke Block
Hey everyone! I'm trying to modify a block that shows the top forum posters.
Code:
$result=$db->sql_query("SELECT user_id, username, user_posts, user_avatar FROM ".$user_prefix."_users ORDER BY user_posts DESC LIMIT 0,".$number."");
The code works fine as is but I want to ommit all with a user_id of 4 and less. I've tried putting "WHERE > 4" in by SELECT user_id but it doesn't work and I'm left with an empty block. Thanks in advance Joe
|
|
#2
June 15th, 2005, 05:35 AM
|
|||
|
|||
|
RE: Help With PHP-Nuke Block
Try this:
$result=$db->sql_query("SELECT user_id, username, user_posts, user_avatar FROM ".$user_prefix."_users where user_id!=4 ORDER BY user_posts DESC LIMIT 0,".$number.""); Also try switching to a standard phpBB and modding it yourself, since phpNuke is a security and modability disaster. ;)
|
|
#3
June 15th, 2005, 05:41 AM
|
|||||
|
|||||
|
RE: Help With PHP-Nuke Block
how did u use the where clause, have u done it this way???:
php Code:
|
|
#4
June 15th, 2005, 06:01 AM
|
|||
|
|||
|
RE: Help With PHP-Nuke Block
Thanks guys!! Works like a charm!!
I tried using the where clause just after the SELECT user_id query in brackets, not in brackets and a few other attempts at trying to figure this out myself. All without any luck of course.
|
|
| Viewing: Codewalkers Forums > PHP Related > PHP Applications > Help With PHP-Nuke Block |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
