This code dont seem to be working because it dont say wheather im deluxe or standard, I think it might be the query that is the problem.
HELPPP MEEE
THANKSSS
Results 1 to 10 of 12
Thread: Query Code Problem
-
Query Code Problem
-
PHP Code:
<?
$username = addslashes($_POST['username']);
$result = mysql_query("SELECT `accounttype` FROM `users` WHERE `username`='".mysql_real_escape_string($username)."'")or die(mysql_error());
$row = mysql_fetch_array($result);
$loggedin = $_SESSION['logged_in'];
$username = $_SESSION['username'];
$accounttype = $row['accounttype'];
echo '
<html>
<body background="http://lv-cnr.com/bg.png">
<center>';
if(!isset($_SESSION['logged_in']) || !isset($_SESSION['username']))
{
header("location: index.php");
}
switch($accounttype){
default:
case "standard":
echo 'You do not have sufficient rights to view this page!';
break;
case "deluxe":
echo 'Welcome Deluxe user!';
break;
}
?>
-
It keeps saying
You do not have sufficient rights to view this page!
Even though my accounttype is deluxe?
Plus i also get
Warning: Cannot modify header information - headers already sent by (output started at /home/kylesmith09/domains/lv-cnr.com/public_html/staff/tesrt.php:15) in /home/kylesmith09/domains/lv-cnr.com/public_html/staff/tesrt.php on line 19
Originally Posted by Delatory
-
it does not sound like you have the right data set in the database Originally Posted by KyleSmith
do echo $accounttype.
also move the echo '<html... to below the if statement
-
I did that but now it likes to redirect me :/
This is the code
-
If it's redirecting you, then one of the session variables (logged_in or username) doesn't exist.
-
For the code to work i had to edit it to this,
But it dont redirect me now but even though im deluxe it says i aint got the right like urmm accounttype
-
The next bit is that accounttype (presuming it exists) is not deluxe.
Under $accounttype = $row['accounttype']; put
print_r($row);
exit();
and paste what it says on the screen
-
Its a blank page this is my sql database
-
Remove
print_r($row);
exit();
and replace $_POST['username'] to $_SESSION['username'] on line 4Last edited by Delatory; 09-02-2010 at 08:13 PM.
Reply With Quote
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts