Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = "";
- $user = '';
- $pass = '';
- $db = "";
- $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
- mysql_select_db($db) or die ("Unable to select database!");
- $query = "SELECT * FROM table";
- $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
- $id = 1;
- // see if any rows were returned
- if (mysql_num_rows($result) > 0) {
- // yes
- // print them one after another
- echo "<table cellpadding=10 border=1>";
- while($row = mysql_fetch_row($result)) {
- echo "<tr>";
- echo "<td>".$id."</td>";
- echo "<td>".$row[0]."</td>";
- echo "</tr>";
- $id++;
- }
- echo "</table>";
- }
- else {
- // no
- // print status message
- echo "No rows found!";
- }
- // free result set memory
- mysql_free_result($result);
- // close connection
- mysql_close($connection);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement