[SOLVED] Generate DB data in a page

[McChicken]

Hey. I want to generate my database in a table on a php/html page.

something like this:

Can someone help me with the code?

thanks.

[php.ajax.coder]

Try looking at this

 

http://www.w3schools.com/php/php_mysql_create.asp

[Chicken Little]

Try this and modify where needed

 

<?php
$username = "yourusername";
$password = "yourpassword";
$hostname = "yourhostname";	
$dbh = mysql_connect($hostname, $username, $password) 
or die("Unable to connect to MySQL");
$selected = mysql_select_db("yourdatabasename",$dbh) 
or die("Could not get database");
$result = mysql_query("SELECT * FROM ip_hits ORDER BY clicks, date DESC LIMIT 0,10");
//while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
echo "<table cellspacing='15'>";
echo "<tr><td colspan='3'><hr /></td></tr>";
while($row = mysql_fetch_assoc($result))
{
extract ($row);
echo "<tr>\n
<td>$id</td>\n
<td>$clicks</td>\n
<td>$ip</td>\n
<td>$BrukerID</td>\n
<td>$date</td>\n
</tr>\n";
echo "<tr><td colspan='3'><hr /></td></tr>\n";
}
echo "</table>\n";

[McChicken]

Thank you little chicken.

 

I'm not 100% happy with the results, but it's a good start:)

 

[McChicken]

A little change here fixed it:) Thank you again Little chicken!

 

$result = mysql_query("SELECT * FROM `ip_hits` ORDER BY `ip_hits`.`date` DESC LIMIT 0, 30 ; ");