SQL Syntax Error

[olrac]

ERROR: Unable to execute query

SELECT * FROM video WHERE type='public' AND active=1 AND approve=1 ORDER BY addtime DESC LIMIT 0,

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 '' at line 1

How do I fix it?

Thank you

[grynmoors]

I don't know if this matters, but try putting single quotes around the numbers like this (and anywhere else single or regular quotes, commas and junk like that belong):

WHERE type = 'public' AND approve = '1' AND active= '1'

I know from experience if you miss so much as one tiny little comma or a single quote, things blow up.

[SportsGamingTV.com]

things blow up.

Which is why I like to have someone else start my computer when I have been working on the web site. :mrgreen:

[grynmoors]

:lol:

[Grace1]

ffmpeg-php is not installed with GD support.