What's wrong with this PHP code?

[JoshuaLuke]

Hi,

I'm trying to display something on my ME page which is only avalible for non-vip users. I have this code:

 <?PHP
 
if(mysql_result(mysql_query("SELECT `vip` FROM `users` WHERE username='{username}'"), 0) == 1){
 
?>

then I have the message, then after the message I have

<?PHP
}
?>

but it's throwing me an error of

Warning​

: mysql_result() [​

You must be registered for see links

]: Unable to jump to row 0 on MySQL result index 27 in​

C:\xampp\htdocs\app\tpl\skins\Habbo\me.php​

​

on line​

​

165​

How to fix?​

 

[xHissy]

Try this:

<?PHP
 
$query="SELECT `vip` FROM `users` WHERE username='{username}";
    $result = mysql_query($query);
    $row = mysql_num_rows($result);
    if ($row == -0){
?>
'//Stuff here!!!
<?php
    }
    ?>

 

[Thom]

Try this:

<?PHP
 
$query="SELECT `vip` FROM `users` WHERE username='{username}";
    $result = mysql_query($query);
    $row = mysql_num_rows($result);
    if ($row == 1){
?>
'//Stuff here!!!
<?php
    }
    ?>

This isn't even what he is trying to do..

 

[CronicHosts]

How about this?

<?php if($vip = 1)
{
?>
 
Stuff Here
 
<?php
} ?>

Then just create a VIP variables in global.php or some shit.

 

[JoshuaLuke]

Try this:

<?PHP
 
$query="SELECT `vip` FROM `users` WHERE username='{username}";
    $result = mysql_query($query);
    $row = mysql_num_rows($result);
    if ($row != 1){
?>
'//Stuff here!!!
<?php
    }
    ?>

I'm trying to display a message to a non-vip user :L

 

[Snow]

First of all is {username} even defined?

It's supposed to be

<?php
$_username = "Usernamelmaddfdfds";
 
$_q = mysql_query("SELECT vip FROM users WHERE username = '{$_username}'");
 
if (mysql_result($_q) == 1)
{
    //code here
}
?>

 

[xHissy]

This isn't even what he is trying to do..

He is trying to display a message when the user isn't a vip. So my code will work fine?

 

[Dzetki]

Hi,

I'm trying to display something on my ME page which is only avalible for non-vip users. I have this code:

 <?PHP
 
if(mysql_result(mysql_query("SELECT `vip` FROM `users` WHERE username='{username}'"), 0) == 1){
 
?>

then I have the message, then after the message I have

<?PHP
}
?>

but it's throwing me an error of

Warning​

: mysql_result() [​

You must be registered for see links

]: Unable to jump to row 0 on MySQL result index 27 in​

C:\xampp\htdocs\app\tpl\skins\Habbo\me.php​

​

on line​

​

165​

How to fix?​

what about

 <?PHP
 
if(mysql_result(mysql_query("SELECT `vip` FROM `users` WHERE username='{username}'"), 0) == 1) {
echo "
stuff here
";
}
?>

Not sure if this is how you want it tho. But it'll do the trick aslong as you're putting the stuff within the "s.

 

[xHissy]

I'm trying to display a message to a non-vip user :L

The $row == 0 means that if will look in that database for the vip where the name is the user name and if nothing is retruned. (0 rows it will show your message!)

 

[JoshuaLuke]

Try this:

<?PHP
 
$query="SELECT `vip` FROM `users` WHERE username='{username}";
    $result = mysql_query($query);
    $row = mysql_num_rows($result);
    if ($row == -0){
?>
'//Stuff here!!!
<?php
    }
    ?>

I now get

Warning​

: mysql_num_rows() expects parameter 1 to be resource, boolean given in​

​

C:\xampp\htdocs\app\tpl\skins\Habbo\me.php​

​

on line​

​

168​

 

[Thom]

I now get

Warning​

: mysql_num_rows() expects parameter 1 to be resource, boolean given in​

​

C:\xampp\htdocs\app\tpl\skins\Habbo\me.php​

​

on line​

​

168​

You don't need to do mysql_num_rows because you aren't checking how many rows exist.

 

[JoshuaLuke]

Fixed, mod close thread please ^.^

 

[xHissy]

You don't need to do mysql_num_rows because you aren't checking how many rows exist.

Yes you are?, you want to check if they aren't say something. So if rows = 0 display the shit if rows != 0 dont

 

[Thom]

Thread closed upon request