Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $username="mikecook_user";
- $password="password";
- $database="mikecook_testdb";
- mysql_connect(localhost,$username,$password);
- @mysql_select_db($database) or die( "Unable to select database");
- $query="SELECT *, UNIX_TIMESTAMP(date) as date FROM events ORDER BY date";
- $result=mysql_query($query);
- ?>
- <?php
- $i=0;
- while ($row = mysql_fetch_array($result))
- {
- $f1= date('d/m', $row['date']);
- $f2= $row['performers'];
- $f3= $row['starts'];
- $f4= $row['price'];
- ?>
- <div id="tablerow">
- <div class="table_date"> <?php echo $f1; ?></div>
- <div class="table_performers"> <?php echo $f2; ?></div>
- <div class="table_time"> <?php echo $f3; ?></div>
- <div class="table_price"> <?php echo $f4; ?></div>
- </div>
- <?php
- mysql_close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement