RE: [PHP]Only 1 Query Result...help. From: Matthew Loff (matt <email protected>)
Date: 10/15/01

SELECT * FROM pics LIMIT 0, 1 --> You'll get the first photo.
SELECT * FROM pics LIMIT 1, 1 --> You'll get the second photo.
SELECT * FROM pics LIMIT 2, 1 --> You'll get the third photo.
SELECT * FROM pics LIMIT 3, 1 --> You'll get the fourth photo.

To retrieve the single row, you can do this:

if(extract( <email protected>( <email protected>("SELECT * FROM pics LIMIT
0,1"))))
{
        // code to print out picture
} else {
        // no picture was retrieved (for some reason)
}

I haven't tested this, but you get the idea.... If you're only
returning one row from the query, you can call mysql_fetch_assoc()
directly on the result of the mysql_query() call.

I added extract() in there, since it will convert the associative array
to global variables, e.g.:

$array['item'] = "this is an item"
$array['blah'] = "foo"

extract($array);

Would produce:

$item = "this is an item"
$blah = "foo"

-----Original Message-----
From: Chris Cocuzzo [mailto:cuzo <email protected>]
Sent: Monday, October 15, 2001 12:43 PM
To: php-general <email protected>
Subject: Re: [PHP]Only 1 Query Result...help.

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 <email protected>>
To: <php-general <email protected>>
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 <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>
> 

-- 
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>

-- 
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>