Re: [PHP] Displaying MySQL data inside of a table

[Jacob Vennervald Madsen]

Hi

Next time you can find a lot of information about this on www.php.net.
Check out this example:

<?php

    $conn = mysql_connect("localhost", "mysql_user", "mysql_password");
    
    if (!$conn) {
        echo "Unable to connect to DB: " . mysql_error();
        exit;
    }
    
    if (!mysql_select_db("mydbname")) {
        echo "Unable to select mydbname: " . mysql_error();
        exit;
    }
    
    $sql = "SELECT id as userid, fullname, userstatus 
            FROM   sometable
            WHERE  userstatus = 1";

    $result = mysql_query($sql);

    if (!$result) {
        echo "Could not successfully run query ($sql) from DB: " .
mysql_error();
        exit;
    }
    
    if (mysql_num_rows($result) == 0) {
        echo "No rows found, nothing to print so am exiting";
        exit;
    }

    // While a row of data exists, put that row in $row as an
associative array
    // Note: If you're expecting just one row, no need to use a loop
    // Note: If you put extract($row); inside the following loop, you'll
    //       then create $userid, $fullname, and $userstatus
    while ($row = mysql_fetch_assoc($result)) {
        echo $row["userid"];
        echo $row["fullname"];
        echo $row["userstatus"];
    }
            
    mysql_free_result($result);

?>

Best regards,
Jacob Vennervald

On Mon, 2003-07-28 at 16:08, SP Computing wrote:
> Hi all,
> 
> I have this code so far:
> 
> <?
> 
> mysql_connect(localhost, USER, PASS);
> mysql_select_db(DB);
> 
> $result = mysql_query("SELECT * FROM tbl");
> 
> ?>
> 
> Inside one of my tables, I have one field called IP which contains just over
> a thousand IP addresses. I would like these IP addresses to be displayed
> inside of a table like this:
> 
> <table border="1" cellpadding="5">
> <tr>
> <td>IP Address #1</td>
> <td>IP Address #2</td>
> <td>IP Address #3</td>
> And so on...
> </tr>
> </table>
> 
> How do I go about acheiving this?
> 
> TIA,
> 
> SP Computing
> 
> 
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 
-- 
Venlig hilsen / Best regards,
Jacob Vennervald
System Developer
Proventum Solutions ApS
Tuborg Boulevard 12
2900 Hellerup
Denmark
Phone:  +45 36 94 41 66
Mobile: +45 61 68 58 51



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php