brooksh Posted March 1, 2009 Share Posted March 1, 2009 I want to skip the first row, and display upto the next 6 images. The example I'm using only has 4 images. Even if I change it to LIMIT 1,3 it still displays image2 image3 image4 image2 image3 image4. I just want image2 image3 image4 $sql = "SELECT DISTINCT imagename FROM images WHERE id = '$id' LIMIT 1,6"; $result = mysql_query ($sql); while($row = mysql_fetch_array ($result, MYSQL_ASSOC)) { $result_array[] = $row['thumb_file_name']; } $filename = implode(',',$result_array); Quote Link to comment Share on other sites More sharing options...
landavia Posted March 1, 2009 Share Posted March 1, 2009 can show us whole script!? Quote Link to comment Share on other sites More sharing options...
brooksh Posted March 1, 2009 Author Share Posted March 1, 2009 It was a problem with my script. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.