[SOLVED] Get field for all entries in table, but breaks when 0 entries. How to fix?

[physaux]

<?php

		$result = mysql_query("SELECT * FROM `MY_FIELD` WHERE field = `".$fieldname."`;", $connection);
		if (!$result) {
			echo "Database query failed: " . mysql_error();//
		}

?>

 

So, my code want to check in the "MY_FIELD", and get all the entries there.

 

I made this code, but It seems to fail. The table has no entries, yet. So I was wondering, how can I "error proof" it so it acts nicely if the table is empty? Right now prints out:

 

Database query failed: Unknown column 'main_name' in 'where clause'

*"main_name"* is the current value of $fieldname right now. This is the current "name" that I would be looking for, but the table is empty.

[mrMarcus]

"acts nicely", how?  what do you want it to do?

[physaux]

Well, first off I want to be able to detect that there are no entries, then not continue with the regular script since it crashes. So, my question rephrased is: How can I detect if a table is empty?