Jump to content

Archived

This topic is now archived and is closed to further replies.

WesL

Client Orders after Log-in

Recommended Posts

I have a log-in script that after loging in takes the user to a 'product page.' On that 'product page' it says "Welcome 'username' " and that part works fine.

 

What I'm trying to add to the page for a list of the users $rows in a MySQL db to show on the page also.

 

This is the code I'm using welcome or kick the user. (this one works fine)

<?php 
if(!$_SESSION['username'] && !$_SESSION['password']) {
echo '<span style="border: #000 1px solid; background-color: #CCCCCC">
     <center>Welcome, <b>'.$username.'</b>  
     Redirecting you....</center></span>
     <meta http-equiv="refresh" content="2;URL=pass/index.php" />';
  }
else { echo 'Welcome  '.$_SESSION['username'].'';
}?>

This is the code I trying to use that'll pull the info from the db

<?php 
$query = "SELECT * FROM images WHERE user="$_SESSION[.'username'.]" Order By id";

include("config.php");

$result = mysql_query($query) or die(mysql_error());

mysql_close();

$output = "
<html>
<body>
<table>

<thead>
<td>Id/Order</td>
<td>Address</td>
</tr>
</thead>
";

 

I might mention that the 2nd bit of code works fine when I hard code in a User's ID...so I know that it's seeing the db, it just when I try to re-use the variable of username that I get this error.

Unknown column 'username' in 'where clause

Any suggestions would be great.

Share this post


Link to post
Share on other sites

Well yeah at very least this line is wrong:

 

$query = "SELECT * FROM images WHERE user="$_SESSION[.'username'.]" Order By id";

 

 

To be honest that isn't even valid PHP and I don't understand how that could even be parsed and not return a php error.

 

The line you want would be this:

 

$query = "SELECT * FROM images WHERE user= '$_SESSION[username]' Order By id";

Share this post


Link to post
Share on other sites

Thank you...that solved the error problem that I was having. However, the end result is not what I expected. Rather than only the records that belong to that user, I'm getting a list of all records in the database regardless of who they belong to.

 

Any Suggestions would be appreciated.

 

 

 

 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.