Re: Only 1 Query Result...help.

try to see the SELECT * FROM table LIMIT max, offset see the LIMIT syntax. "Chris Cocuzzo" <cuzo@mediaone.net> wrote in message news:002b01c154f3$0a113310$ae687780@webs224... hey- I'm trying to put together a photo album system with next/previous buttons that displays one picture at a time, and obviously the user has to click through the buttons to navigate the pictures. I'm using this line for the query $picquery = "SELECT picid,path,width,height FROM pics WHERE id = $id"; normally to display results I'd use the mysql_fetch_array function and print it out like: $picdata[src]; what i was wondering if there's another function that I can use that'll stick the results into an array or some other organized data structure so I can display them, but without using a loop to display just one result thanks chris