Advertisement
Guest User

Untitled

a guest
Jun 11th, 2017
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.83 KB | None | 0 0
  1.     <?php
  2.             $username="wwwesco2_read";
  3.             $password="New1234i";
  4.             $database="wwwesco2_data";
  5.             mysql_connect(localhost,$username,$password);
  6.             @mysql_select_db($database) or die( "Unable to select database");
  7.             $query="SELECT *, UNIX_TIMESTAMP(date) as date FROM events ORDER BY date";
  8.             $result=mysql_query($query);
  9.         ?>
  10.  
  11.         <?php
  12.             $i=0;
  13.             while ($row = mysql_fetch_array($result))
  14.             {
  15.                 $f1= date('d/m', $row['date']);
  16.                 $f2= $row['performers'];
  17.                 $f3= $row['starts'];
  18.                 $f4= $row['price'];
  19.         ?>
  20.  
  21.         <div id="tablerow">
  22.             <div class="table_date">        <?php echo $f1; ?></div>
  23.             <div class="table_performers">  <?php echo $f2; ?></div>
  24.             <div class="table_time">        <?php echo $f3; ?></div>
  25.             <div class="table_price">       <?php echo $f4; ?></div>
  26.         </div>
  27.  
  28.         <?php
  29.             }
  30.             mysql_close();
  31.         ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement