I need to run this query in my plugin:
$sql = ' SELECT zen_images.filename AS filename, zen_images.
desc AS file_desc, zen_album.folder AS folder, zen_images.title AS title'
. ' FROM zen_images AS zen_images'
. ' INNER JOIN zen_albums AS zen_album ON zen_album.id = zen_images.albumid'
. ' WHERE zen_images.show =1'
. ' ORDER BY zen_images.id DESC'
. ' LIMIT 0 , 3';
But for some reason wordpress breaks every attempt i have made to run the above querry (which is perfecly legal, as it runs perfectly in phpmyadmin).
I need to run it, and put the result in an array which i can loop though echoing each returned row.
Can someone please help?