I am having an issue adding the potd to an external html file.
I would greatly appreciate any help on getting this to work in the next few days.
I see that an earlier post it says something about the random image mod. However I do not know if this needs to be used as the randmon image is already included with the gallery.
I have potd working on the directory it was installed, but just can not get it to call the potd to an external page in the root directory.
I have added the potd.php to the root directory and made changes as I saw them in the forum and still get an error and have no idea on why.
I can only see an error if I use it in a .php page the I created just to see the error.
I know nothing about php but have someone helping me with it. This is the error I get:
DB Error: Bad SQL Query: SELECT a.image_id, a.cat_id, a.image_name, a.image_active, a.image_thumb_file, a.image_comments, a.image_comments, a.image_downloads, a.image_votes, a.image_rating, a.image_hits FROM gallery_images a, gallery_categories b WHERE a.image_active=1 AND a.cat_id = b.cat_id AND b.auth_viewcat=0 AND b.auth_viewimage=0 ORDER BY DESC LIMIT 1
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 'DESC LIMIT 1' at line 4
Selected by rates
Now I originally set it up to post the potd by "hits" so I am not sure if this is why I am getting the error.
SLL if you are willing to help, maybe even get this working for me I can pay you for it. You just have to send me a PM on how much and how to pay you. I am limited on how much I can pay, but still let me know and I will return the PM as soon as I can.