|
|
Posted by Chris H on 03/25/06 10:33
ok well i ended up fixing it just by moving the while loop in between the
meta tag and just echo teh keyword results
"Chris H" <lppa2004@insightbb.com> wrote in message
news:er4Vf.638801$084.399613@attbi_s22...
> Ok in the following code I am trying to have my keywards meta tag auto
> insert the top 10 titles from most recently added database entries, right
> now the while loop is only setting the $keyword varibale with one title
> and not the top 10.. not sure what i am doing wrong...
>
> Note: keyword retrival code will be between
> ########
> //comment
> CODE
> #######
>
> PHP CODE HERE--------
> <?php
>
> require ('config.php');
>
> if (!function_exists('connect_to_mysql')){
>
> function connect_to_mysql(){
>
> global $db_location,$db_username,$db_password,$db_database;
>
> $conn =
> mysql_connect("$db_location","$db_username","$db_password");
> if (!$conn) die("Error: " . mysql_error());
> mysql_select_db($db_database,$conn) or die("Error: " .
> mysql_error());
>
> return;
> }
> }
>
> if (!function_exists('error_message')){
>
> function error_message($text){
>
> echo"<p align='left' class='errortext'><br><b><span
> style='background-color: #FF6666'>Error:</span></b><br>$text</p>";
>
> return;
>
> }
>
> }
> ################################################################################
>
> function list_all($cat,$sortby,$char,$page,$pageprev,$search){
> global $title,$site_domain,$keywords;
>
> $limit = 25;
> #####################################################################
> // GETTING KEYWORDS HERE
> $query_kwds = "SELECT * FROM moviedb ORDER BY date ASC";
> $result_kwds = mysql_query($query_kwds);
> while($rs = mysql_fetch_array($result_kwds)) {
> $akey = $rs['title'];
> //$akey = "$mtitle, ";
> }
> ##################################################################
> if(!$page){
> $page = 1;
> }
>
>
> $how_many = mysql_num_rows(mysql_query("SELECT * FROM moviedb"));
> echo "<HTML><head><title>$title</title>
> <meta name=\"keywords\" content=\"$keywords, $akey\">
> <meta name=\"description\" content=\"$desc\"></HEAD>";
> echo "<table width=\"820\" border=\"0\" cellspacing=\"0\"
> cellpadding=\"0\">";
> echo "<tr><td><center><font size=\"6\"><a
> href=\"$site_domain\">$title</a></font></center></td></tr>";
> echo "<tr><td><center>Currently $how_many movies in
> database</center></td></tr>";
> echo "<tr><td><center><br>";
> echo quick_links();
> echo "</center></td></tr>";
> echo "</table>\n";
> echo "<table width=\"820\" border=\"1\" cellspacing=\"0\"
> cellpadding=\"0\">";
> echo "<tr>";
> echo "<th width=\"35\" bgcolor=\"66ccff\"></th>";
> echo "<th width=\"400\" bgcolor=\"66ccff\"><strong><a
> href=\"index.php?t=&sortby=title\">Movie Title</a> </strong></th>";
> echo "<th width=\"260\" bgcolor=\"66ccff\"><strong><a
> href=\"index.php?t=&sortby=rating\">Rating</a></strong></th>";
> echo "<th width=\"125\" bgcolor=\"66ccff\"><strong><a
> href=\"index.php?t=&sortby=cat\">Genre</a></strong></th>";
> echo "</tr>";
>
> connect_to_mysql();
>
>
>
> $limitvalue = $page * $limit - ($limit);
>
> if ($sortby == "") {
> $sql = mysql_query("SELECT * FROM moviedb ORDER BY title ASC LIMIT
> $limitvalue, $limit");
> $q_count = mysql_query("SELECT * FROM moviedb");
> $totalrows = mysql_num_rows($q_count);
> $plink = "";
> }
> elseif ($sortby == "recent") {
> $sql = mysql_query("SELECT * FROM moviedb WHERE date LIKE '%-%' ORDER BY
> date DESC LIMIT $limitvalue, $limit");
> $q_count = mysql_query("SELECT * FROM moviedb WHERE date LIKE '%-%'");
> $totalrows = mysql_num_rows($q_count);
> $plink = "&sortby=recent";
> }
> elseif ($sortby == "alpha") {
> $sql = mysql_query("SELECT * FROM moviedb WHERE alpha LIKE '$char' ORDER
> BY title ASC LIMIT $limitvalue, $limit");
> $q_count = mysql_query("SELECT * FROM moviedb WHERE alpha LIKE '$char'");
> $totalrows = mysql_num_rows($q_count);
> $plink = "&sortby=alpha&char=$char";
> }
> elseif ($sortby == "genre") {
> $sql = mysql_query("SELECT * FROM moviedb WHERE cat LIKE '$cat' ORDER BY
> title ASC LIMIT $limitvalue, $limit");
> $q_count = mysql_query("SELECT * FROM moviedb WHERE cat LIKE '$cat'");
> $totalrows = mysql_num_rows($q_count);
> $plink = "&sortby=genre&cat=$cat";
> }
> elseif ($sortby == "title") {
> $sql = mysql_query("SELECT * FROM moviedb ORDER BY title ASC LIMIT
> $limitvalue, $limit");
> $q_count = mysql_query("SELECT * FROM moviedb");
> $totalrows = mysql_num_rows($q_count);
> $plink = "&sortby=title";
> }
> elseif ($sortby == "rating") {
> $sql = mysql_query("SELECT * FROM moviedb ORDER BY rating DESC LIMIT
> $limitvalue, $limit");
> $q_count = mysql_query("SELECT * FROM moviedb");
> $totalrows = mysql_num_rows($q_count);
> $plink = "&sortby=rating";
> }
> elseif ($sortby == "cat") {
> $sql = mysql_query("SELECT * FROM moviedb ORDER BY cat ASC LIMIT
> $limitvalue, $limit");
> $q_count = mysql_query("SELECT * FROM moviedb");
> $totalrows = mysql_num_rows($q_count);
> $plink = "&sortby=cat";
> }
> if ($search != "") {
> $sql = mysql_query("SELECT * FROM moviedb WHERE title LIKE '%$search%'
> ORDER BY title ASC LIMIT $limitvalue, $limit");
> $q_count = mysql_query("SELECT * FROM moviedb WHERE title LIKE
> '%$search%'");
> $totalrows = mysql_num_rows($q_count);
> $plink = "&search=$search";
> }
>
> $bgcolor = "#E0E0E0"; // light gray
> $result = $sql;
> $z = 1;
> while($rs = mysql_fetch_array($result)) {
> if ($bgcolor == "#E0E0E0"){
> $bgcolor = "#FFFFFF";
> }else{
> $bgcolor = "#E0E0E0";
> }
> $alpha = $rs['alpha'];
> $title = $rs['title'];
> $link = $rs['link'];
> $rating = $rs['rating'];
> $ratingf = format_rating($rating);
> $category = $rs['cat'];
> $stars = get_stars($rating);
>
> echo "<tr>";
> echo "<td width=\"35\" bgcolor=\"$bgcolor\"><center>$z</center></td>";
> echo "<td width=\"400\" bgcolor=\"$bgcolor\"><a
> href=\"$link\">$title</a></td>";
> echo "<td width=\"260\" bgcolor=\"$bgcolor\">$stars ($ratingf)</td>";
> echo "<td width=\"125\"
> bgcolor=\"$bgcolor\"><center>$category</center></td>";
> echo "</tr>\n";
> $z++;
> }
>
> echo "</table>\n";
> echo "<table border=\"0\" width=\"820\">\n";
> echo "<tr>\n";
> echo "<td width=\"100%\">\n";
> echo "<center>\n";
>
> if($page != 1){
> $pageprev = $page - 1;
>
> echo("<a
> href=\"index.php?t=$plink&page=$pageprev\">PREV".$limit."</a> ");
> }else{
> echo("PREV".$limit." ");
> }
>
> $numofpages = $totalrows / $limit;
>
> for($i = 1; $i <= $numofpages; $i++){
> if($i == $page){
> echo($i." ");
> }else{
> echo("<a href=\"index.php?t=$plink&page=$i\">$i</a> ");
> }
> }
>
>
> if(($totalrows % $limit) != 0){
> if($i == $page){
> echo($i." ");
> }else{
> echo("<a href=\"index.php?t=$plink&page=$i\">$i</a> ");
> }
> }
>
> if(($totalrows - ($limit * $page)) > 0){
> $pagenext = $page + 1;
>
> echo("<a
> href=\"index.php?t=$plink&page=$pagenext\">NEXT".$limit."</a>");
> }else{
> echo("NEXT".$limit);
> }
> echo "</center>\n";
> echo "</td>\n";
> echo "</tr>\n";
>
> return;
>
> }
>
> //was browse_by_cat()
> function quick_links(){
>
> print <<<EOF
> <center>
> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse:
> collapse" bordercolor="#111111" width="820" id="AutoNumber1">
> <tr>
> <td width="100">
> <form action='$_SERVER[PHP_SELF]' method='get' name="form">
> <input type='hidden' name='t' value=''>
> <input type='hidden' name='sortby' value='genre'>
> <select name="cat" size="1" id="cat" onchange="this.form.submit();">
> <option value="" selected>Browse By Genre</option>
> <option value="action">Action</option>
> <option value="adventure">Adventure</option>
> <option value="animation">Animation</option>
> <option value="biography">Biography</option>
> <option value="comedy">Comedy</option>
> <option value="crime">Crime</option>
> <option value="documentary">Documentary</option>
> <option value="drama">Drama</option>
> <option value="educational">Educational</option>
> <option value="family">Family</option>
> <option value="fantasy">Fantasy</option>
> <option value="horror">Horror</option>
> <option value="music">Music</option>
> <option value="musical">Musical</option>
> <option value="mystery">Mystery</option>
> <option value="romance">Romance</option>
> <option value="scifi">Sci-Fi</option>
> <option value="short">Short</option>
> <option value="sport">Sport</option>
> <option value="tv">Television</option>
> <option value="thriller">Thriller</option>
> <option value="war">War</option>
> <option value="western">Western</option>
> </select>
> </form>
> </td>
> <td width="150">
> <form action='$_SERVER[PHP_SELF]' method='get'>
> <input type='hidden' name='t' value=''>
> <input type='hidden' name='sortby' value='alpha'>
> <select name="char" size="1" onchange="this.form.submit();" id="char" >
> <option value="" selected>Browse Alphabetically</option>
> <option value="#" >Number</option>
> <option value="a" >A</option>
> <option value="b" >B</option>
> <option value="c" >C</option>
> <option value="d" >D</option>
> <option value="e" >E</option>
> <option value="f" >F</option>
> <option value="g" >G</option>
> <option value="h" >H</option>
> <option value="i" >I</option>
> <option value="j" >J</option>
> <option value="k" >K</option>
> <option value="l" >L</option>
> <option value="m" >M</option>
> <option value="n" >N</option>
> <option value="o" >O</option>
> <option value="p" >P</option>
> <option value="q" >Q</option>
> <option value="r" >R</option>
> <option value="s" >S</option>
> <option value="t" >T</option>
> <option value="u" >U</option>
> <option value="v" >V</option>
> <option value="w" >W</option>
> <option value="x" >X</option>
> <option value="y" >Y</option>
> <option value="z" >Z</option>
> </select>
> </form>
> </td width="200">
> <td><form action='$_SERVER[PHP_SELF]' method='get'>
> <input type='hidden' name='t' value=''>
> <select name="sortby" size="1" onchange="this.form.submit();" id="char" >
> <option value="" selected>Misc. Actions</option>
> <option value="" >Show All Titles</option>
> <option value="recent" >Show Recently Added</option>
> <option value="title" >Sort By Movie Title </option>
> <option value="rating" >Sort Rating Column </option>
> <option value="cat" >Sort Genre Column </option>
>
> </select>
> </form></td>
> <td width="350" align="left">
> <form action='$_SERVER[PHP_SELF]' method='get'>
> <input type='hidden' name='t' value=''>
> Search Titles <input type="text" name="search">
> <input type="submit" value="Search">
>
> </select>
> </form>
> </td>
> </tr>
> </table>
> </center>
> EOF;
>
> return;
> }
>
> function format_rating($rating){
>
> if ($rating == "01") { $ratingf= "1"; }
> elseif ($rating == "02") { $ratingf= "2"; }
> elseif ($rating == "03") { $ratingf= "3"; }
> elseif ($rating == "04") { $ratingf= "4"; }
> elseif ($rating == "05") { $ratingf= "5"; }
> elseif ($rating == "06") { $ratingf= "6"; }
> elseif ($rating == "07") { $ratingf= "7"; }
> elseif ($rating == "08") { $ratingf= "8"; }
> elseif ($rating == "09") { $ratingf= "9"; }
> elseif ($rating == "10") { $ratingf= "10"; }
> return $ratingf;
> }
>
> function get_stars($rating){
> global $star, $hstar;
>
> if ($rating == 1) { $stars="<img src=$star>"; }
> elseif ($rating == 2) { $stars="<img src=$star><img src=$star>"; }
> elseif ($rating == 3) { $stars="<img src=$star><img src=$star><img
> src=$star>"; }
> elseif ($rating == 4) { $stars="<img src=$star><img src=$star><img
> src=$star><img src=$star>"; }
> elseif ($rating == '5') { $stars="<img src=$star><img src=$star><img
> src=$star><img src=$star><img src=$star>"; }
> elseif ($rating == '6') { $stars="<img src=$star><img src=$star><img
> src=$star><img src=$star><img src=$star><img src=$star>"; }
> elseif ($rating == '7') { $stars="<img src=$star><img src=$star><img
> src=$star><img src=$star><img src=$star><img src=$star><img
> c=$star>"; }
> elseif ($rating == '8') { $stars="<img src=$star><img src=$star><img
> src=$star><img src=$star><img src=$star><img src=$star><img src=$star><img
> src=$star>"; }
> elseif ($rating == '9') { $stars="<img src=$star><img src=$star><img
> src=$star><img src=$star><img src=$star><img src=$star><img src=$star><img
> src=$star><img src=$star>"; }
> elseif ($rating == '10') { $stars="<img src=$star><img src=$star><img
> src=$star><img src=$star><img src=$star><img src=$star><img src=$star><img
> src=$star><img src=$star><img src=$star>"; }
> return $stars;
> }
>
>
>
> ################################################################################
>
>
> ?>
>
Navigation:
[Reply to this message]
|