Code: Select all
$query = "SELECT status FROM users WHERE firstname='$fn' AND status='administrator'";
$result = @mysql_query($query);
if ($result)
{
include('commentform.php');
}
else
{
NULL;
}thanks
Moderator: General Moderators
Code: Select all
$query = "SELECT status FROM users WHERE firstname='$fn' AND status='administrator'";
$result = @mysql_query($query);
if ($result)
{
include('commentform.php');
}
else
{
NULL;
}Code: Select all
if (mysql_num_rows($result)!=0)
{
include('commentform.php');
}
else
{
NULL;
}Code: Select all
<?
$id = $_SESSIONї'userID'];
include('functions/library.php');
$query = "SELECT status FROM users WHERE userID='$id' and status='administrator'";
$result = @mysql_query($query);
if ($result)
{
//verify administrator
if ($rowї0])
{
adminpagination();
}
//if not administrator
else
{
memberpagination();
}
}
?>Code: Select all
if (mysql_num_rows($result) != 0)
{
include('commentform.php');
}
else
{
NULL;
}Code: Select all
<?php
// ensure the SESSION id variable is numeric
$id = floor($_SESSIONї'userID']);
include('functions/library.php');
$query = "SELECT status FROM users WHERE userID='$id'";
$result = @mysql_query($query);
if ($result) {
if (@mysql_num_rows($result)==1) {
// User ID exists
if (@mysql_result($result,0,'status') == 'administrator') {
adminpagination();
} else {
//if not administrator
memberpagination();
}
} else {
echo("User does not exist or is entered duplicate times (only if user id is not set to unique in DB");
}
} else {
echo("Database Failure....");
}
?>Code: Select all
$query = "SELECT status FROM users WHERE userID='$id' and status='administrator'";
$result = @mysql_query($query);
if (mysql_num_rows($result) != 0)
{
adminpagination();
}
else
{
memberpagination();
}