Originally Posted by gonzek (Post 2257200)

Hi,

anybody knows something about hack like this for vb 4.x?

Originally Posted by floggerss (Post 2163267)

I get this errror

SELECT album.*,
> picture.pictureid, picture.extension, picture.idhash,
> picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
> user.*
> FROM album AS album
> LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
> LEFT JOIN user AS user ON (album.userid = user.userid)
> WHERE album.state IN ('public', 'private', 'profile')
> ORDER BY
> LIMIT 0, 10;
>
> MySQL Error : 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 'LIMIT 0, 10' at line 10
> Error Number : 1064
> Request Date : Sunday, February 13th 2011 @ 02:35:14 PM
> Error Date : Sunday, February 13th 2011 @ 02:35:15 PM
> Script : http://stylers.com.ar/all_albums.php
> Referrer :

Originally Posted by BirdOPrey5 (Post 2282566)

The problem is the SQL statement is missing something after "ORDER BY" it should be ORDER BY _field_name_ of some sort, not sure what off hand though.