Re: [PHP]Only 1 Query Result...help. From: _lallous (elias_bachaalany <email protected>)
Date: 10/15/01

try to see the SELECT * FROM table LIMIT max, offset

see the LIMIT syntax.

"Chris Cocuzzo" <cuzo <email protected>> wrote in message
news:002b01c154f3$0a113310$ae687780 <email protected>
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 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>