IF , THEN statement... HELP!

[kpowning]

Ok, I'm trying to run part of my script that will query my table and select 'vimage' from my users username..
If the column vimage (varchar) is empty, then echo "please submit your vehicles image";

If column vimage has anything in it, then echo "you have already uploaded an image";

I CAN'T GET THIS TO WORK... ANYHELP GREATLY APPRECIATED...

Here is my script:

$chkvimage = mysql_query("Select vimage FROM membersrigs WHERE Username='$username'");
$vimage_check = mysql_num_rows($chkvimage);
	if ($vimage_check ="''") {
    $msg = "Please upload vehicle image";
} else {
    $msg = "you have already uploaded your image";
}

[tserbis]

$chkvimage = mysql_query("Select vimage FROM membersrigs WHERE Username='$username'");
if ( mysql_num_rows($chkvimage) ) {
$vimage_check = mysql_fetch_array($chkvimage);
};

if ( '' == $vimage_check['vimage '] ) { 
$msg = "Please upload vehicle image"; 

} else {
$msg = "you have already uploaded your image";
}

[kpowning]

YOU ARE AWESOME... THANKS A TON!!

IT WORKS 🙂