Trying to add stuff to my cms (PHP help)

[LoneZZ]

I never coded PHP before, but from looking at the cms I managed to make this:
<li class="icon-vip"><a href="/vip">
<?php
$amvip= mysql_query("SELECT * FROM users WHERE username={username}");
$vipam = mysql_fetch_array($amvip);
if($vipam['vip']==0) { echo '<a href="{url}/vip>Buy VIP!</a>'; } else { echo 'Thank you for buying VIP!';}
?>

</a></li>

I get this error:

You must be registered for see links

, I'd like to know how to fix it to start coding more features on my CMS, thanks in advance

 

[Sean]

<?php
 
$amvip = mysql_query("SELECT * FROM `users` WHERE `username`='{username}'");
$vipam = mysql_fetch_array($amvip);
if($vipam['vip'] === 0) {
    echo '<a href="{url}/vip>Buy VIP!</a>';
}
else {
    echo 'Thank you for buying VIP!';
}
 
?>

Try this

 

[LoneZZ]

<?php
 
$amvip = mysql_query("SELECT * FROM `users` WHERE `username`='{username}'");
$vipam = mysql_fetch_array($amvip);
if($vipam['vip'] == 0) {
    echo '<a href="{url}/vip>Buy VIP!</a>';
}
else {
    echo 'Thank you for buying VIP!';
}
 
?>

Try this

Thanks, it fixed the error but I have VIP on my account, so 1 in database, but on the CMS it says Buy VIP, and not Thanks for buying it:

EDIT: there was two "=", I tried only putting one and it worked fine, I put 2 on because I had seen it on an RP CMS and thought it was correct, thanks for your help

 

[Sean]

I edited my original post, copy the code again and try that

 

[LoneZZ]

I edited my original post, copy the code again and try that

Thanks mate, I edited mine, I tried with one "=" and it worked, is it best to use 1 or 3?

 

[Sean]

1 should suffice

 

[LoneZZ]

1 should suffice

Thanks