[SOLVED] SQL Handler

[ambo]

Alright basicly my problem is that each user can upload a image to there profile but i only want them to have one image so i have the upload and everything all set. its just i need something that will check if the user has a row in the image table already if he does UPDATE his picture if not just a INSERT INTO

if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)

{

$fileName = $_FILES['userfile']['name'];

$tmpName  = $_FILES['userfile']['tmp_name'];

$fileSize = $_FILES['userfile']['size'];

$fileType = $_FILES['userfile']['type'];

 

$fp      = fopen($tmpName, 'r');

$content = fread($fp, filesize($tmpName));

$content = addslashes($content);

fclose($fp);

$user = $session->username;

if(!get_magic_quotes_gpc())

{

    $fileName = addslashes($fileName);

}

$UPDATE = "UPDATE images SET id ='$user', name='$fileName', size='$fileSize', type='$fileType', content='$content'";

$ADD = "INSERT INTO images (id,name,size,type,content ) ".

"VALUES ('$user', '$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($SET) or die('Error, query failed');

echo "<meta http-equiv=\"refresh\" content=\"0;url=profile.php?user=$user\"/>";

echo "<br>File $fileName uploaded<br>";

 

}

[premiso]

if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
    $user = $session->username;
$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);
if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
}
    
$UPDATE = "UPDATE images SET id ='$user', name='$fileName', size='$fileSize', type='$fileType', content='$content'";
$ADD = "INSERT INTO images (id,name,size,type,content ) ".
"VALUES ('$user', '$fileName', '$fileSize', '$fileType', '$content')";
$sql = "SELECT id FROM images WHERE id = '$user' LIMIT 1";
    $result = mysql_query($sql);
    if (mysql_num_rows($result) > 0) {
         $SET = $UPDATE;
    }else {
         $SET = $ADD;
    }
mysql_query($SET) or die('Error, query failed');
echo "<meta http-equiv=\"refresh\" content=\"0;url=profile.php?user=$user\"/>";
echo "<br>File $fileName uploaded<br>";

} 

 

EDIT:

Modified to do the update instead, mis-read the description...