How would you phrase this?

Anon

Hello. Check this out:
$db = mysql_connect("localhost");
mysql_select_db("saintparis", $db);
$sql = "select * from general where paying='Yes' && paying1='No'";
$result = mysql_query($sql);
if ($result == "False"){
print("Sorry there are no new clients");
}
while ($row = mysql_fetch_array($result)) {

I want it to display that message if there is no entrys. The rest is code that works. The DB makes a solid connection everything works niceley. But how do I use the If to see if $result has anything behind it? Thanks!
Ziggs

interactive

mysql_num_rows($result);
if($result<1)
{
echo "sorry there are no new clients";
}
?> i hope that works happy coding!

Anon

I think it works. I had a client come already. 🙂 So I wouldn't know till I get them cleared out. Thanks though!
Ziggs

Anon

Nope no love on that one. Didn't work.
Ziggs

rrijnders

From the PHP manual:

"mysql_query() returns TRUE (non-zero) or FALSE to indicate whether or not the query succeeded. A return value of TRUE means that the query was legal and could be executed by the server. It does not indicate anything about the number of rows affected or returned. It is perfectly possible for a query to succeed but affect no rows or return no rows."

This means that you can not check $result as an indicator of how many rows your query retrieved.

Do this instead:

db = mysql_connect("localhost");
mysql_select_db("saintparis", $db);
$sql = "select * from general where paying='Yes' && paying1='No'";
$result = mysql_query($sql);
if (!$result){
  print("Bad SQL or Authorization Problem");
}
else {
 if (mysql_num_rows($result) < 1) {
  print("Sorry there are no new clients");
 }
 else {
  // process result set
 }
}

HTH
-- Rich Rijnders
-- Irvine CA US

Anon

works like a charm nice work thank you!
Ziggs