Search
MemHT Portal is a Free PHP CMS and Blog
It permit the creation and the management online of websites with few and easy steps.
It's completelly customizable, expandable and suitable for all needs.
      Download MemHT Portal
Forum
Moderators: Moderators
Forum RSS feedReply
SQL problem while changing online block
AuthorText
Zion
Junior Member
Avatar

Posts: 27
Contributes: 29

Gender: _MALE_
Online: No
Date: 01/08/2008 03:53
SQL problem while changing online block		#post10758
Hi guys,
I'm trying to edit the "who is online" block that it will show gender instead of country.
I added this line on line 42 after $country:
code

$gender = intval($dblink->query("SELECT gender,FROM memht_utenti WHERE user='$ouser'"));
 

and it returns 0, even if the field is 1.
Any suggestions?
(First time for me with Databases, so take it easy).
Thanks.
Zion.
Delete Edit Quote
 
paulo89
Moderator
Developer
Avatar

Posts: 1300
Contributes: 537

Gender: _MALE_
Online: No

Version: 3.8.1
Country: Portugal
Languages: Portuguese, Portuguese and little english ^^
Date: 01/08/2008 08:47
Re: SQL problem while changing online block		#post10765
Hi

Somethink like this:

code

                $test = $dblink->get_row("SELECT gender FROM memht_utenti WHERE user='$ouser'");
                $gender = intval($test['gender']);
 
View Image resized (Original file: 468x60)
Thumb
Delete Edit Quote
 
Zion
Junior Member
Avatar

Posts: 27
Contributes: 29

Gender: _MALE_
Online: No
Date: 02/08/2008 03:47
Re: SQL problem while changing online block		#post10774
Thanks,
The problem was fixed, and it works fine now.
Zion.
Delete Edit Quote
 
Reply
Tags Cloud
queries ukrainian 3.7.0 calendar adsense MemHT Donations Tracking Block full screen Drag installation browse Software Update to 4.0.1 football pagina banner SEO Support todo problems install spelling..;) php video functions development banned user submission tutorial tags guestbook 3.8.1 wiki joomla RSS Aggregator Native tongue election decription template forum 3.7.5 ru albums xml 3.9.0 unicode text web Latest downloads of a category memht editor help customizzare block Drop topic delete 4.0.0 italiano phpnuke gfghfgf add on meta tags Send News encoding utf8 Russia hits pages register one Teky documents caratteri fix newsletters shop slow memht5 Restrict profile visit Database links problem wizzywig unstable director mod phpfusion test sms 4.0.1 problem Navigator get blank wide screen post payment v bulletin combo virtual addons php-fusion language captcha Clients download imageup
Advertising
News Archive
December 2008 (3)
November 2008 (4)
October 2008 (3)
September 2008 (6)
July 2008 (5)
June 2008 (2)
May 2008 (4)
March 2008 (4)
February 2008 (3)
January 2008 (5)
December 2007 (3)
November 2007 (6)
October 2007 (8)
September 2007 (3)
August 2007 (1)
July 2007 (5)
June 2007 (1)
May 2007 (3)
April 2007 (8)
March 2007 (1)
February 2007 (5)
July 2006 (1)
December 2005 (1)
Language
Help MemHT Portal
Navigator
Home
Community
Contact Us
Download
Forum
News
Gallery
RSS Feeds
Search
SiteMap
Submission
Topics
User Page
Users Block
Hi Guest
IP: 38.103.63.59

Username
Password
New files
Hindi language file for memHT portal
Dutch Language File for MemHT Portal 4.0.1.b
Czech Language
Rating Mod
Path Dla MemHT PolishPack 4.0.1
YouTube 1.1 User Add Button
Calendar of Events 2
Forum adsense or banner (mod)
User Info (Lasts)
GuestBook 2
MemHT Portal Tam Türkçe Sürüm v4.0.1
Cumulus Tag
Dutch Language for MemHT Portal 4.0.1
MemHT Chat 1.2
MemHT Portal 4.0.1
Dutch Language for MemHT Portal 4.0.0
MemHT Portal 4.0.0
Gelişmiş Türkçe Seo [ Turkish modrewrite ]
Türkçe Admin Panel 3.9.0 [ Turkish admin panel ]
Linklerde Türkçe Karakter Düzeltmesi - Turkish character
MemHT Wiki
How to add Banners
Languages
Hooks
How to create new Addons
Default template style
Custom Functions
How to install new Templates
How to create new Templates
Requirement
Features
Friends
ErEiSeR.org
LilloDiPiazza
WebmasterFacile.it
PHPNukeForDonkeys
RainTPL.com
memht.com
Copyright © 2002-2008 by Miltenovik Manojlo - All rights reserved

www.memht.com
www.memht.org
www.memht.it
 |
"This is by far the best freeware cms that i ever come across, my compliments to all of the staff"
marc58
 |
MemHT Portal is a free software released under the GNU/GPL License by Miltenovik Manojlo