WesL Posted October 27, 2004 Share Posted October 27, 2004 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. Link to comment https://forums.phpfreaks.com/topic/2026-client-orders-after-log-in/ Share on other sites More sharing options...
gizmola Posted October 27, 2004 Share Posted October 27, 2004 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"; Link to comment https://forums.phpfreaks.com/topic/2026-client-orders-after-log-in/#findComment-6622 Share on other sites More sharing options...
WesL Posted October 27, 2004 Author Share Posted October 27, 2004 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. Link to comment https://forums.phpfreaks.com/topic/2026-client-orders-after-log-in/#findComment-6624 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.