PDA

Click to See Complete Forum and Search --> : UPDATE Query displaying duplicate data


Lukeidiot
May 12th, 2008, 12:19 AM
Heres the code im currently in progress with:

Cpanel.php: ( http://lockpick.lukeidiot.com/?go=cpanelpreview )

<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:
User Selected: Lukeidiot
Account type: AdminAccount type: CustomerAccount type: CustomerAccount type: CustomerAccount type: Customer

Any idea why this is happeing?

visualAd
May 12th, 2008, 01:53 AM
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.