Can't get this to work SELECT WHERE

[bengt]

$result = mysql_query("SELECT *,DATE_FORMAT(lastlogin,'%d-%m-%y %H:%i') as datum FROM users WHERE active='' or approved='' ORDER BY uid LIMIT $limitvalue,$nrrowsuser") or die("Failure");

I don't get any failures, and I don't get any result...

approved and active is in the table INT(2) and contains NULL or 1

Changed approved and active to NOT NULL in the table

[bubblenut]

Always, always, always place your query into a variable first so you can echo it out and see what's going on when things (inevitably) go wrong.

$sql="SELECT *,DATE_FORMAT(lastlogin,'%d-%m-%y %H:%i') as datum FROM users WHERE active='' or approved='' ORDER BY uid LIMIT $limitvalue,$nrrowsuser";
$res=mysql_query($sql);

It could be one of a few things, the easiest way to find out is to take a look at exactly what's being run and prehapse run it yourself from the command line.

HTH
Bubble