Have something to say? Contribute New Article Reply to this Article
MySQL error showing when they shouldn't
Hello,
I'm building a website like MySpace, the address is http://pantarei.awardspace.com the website is wrote in Italian. It has members customizable profiles, internak message system, search user tools, a forum and a chat.
I just builded the main forum page but I have a problem that I cannot solve. The forum is divided in 3 different section, based on authorzation: one is visable by everybody, one just by who is logged in and one just by the modarators and admins. The tre sections are showed all by the same pae that gets from the url the level of the forum, check the authorization and then show it.
When I open the forum without being logged in it works fine, but when I open it being logged in the first query gives out a different result that mysql_fetch_assoc is unable to read.
The login system is made with database stored variable, one with the id of the user and the other one with the authorization. I don't understand how can this influence the forum.
The main forum page's code is:
[php]
<?php
require_once "../includes/session_handler.inc.php";
require "../includes/functions.inc.php";
session_start();
$_SESSION['pgnm']="Forum";
$_SESSION['pgsec']="5";
$conn=connect_db();
if ((!isset($_GET['lev'])) or ($_GET['lev']==3)){
header ("Location: ".ADRESS."/forum.php");
exit;
}
if (isset($_SESSION['auth'])){
if ($_GET['lev']>$_SESSION['auth']){
header ("Location: ".ADRESS."/forum.php");
exit;
}
} elseif ($_GET['lev']!=0){
header ("Location: ".ADRESS."/forum.php");
exit;
}
$res=mysql_query("SELECT * FROM forumsects WHERE forumsects_lev='".$_GET['lev']."' ORDER BY forumsects_order", $conn) or die(mysql_error());
require "../includes/header.inc.php";
?>
Oggi é <?php echo date("l j F Y, g:i"); ?>
<?php switch($_GET['lev']){
case 0:
echo "Forum Pubblico";
break;
case 1:
echo "Forum Privato";
break;
case 2:
echo "Forum Moderatori";
break;
} ?>
View unanswered posts
<?php switch($_GET['lev']){
case 0:
echo "Forum Pubblico";
break;
case 1:
echo "Forum Privato";
break;
case 2:
echo "Forum Moderatori";
break;
} ?>
Threads
Posts
Ultimo Post
<?php while ($gr=mysql_fetch_assoc($res)){
extract($gr);
?>
<?php echo $forumsects_name; ?>
<?php
$re=mysql_query("SELECT * FROM forums WHERE forums_sect='".$forumsects_id."' ORDER BY forums_order", $conn);
while ($fr=mysql_fetch_assoc($re)){
extract($fr);
$mod=explode("|", $forums_admins);
$lastdt=date("l j F Y, g:i", mktime($forums_lsdate['11'].$forums_lsdate['12'], $forums_lsdate['14'].$forums_lsdate['15'], 0, $forums_lsdate['5'].$forums_lsdate['6'], $forums_lsdate['8'].$forums_lsdate['9'], $forums_lsdate['0'].$forums_lsdate['1'].$forums_lsdate['2'].$forums_lsdate['3']));
$us=mysql_query("SELECT login_user FROM login WHERE login_id='".$forums_lsuser."'", $conn);
$arr=mysql_fetch_assoc($us);
$lsusnm=$arr['login_user'];
?>
<?php echo $forums_name; ?>
<?php echo $forums_descr; ?>
Moderators
<?php foreach($mod as $m){
$d=mysql_query("SELECT login_user FROM login WHERE login_id='".$m."'", $conn);
$arr=mysql_fetch_assoc($d);
$modnm=$arr['login_user'];
echo "".$modnm." ";
} ?>
<?php echo $forums_threads; ?>
<?php echo $forums_posts; ?>
<?php echo $lastdt; ?>
<?php echo $lsusnm; ?> 
<?php
}
}
?>
All times are GMT
<?php
require "../includes/footer.inc.php";
?>
[/php]
You can try the problem by logging in with the username "prova" and password "prova".
The first query $res=mysql_query("SELECT * FROM forumsects WHERE forumsects_lev='".$_GET['lev']."' ORDER BY forumsects_order", $conn) or die(mysql_error()); give out two different values (when it works 6, when it doesn't 8).
I hope you can find the problem.
Astegiano
You
© 2012 DaniWeb® LLC
