"if query empty" syntax

[kilbey1]

I want to throw a statement like "No records found" if the query result is empty. What is the correct command and/or syntax to do this (either with or without a while loop).

[kaos057]

$result = mysql_query("SELECT * FROM table")
if ($myrow = mysql_fetch_row($result)) {
// code here
} else {
print "No records found";
}

Hope that helps.

[kilbey1]

It does; however, I've already got it set up in a WHILE loop (within a while loop, within another while loop). What I'd really like to do is stop the while loop if there is no such query returned in the very first query (ie. if($empty($result)) { $echo "No such skill."; break; }. If there is something existing, continue on your merry way... go through second loop, stop if nothing found... etc.

					$sql = "SELECT *
					FROM placement_primarytech
					WHERE PrimaryTechnology LIKE '$Searchbox'
					";
					$result = mysql_query($sql);
					while($row=mysql_fetch_array($result)) {
						echo $row['PrimaryTechID'] . " - " . $row['PrimaryTechnology'] . "<BR>";

					$sql2="SELECT *
					FROM placement_primarytech,placement_candidatetech
					WHERE placement_candidatetech.PrimaryTechID = placement_primarytech.PrimaryTechID
					AND placement_primarytech.PrimaryTechnology LIKE '$Searchbox'";
					$result2 = mysql_query($sql2);


					while($row2=mysql_fetch_array($result2)) {

						echo "&nbsp;&nbsp;" . $row2['PrimaryTechID'] . " - " . $row2['PrimaryTechnology'] . "<BR>";

						$sql3 = "SELECT *
						FROM placement_candidatetech,placement_candidate, placement_primarytech
						WHERE placement_candidatetech.CandidateID = placement_candidate.CandidateID
						AND
						placement_primarytech.PrimaryTechID = placement_candidatetech.PrimaryTechID
						AND
						placement_primarytech.PrimaryTechnology LIKE '$Searchbox'";
						$result3 = mysql_query($sql3);

						while($row3=mysql_fetch_array($result3)) {
							echo "&nbsp;&nbsp;&nbsp;&nbsp;" . $row3['CandidateID'] . " - " . $row3['FirstName'] . "<BR>";
						}

					}


				}		

[kilbey1]

Perhaps this would work?

					$num_rows = mysql_num_rows($result);
					if($num_rows == 0) {
						echo "$num_rows Results.\n";
						break;
					}

EDIT: Except I discovered it's not as easy as this. 🙂 I get the error:
Fatal error: Cannot break/continue 1 levels