RE: [PHP]Only 1 Query Result...help.

i don't think it's wise to create an array and fill it with one element i would use mysql_fetch_row($result) just my tuppence worth ;-) -----Original Message----- From: Philip Olson [mailto:philip@cornado.com] Sent: 15 October 2001 17:54 To: Chris Cocuzzo Cc: php-general@lists.php.net Subject: Re: [PHP]Only 1 Query Result...help. > but without using a loop to display > just one result If you want just one row : $row = mysql_fetch_array($result); print $row['col']; Regards, Philip Olson On Mon, 15 Oct 2001, Chris Cocuzzo wrote: > maybe I'm an idiot, but I don't understand how that helps in not using a > loop to display the results. Could you explain a little more? > > thanks > chris > > > ----- Original Message ----- > From: "_lallous" <elias_bachaalany@yahoo.com> > To: <php-general@lists.php.net> > Sent: Monday, October 15, 2001 3:30 AM > Subject: Re: [PHP]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 > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net