使用PHP在HTML页面中显示SQL表格内容

Question

I have a SQL table and I would like to display it in a HTML page. My code is displaying a table but the content is empty although my table is filled with data.

    <?php
        ini_set('display_errors', 'On');
        error_reporting(E_ALL);

        $database = 'karin';
        $connect = mysql_connect('localhost','root', 'karin');
        if (!$connect) {
            die(mysql_error());
        }
        if (!mysql_select_db($database))
            die("Can't select database");

        $results = mysql_query("SELECT * FROM service_messages");
        if (!$results) {
            die("Query to show fields from table failed");
        }


        while($row = mysql_fetch_array($results)) {
        ?>
            <tr>
                <td><?php echo $row['partner']?></td>
                <td><?php echo $row['GUID']?></td>
                <td><?php echo $row['serviceName']?></td>
                <td><?php echo $row['serviceID']?></td>
                <td><?php echo $row['countries']?></td>
                <td><?php echo $row['rate']?></td>
                <td><?php echo $row['ips']?></td>
                <td><?php echo $row['callback']?></td>
            </tr>

        <?php
        }
        ?>
        </tbody>
        </table>
</body>

Why doesn't it show the table content? Thanks!

Answer 1

Try this

 while($row = mysql_fetch_row($results)) {
        ?>
            <tr>
                <td><?php echo $row['partner']?></td>
                <td><?php echo $row['GUID']?></td>
                <td><?php echo $row['serviceName']?></td>
                <td><?php echo $row['serviceID']?></td>
                <td><?php echo $row['countries']?></td>
                <td><?php echo $row['rate']?></td>
                <td><?php echo $row['ips']?></td>
                <td><?php echo $row['callback']?></td>
            </tr>

        <?php
        }
        ?>

For more refrence : http://php.net/manual/en/function.mysql-fetch-row.php