two columns

[seby]

my query doesn't seem to be getting the right results. I want to get the total rows where two columns have the same value.

$total = mysql_fetch_array(mysql_query("SELECT COUNT(*) AS total FROM `details` WHERE details.min='details.max'"));

it comes up with really high numbers.. any ideas?

[ksandom]

Try:

$total = mysql_fetch_array(mysql_query("SELECT COUNT(*) AS total FROM `details` WHERE details.min=details.max"));