Help: homepage

[HiDeo]

My query don't work :(

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]

$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:


$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 !