mysql query - AND error

[galabin123]

къде ми е грешката при and ?

$query5 = mysql_query("SELECT count(id) as ls `messages` WHERE fromuser='$user' AND unread='$text'");

 

[Ev0luti0N]

$query5 = mysql_result(mysql_query("SELECT count(id) as ls `messages` WHERE fromuser='$user' AND unread='$text'"),0,0);

 

[galabin123]

така се бъгна целия дизайн

 

[baceto90]

$query5 = mysql_query("SELECT count(id) as ls, `messages` WHERE fromuser='$user' AND unread='$text'") or die (mysql_error());

 

[galabin123]

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 'WHERE fromuser='blackbullshit' AND unread='.........

 

[xmmm]

Така? :

$query5 = mysql_query("SELECT count(id) as ls, `messages` WHERE fromuser="'.$user.'" AND unread="'.$text.'"") or die (mysql_error());

 

[baceto90]

Филтрирал ли си $user и $text с addslashes ?

 

[trevata]

Не си указал от коя таблица да SELECT-ва

SELECT
[ALL | DISTINCT | DISTINCTROW ]
[HIGH_PRIORITY]
[STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
select_expr [, select_expr ...]
[FROM table_references
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
[PROCEDURE procedure_name(argument_list)]
[INTO OUTFILE 'file_name' export_options
| INTO DUMPFILE 'file_name'
| INTO @var_name [, @var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]

 

[galabin123]

Филтрирал ли си $user и $text с addslashes ?

не,user ми е сесията а text съм му задал стойност на предишния ред

Не си указал от коя таблица да SELECT-ва

SELECT
[ALL | DISTINCT | DISTINCTROW ]
[HIGH_PRIORITY]
[STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
select_expr [, select_expr ...]
[FROM table_references
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
[PROCEDURE procedure_name(argument_list)]
[INTO OUTFILE 'file_name' export_options
| INTO DUMPFILE 'file_name'
| INTO @var_name [, @var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]

знам че не съм просто искам да извадя броя на съобщенията които са на този юзър + това да са прочетени,по-горе съм го правил но без AND и става