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
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
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?
Ako hvatas male ribice, mozes da ostanes u plicaku, za veliku ribu, moras da zagazis dublje !