I have a database with a table 'users' with an attribute 'status', set to default '0', and when a user logs in this changes to '1'.
I have then echoed the results of this table with something like so:
Code: Select all
$query=mysql_query("SELECT * FROM userTable;");
echo "<table>";
//while loop for rows
while($rows=mysql_fetch_array($query)){
echo "<tr>";
echo "<td>" . $rows['username'] . "</td>" . "<td>" . $rows['status'] . "</td>";
echo "</tr>";
}To echo the image it's obviously (something like):
Code: Select all
echo '<img src="someLocation/thisImage.jpg">';Thanks in advance for any replies...