mysql num rows not working?

[MDanz]

It should echo "test" because there are no results that match the query, instead it echo's "offwal"?

 

<?php

mysql_connect("localhost", "Master", "pword");
mysql_select_db("db");

$officialwallpaper = mysql_query("SELECT wallpaper, MAX(points) FROM Contribute WHERE stack LIKE '%test%'")or die (mysql_error());

while($wallrow = mysql_fetch_array( $officialwallpaper)) {

$offwall = $wallrow['wallpaper'];
}
$officialfound = mysql_num_rows($officialwallpaper);

if($officialfound==0) {


echo "test";
} else {
  echo "offwall";

}






?>

[Mchl]

This query will always return one row.

[MDanz]

i'm sure the code is correct?  how do i change the if statement then..  if no results match the query it should echo "test".

[Mchl]

Perhaps you should first do something with your query. As it is now it doesn't return reliable results.

What it's supposed to do?

[MDanz]

Perhaps you should first do something with your query. As it is now it doesn't return reliable results.

What it's supposed to do?

 

select the wallpaper and the MAX points where the keyword is "test".

 

 

perhaps i should put the MAX points in the WHERE clause?

[Mchl]

No. You should do it like this.

SELECT wallpaper, points FROM Contribute WHERE stack LIKE '%test%' ORDER BY points DESC LIMIT 1

[MDanz]

thx got it working