Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <body>
- <table border="0" cellspacing="2" cellpadding="2">
- <tr>
- <th><font face="Arial, Helvetica, sans-serif">Value1</font></th>
- <th><font face="Arial, Helvetica, sans-serif">Value2</font></th>
- <th><font face="Arial, Helvetica, sans-serif">Value3</font></th>
- <th><font face="Arial, Helvetica, sans-serif">Value4</font></th>
- <th><font face="Arial, Helvetica, sans-serif">Value5</font></th>
- </tr>
- <?php
- $username="totally_bob";
- $password="bob1";
- $database="totally_catalogue";
- mysql_connect(localhost,$username,$password);
- @mysql_select_db($database) or die( "Unable to select database");
- $query="SELECT * FROM products";
- $result=mysql_query($query);
- $num=mysql_numrows($result);
- mysql_close();
- echo "<b><center>Database Output</center></b><br><br>";
- $i=0;
- while ($i < $num) {
- $first=mysql_result($result,$i,"product_id");
- $last=mysql_result($result,$i,"product_artist");
- $phone=mysql_result($result,$i,"product_artist2");
- $mobile=mysql_result($result,$i,"product_format");
- $fax=mysql_result($result,$i,"product_title");
- $email=mysql_result($result,$i,"product_label");
- $web=mysql_result($result,$i,"product_condition");
- $i++;
- ?>
- <tr>
- <td><font face="Arial, Helvetica, sans-serif"><?php echo $first;?></font></td>
- <td><font face="Arial, Helvetica, sans-serif"><?php echo $phone $last; ?></font></td>
- <td><font face="Arial, Helvetica, sans-serif"><?php echo $mobile; ?></font></td>
- <td><font face="Arial, Helvetica, sans-serif"><?php echo $fax; ?></font></td>
- <td><font face="Arial, Helvetica, sans-serif"><?php echo $web;?></font></td>
- </tr>
- }
- ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement