SELECT syntax problem...

[localhost]

whats wrong in the syntax???

$statistics = mysql_query(" SELECT * FROM statistics ,users WHERE statistics.setid='".$no."' '".$a "' ORDER BY statistics.score DESC,statistics.totalscore $limit" );

example...
$a = "AND statistics.userid = users.user_id AND users.user_from = 'mars' ";

i am sure there is np with $no

[Lars_Berg]

if $a contains what you said there should not be any quotes surrounding $a i.e..

" . $no ."'"  . $a "

[nemonoman]

need $a needs a '.' ? (not
.$a "
but
.$a.")

Is $limit a possible problem? What is the symptom that shows you there's a problem? A MySQL errno?

[localhost]

Originally posted by Lars Berg
if $a contains what you said there should not be any quotes surrounding $a i.e..

" . $no ."'"  . $a "

[/B]

that was the problem

thanks guys