Help: homepage

[HiDeo]

My query don't work

PHP Code:

SELECT * FROM " . TABLE_PREFIX ."user WHERE homepage IS NULL 


Can you help me ?

Thanks

[Dean C]

Are you running this within a script or phpmyadmin? Also what is the error you receieve?

[HiDeo]

I use this in a .php file !

I have no errors but no results :s

[Dean C]

Well show me the PHP code

[Floris]

I have no errors

Then the query is correct, but the content might be empty or the function after it ísn't correct.

[HiDeo]

PHP Code:

$querys = $DB_site->query("SELECT * FROM " . TABLE_PREFIX ."user WHERE homepage IS NULL");
while ($query = $DB_site->fetch_array($querys))
{    
$nom .= "<div>$query[username]</div>";
} 


[HiDeo]

Nobody ????

[Dean C]

Use this and tell me what it outputs at the top of the page:

PHP Code:

 $querys = $DB_site->query("SELECT * FROM " . TABLE_PREFIX ."user WHERE homepage IS NULL");
if($DB_site->num_rows($querys))
{
        echo 'We have results';
        while ($query = $DB_site->fetch_array($querys))
        {    
                $nom .= "<div>$query[username]</div>";
        }
}
else
{
        echo 'No results';
} 


[HiDeo]

Thanks, I'll test and gove the answer !