[PHP] sql query/displaying results question
I have a php page I am writing with an SQL query. I am going to query the database for a couple of fields. One of the fields I am querying is the title oh the document someone is searching for. The title will be used at the top of the html page and will say: you are searching for document number ###: document $title but then later on down on the page when it starts returning your results: document $title: document $location 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? Adam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 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 */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php