Advertisement
Guest User

Untitled

a guest
Jun 10th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.74 KB | None | 0 0
  1. <?php
  2. $username="mikecook_user";
  3. $password="password";
  4. $database="mikecook_testdb";
  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. mysql_close();
  30.  
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement