Hello,
I have tried using the php direct code in my cms feature, it works but the code does not appear inside the template, please check it out at http://121chatrooms.net/v4/content.p...tor-Management
the code i used was -
I have tried using the php direct code in my cms feature, it works but the code does not appear inside the template, please check it out at http://121chatrooms.net/v4/content.p...tor-Management
the code i used was -
Code:
include "database.php"; echo "<b>Administrators:</b><br>"; $result = mysql_db_query($dbname, "SELECT * FROM member WHERE MemberType = '5' or MemberType = '4' order by username asc ") or die (mysql_error); if (mysql_num_rows($result)) { while ($qry = mysql_fetch_array($result)) { $query2 = mysql_query("SELECT * FROM member WHERE UserName='$qry[UserName]' ") or die("Could not insert data because ".mysql_error); $qry2 = mysql_fetch_array( $query2 ); $query4 = mysql_query("SELECT * FROM onlineusers WHERE UserName='$qry[UserName]' ") or die("Could not insert data because ".mysql_error); $qry4 = mysql_fetch_array( $query4 ); $query3 = mysql_query("SELECT * FROM room WHERE RoomID='$qry4[RoomID]' ") or die("Could not insert data because ".mysql_error); $qry3 = mysql_fetch_array( $query3 ); echo "<img src='../images/ranks/admin.gif'> $qry2[UserName] <a href='../profiles/profile.php?search=$qry2[UserName]'>[View Profile]</a> <br>"; } }
Comment