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.
Any suggestions would be great.