kuci radi a na netu ne

[ sheik @ 18.12.2006. 10:48 ] @

Ljudi pomagajte,
Ja sam ovde pocetnik sa PHP om i MySQl om i imam sledeci problem:
kod:

Code:
SELECT photoID
FROM votes
WHERE number_of_votes = (
SELECT max( number_of_votes )
FROM votes )
LIMIT 1

Na kucnom racunaru gde imam instaliran WAMP radi perfektno, tj iz tabele votes izvlaci "photoID" sa maksimalnim "number_of_votes", medjutim kada to prebacim na net
dobijem:

Citat:

SQL-query :

SELECT photoID
FROM votes
WHERE number_of_votes = (
SELECT max( number_of_votes )
FROM votes )
LIMIT 1

MySQL said:

#1064 - You have an error in your SQL syntax near 'SELECT max( number_of_votes )
FROM votes )
LIMIT 1 ' at line 4

O cemu se radi?

[ Tyler Durden @ 18.12.2006. 13:11 ] @

Jel ti to ne radi na bazi od hosting provajdera?
Moguće da imaju stariju verziju MySQL-a koja ne podržava podupite.