Re: Only 1 Query Result...help.
| From: | Philip Olson | Date: | Mon, 15 Oct 2001 16:53:57 +0000 |
| Subject: | Re: Only 1 Query Result...help. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-71118@lists.php.net to get a copy of this message | ||
> 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
>