UPDATE Query displaying duplicate data
Heres the code im currently in progress with:
Cpanel.php: ( http://lockpick.lukeidiot.com/?go=cpanelpreview )
PHP Code:
<p><strong><strong>
<?
$_SESSION['username'] = $username;
echo 'Welcome <b>'. $_COOKIE['username'].'</b><br />'; ?>
<?php
$iplog = $_SERVER['REMOTE_ADDR'];
$sql = mysql_query("SELECT * FROM users");
while($result = mysql_fetch_array($sql)) {
if (!empty($online['id'])){
# Check to see if they're logged in
echo 'Welcome <b>'.stripslashes($online['username']).'</b><br />';
# An example of how to display the browsing members name
}
else {
# Else, they are not logged in.
echo 'You must be logged in to access this page.';
?>
</strong>Profile</strong> | <strong><a href="?go=memberlist">Memberlist</a></strong> | <strong><a href="?go=logout">Logout</a></strong><br>
<strong><br>
Account Type: </strong>Admin/Staff/Moderator/Customer
<strong><br>
Job Position:</strong> <?php echo 'Account type: <b>' .$result['type'] . '</b>'; }?><br>
<strong>Job Status:</strong> Accepted <br>
<strong>Payout</strong>: $<?php echo '<b>'.$result['payout'] . '</b>'; }?><br>
<strong>Signup Date:</strong>
<?=$signup?>
<br />
<strong>IP Logged: </strong><?php echo '$iplog';?><br>
<strong>Resume:</strong> http://lockpick.lukeidiot.com/upload/example.doc</p>
And it displays this:
Quote:
User Selected: Lukeidiot
Account type: AdminAccount type: CustomerAccount type: CustomerAccount type: CustomerAccount type: Customer
Any idea why this is happeing?
Re: UPDATE Query displaying duplicate data
Fist of all, fix all those errors on you page. Several of those errors indicate that the queries may not have been successful. Secondly, there is no update query in your code and it appears to bear no relation to the code you posted.
