getting one instance of a record

[morgn]

hi
im want to get the first instance of a row of data from a database rather than all the rows which are equal to the name field:

$q3 = "SELECT * FROM customer_vote WHERE aco_name = '$co_name'";
				 $r3 = mysql_query($q3);

			while ($row = mysql_fetch_array($r3))
			{
				$aco_name = $row["aco_name"];
}

this returns all of the instances of aco_name. i just want one.
can you tell me the method i should be using?

cheers,
morgn.

[bubblenut]

replace while with if

[LordShryku]

Or tack a LIMIT 1 on the end of your sql statement.