You have an error in your SQL syntax check the manual that corresponds to your MySQL

[Bala Kumaran]

This is my code

$results = mysql_query("SELECT COUNT(*) as 't_records' FROM `news` domain = '".$domain."' AND menu_name = '".$menu_name."' AND menu_type = '".$menu_type."'") or die(mysql_error());
$total_records = mysql_fetch_assoc($results);
$total_groups = ceil($total_records['t_records']/$items_per_group);

I am getting error from this above code.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 'isaspainstitut e.com' AND menu_name = 'news' AND menu_type = 'news'' at line 1

What was the mistake in my script?

[Luuk]

It's in the manual.... ;)

http://dev.mysql.com/doc/refman/5.6/en/select.html

It says you need 'WHERE' in your SQL-statement.