Jump to content


Photo

Client Orders after Log-in


  • Please log in to reply
2 replies to this topic

#1 WesL

WesL
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 27 October 2004 - 07:02 AM

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>&nbsp;&nbsp;
      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.

#2 gizmola

gizmola
  • Administrators
  • Advanced Member
  • 4,664 posts
  • LocationLos Angeles, CA USA

Posted 27 October 2004 - 09:06 AM

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";


#3 WesL

WesL
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 27 October 2004 - 11:40 PM

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.








0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users