Re: [PHP] sql query/displaying results question

From: Jason Wong (php-general_at_gremlins.biz)
Date: 10/23/03 

To: php-general@lists.php.net
Date: Thu, 23 Oct 2003 23:45:36 +0800

On Thursday 23 October 2003 22:06, Adam Williams wrote:

> So I will have 1 query that needs to print the document $title at the top
> of the page and then when it starts showing results. I won't know what
> the document title is until the database is queried (because they are
> doing a query for keywords in the documents stored in that table in the
> database). So at the top of the page can I use my $title from the
> database and then when I start showing the results, can I show the same
> document $title from the 1st row returned if I am using a while loop, or
> because I already used $title at the top from the 1st row returned, will
> it want to start at the 2nd row returned when I start my while loop to
> return all of the data?

After displaying $title use mysql_data_seek() to return to start of results
dataset. 

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
------------------------------------------
/*
I learned to play guitar just to get the girls, and anyone who says they
didn't is just lyin'!
		-- Willie Nelson
*/