1. <html>
  2.  
  3. <head>
  4.  
  5. <basefont face="Arial">
  6.  
  7. </head>
  8.  
  9. <body>
  10.  
  11.  
  12.  
  13.  
  14. <?php
  15.  
  16.  
  17.  
  18. // set database server access variables:
  19.  
  20. $host = "localhost";
  21.  
  22.  
  23.  
  24.  
  25.  
  26.  
  27. // open connection
  28.  
  29. $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
  30.  
  31.  
  32.  
  33. // select database 
  34.  
  35. mysql_select_db($db) or die ("Unable to select database!");
  36.  
  37.  
  38.  
  39.  
  40. // create query
  41.  
  42. $query = "SELECT * FROM symbols WHERE id='1' OR id='3' OR id='5'";
  43.  
  44.  
  45.  
  46. // execute query
  47.  
  48. $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
  49.  
  50.  
  51.  
  52.     echo "<table cellpadding=10 border=1>";
  53.  
  54.  
  55.  
  56.         $data = while(mysql_fetch_array($result)){
  57.         $x = $data['id'];
  58.         $myArray[$x] = $data;
  59.         }
  60.  
  61.         echo "<tr>";
  62.         echo "<td>".$myArray[1]['id']."</td>";
  63.         echo "<td>".$myArray[1]['country']."</td>";
  64.         echo "<td>".$myArray[1]['animal']."</td>";
  65.         echo "</tr>";
  66.  
  67.         echo "<tr>";
  68.         echo "<td>".$myArray[3]['id']."</td>";
  69.         echo "<td>".$myArray[3]['country']."</td>";
  70.         echo "<td>".$myArray[3]['animal']."</td>";
  71.         echo "</tr>";
  72.         echo "<tr>";
  73.         echo "<td>".$myArray[5]['id']."</td>";
  74.         echo "<td>".$myArray[5]['country']."</td>";
  75.         echo "<td>".$myArray[5]['animal']."</td>";
  76.         echo "</tr>";
  77.  
  78.  
  79.  
  80.  
  81.     echo "</table>";
  82.  
  83.  
  84.  
  85.  
  86.  
  87. // free result set memory
  88.  
  89. mysql_free_result($result);
  90.  
  91.  
  92.  
  93. // close connection
  94.  
  95. mysql_close($connection);
  96.  
  97.  
  98.  
  99. ?>
  100.  
  101.  
  102.  
  103.  
  104. </body>
  105.  
  106. </html>