SQL Syntax Error

Quote:

---

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

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):

Code:

---

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.

Quote:

---

Originally Posted by grynmoors

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:

:lol:

ffmpeg-php is not installed with GD support.