game description.txt

drupal（内容管理系统CMS）的应用项目

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db( 'etreasure1' );

$result = mysql_query("SELECT * FROM sms_game where game_id='" . $_GET['game_id']."'");
$value = mysql_fetch_array($result);

echo "E-Treasure Name : <b>" . $value ['game_name'] . "</b>";
echo "<br>";
echo "SMS Word: <b>" . $value ['game_password'] . "</b>";
echo "<br>";
echo "E-Treasure Description: " . $value ['game_description'];
echo "<br>";
echo "<br>";

echo "<table>";
echo "<tr>";
$ii=  "SELECT * FROM sms_game_photos where game_id=" . $_GET['game_id']." LIMIT 0 , 3";
$imageQuery=mysql_query($ii); 


while($row=mysql_fetch_array($imageQuery)) 
{  
echo "<td>";                                                         
echo "<image  src=".$row['photoPath']." alt=".$row['photoName']."  width='200' height='200' title='' /></a><p>".$row['photoName']."</p>";
echo "</td>";
}
echo "</tr>";

mysql_free_result($imageQuery);
mysql_free_result($result);
mysql_close($con);
?>