SMS- Comments for '$name'\n"; echo "\n\n"; include("body.php"); /* declare some relevant variables */ include("db.inc.php"); $table = "alex_comments"; $today = date("Y-m-d"); /* make connection to database */ $myconn = MYSQLI_CONNECT($hostname,$username,$password,$dbName) OR DIE("Unable to connect to database"); //@mysql_select_db("$dbName") or die("Unable to select database"); /* just a simple check to see if it went in */ $query = "SELECT * FROM $table WHERE(name = '$name') AND active = '1' ORDER BY date_added DESC;"; $result = MYSQLI_QUERY($myconn, $query); $number = MYSQLI_NUM_ROWS($result); echo "$number reviews by $name..
\n\n"; //echo "\n"; $i = 0; IF ($number == 0) : PRINT "

No comments for \"$name\".

\n\n"; ELSEIF ($number > 0) : WHILE ($i < $number): $name = mysqli_result($result,$i,"name"); $email = mysqli_result($result,$i,"email"); $comment = mysqli_result($result,$i,"comment"); $rating = mysqli_result($result,$i,"rating"); $game_title = mysqli_result($result,$i,"game_title"); $game_id = mysqli_result($result,$i,"game_id"); $date_added = mysqli_result($result,$i,"date_added"); $namequery = "SELECT game_title FROM alex_games WHERE(ID = '$game_id');"; $nameresult = MYSQLI_QUERY($myconn, $namequery); $gamename = mysqli_result($nameresult,0,"game_title"); PRINT "

\n"; PRINT "$gamename

\n"; //PRINT "$date_added
\n"; PRINT "$date_added
\n"; PRINT "From: \n"; IF ($email == "") { PRINT "$name
\n"; } ELSE { PRINT "$name
\n"; } PRINT "Comments:\n"; PRINT " \n"; PRINT "$comment\n"; PRINT "
\n"; PRINT "
Rating: \n"; /* This is the loop to print the Kidd's */ IF ($rating > 0) { $rate_count = 0; WHILE ($rate_count < $rating): //PRINT "\n"; echo "\n"; $rate_count++; ENDWHILE; } ELSE { PRINT "n/a\n"; } /* end of Kidd printing loop */ PRINT "

\n"; PRINT "

\n"; $i++; ENDWHILE; // PRINT "
"; ENDIF; //PRINT "\n"; /* Close the database connection */ MYSQLI_CLOSE($myconn); include("analytics.php"); ?>