Изкарване от дб

[kenwood10]

Здравейте на всички това е кодът ми които ми изкарва от дб

$query = "SELECT firm,SUM(win) as obshto,SUM(lost) as obshtozagubi,COUNT(firm) as kolko FROM users WHERE firm != '' GROUP BY firm ORDER BY SUM(win) DESC LIMIT $redove, $broinastranica";

Как да му кажа на този код да изкарва само firm където полето 'read' е = 0 Благодаря ви предварително.Дано сте ме разбрали

 

[dakata__92]

$query = "SELECT firm,SUM(win) as obshto,SUM(lost) as obshtozagubi,COUNT(firm) as kolko FROM users WHERE firm != '' GROUP BY firm ORDER BY SUM(win) DESC LIMIT $redove, $broinastranica" and read='0' ;

 

[kenwood10]

Error, query failed

:!:

 

[Fakeheal]

$query = "SELECT firm,SUM(win) as obshto,SUM(lost) as obshtozagubi,COUNT(firm) as kolko FROM users WHERE firm != '' AND read='0' GROUP BY firm ORDER BY SUM(win) DESC LIMIT $redove, $broinastranica"  ;

 

[kenwood10]

И така пробвах не стана... ето я цялата заявка...

$query = "SELECT firm,SUM(win) as obshto,SUM(lost) as obshtozagubi,COUNT(firm) as kolko FROM users WHERE firm != '' AND read='0' GROUP BY firm ORDER BY SUM(win) DESC LIMIT $redove, $broinastranica"  ;
$result = mysql_query($query) or die('Error, query failed');

 

[emagi]

А каква е точно грешката?

$query = "SELECT firm,SUM(win) as obshto,SUM(lost) as obshtozagubi,COUNT(firm) as kolko FROM users WHERE firm != '' AND read='0' GROUP BY firm ORDER BY SUM(win) DESC LIMIT $redove, $broinastranica"  ;
$result = mysql_query($query) or die([color=red]mysql_error()[/color]);

 

[kenwood10]

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 'read='0' GROUP BY firm ORDER BY SUM(win) DESC LIMIT 0, 25' at line 1

 

[dakata__92]

$query = "SELECT firm,SUM(win) as obshto,SUM(lost) as obshtozagubi,COUNT(firm) as kolko FROM users WHERE firm != '' GROUP BY firm ORDER BY SUM(win) and read='0' DESC LIMIT $redove, $broinastranica " ;

 

[kenwood10]

$query = "SELECT firm,SUM(win) as obshto,SUM(lost) as obshtozagubi,COUNT(firm) as kolko FROM users WHERE firm != '' GROUP BY firm ORDER BY SUM(win) and read='0' DESC LIMIT $redove, $broinastranica " ;

+1