On Mon, 20 Aug 2001 15:05, Chris Schneck wrote:
> Thanks to CC Zona and David Robley for their help in gettin this code
> out. This code is really nice for satisfying search engines. It offers
> different page content every time you refresh and if you feel like
> spamming, just use print_keywords(); here and there to be more relevant
> :) I'll post the code in case anyone else wishes to use it.
>
> // get the keywords from db
> $keyquery = ("select fld_keyword_word from tbl_keyword order by
> rand()");
> $keyresult = mysql_query($keyquery) or die ("couldnt randomize
> words");
>
> // put them into an array
> while ($keyrow = mysql_fetch_array($keyresult))
> {
> $keyword[] = $keyrow["fld_keyword_word"];
> }
> $mykeywords = implode(", ", $keyword);
>
> // print the keywords with a function
> function print_keywords()
> {
> global $mykeywords;
> echo ($mykeywords);
> }
Oh, is that what you wanted to do? Lets cut the processing down by
eliminating the duplication of effort :-) ie get rid of the 'Put it in an
array; take it out of an array;print it'.
// get the keywords from db
$keyquery = ("select fld_keyword_word from tbl_keyword order by rand()");
$keyresult = mysql_query($keyquery) or die ("couldnt randomize words");
// Print the keywords
while($row = mysql_fetch_array($result)) {
extract $row;
echo $fld_keyword_word;
}
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
To a cat, "NO!" means "Not while I'm looking."
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
