Does Not Return Any Data.... query

Pilly

I have a question....Im hoping someone can point me in the right Direction....

I have the query code below. Now I want to show all records but if the query returns no data or is blank/zero then give a value to it so it still shows on the page and doesnt return an error.

Ive tried a few ways, searched the boards and this is a call to all. This is what i reckoned... am i close or nowhere near.

//////////// Query To Get Total Games Played ////////////////////
$query1="Select * FROM Darts_SGS WHERE Darts_SGS.Player='$name'";
mysql_query($query1);
// execute SQL query and get result
$sql_result1 = mysql_query($query1,$connection)
or die("Couldn't execute query1.");
$Total_Games = mysql_num_rows ($sql_result1)

or die ("The query: '$query' did not return any data");
If ($Total_Games == "")
{
$Total_Games = "0";
}
Else
{
}

/////////////////////////////////////////////////////

Pilly

I think ive answered my own question...

$FGames = mysql_result($sql_result5, 0)
or $FGames == "0";

leatherback

Hi,

I modified your code a bit. Should work now (But i am doing this not from my PC.. Can't test anything..):

$query1="Select * FROM Darts_SGS WHERE darts_SGS.Player='$name'"; 

  // execute SQL query and get result 
$sql_result1 = mysql_query($query1,$connection) 
or die("Couldn't execute query1."); 

$Total_Games = mysql_num_rows ($sql_result1) 
or die ("The query: '$query' did not return any data"); 

If ($Total_Games = "0") 
{ 
echo "Why did you look for that! You know we have no results you ....";
} 
Else 
{ 
echo "Hehe, we foun ";
echo $Total_Games;
echo "results";
}

laserlight

mysql_num_rows() returns the number of rows returned.
however, you are checking if it is null.
check if it is 0, e.g.

$query1 = "SELECT * FROM Darts_SGS WHERE Darts_SGS.Player='$name'"; 
// execute SQL query and get result 
$sql_result1 = mysql_query($query1, $connection) 
	OR die("Couldn't execute query1.");
$total_games = mysql_num_rows($sql_result1)
	OR die("The query: '$query1' did not return any data");
if ($total_games == 0) 
{
	//no records returned
}
else
{
	//work with the records
}