Re: sql query/displaying results question

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