[PHP] Displaying MySQL data inside of a table

[Jacob Vennervald Madsen]

Hi

Next time you can find a lot of information about this on [url]www.php.net[/url].
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 ([url]http://www.php.net/[/url])
> To unsubscribe, visit: [url]http://www.php.net/unsub.php[/url]
>
>

--
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

[desa15@necso.es]

$mysql_link = mysql_connect("localhost", USER, PASS);

mysql_select_db(DB, $mysql_link);

$SQL = "SELECT * FROM tbl";

$result = mysql_query($SQL, $mysql_link) or die (mysql_error());

echo "<table border="1" cellpadding="5">";

while($resultat = @mysql_fetch_array($result)) {

echo "<tr><td>

$resultat[ip]

</td>";

echo "</table";
}

$mysql_link=mysql_close($mysql_link);

Un saludo, Danny

[Sven]

[email]desa15@necso.es[/email] wrote:

> $mysql_link = mysql_connect("localhost", USER, PASS);
>
> mysql_select_db(DB, $mysql_link);
>
> $SQL = "SELECT * FROM tbl";
>
> $result = mysql_query($SQL, $mysql_link) or die (mysql_error());
>
> echo "<table border="1" cellpadding="5">";
>
> while($resultat = @mysql_fetch_array($result)) {
>
> echo "<tr><td>
>
> $resultat[ip]
>
> </td>";

here is '</tr>' missing:
</td></tr>";

> echo "</table";
> }

the echo '</table>'; should come after the closed while:
}
echo '</table>';

> $mysql_link=mysql_close($mysql_link);
>
> Un saludo, Danny

ciao SVEN

[desa15@necso.es]

[email]desa15@necso.es[/email] wrote:

> $mysql_link = mysql_connect("localhost", USER, PASS);
>
> mysql_select_db(DB, $mysql_link);
>
> $SQL = "SELECT * FROM tbl";
>
> $result = mysql_query($SQL, $mysql_link) or die (mysql_error());
>
> echo "<table border="1" cellpadding="5">";
>
> while($resultat = @mysql_fetch_array($result)) {
>
> echo "<tr><td>
>
> $resultat[ip]
>
> </td>";

here is '</tr>' missing:
</td></tr>";

> echo "</table";
> }

the echo '</table>'; should come after the closed while:
}
echo '</table>';

> $mysql_link=mysql_close($mysql_link);
>
> Un saludo, Danny

ciao SVEN


Excuse me, i write directly in the e-mail