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); Link to comment https://forums.phpfreaks.com/topic/147398-solved-why-are-my-results-being-doubled/ Share on other sites More sharing options...
landavia Posted March 1, 2009 Share Posted March 1, 2009 can show us whole script!? Link to comment https://forums.phpfreaks.com/topic/147398-solved-why-are-my-results-being-doubled/#findComment-773670 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. Link to comment https://forums.phpfreaks.com/topic/147398-solved-why-are-my-results-being-doubled/#findComment-773676 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.