[help] php - print on webpage

[claww]

anyone can help me at how to print something from data base on webpage

 

Example:

 

 

 

so i want to print these dates on webpage     you know what i mean as to TOP PVP / PK... etc

 

i dont know php language...

 

must look smth like that inside php source...

 

Currency: <? print ("currency"); ?> Adena : <? print ("adena") ?> Status : <? print ("status"); ?>

i understand this language but i dont know to write it,,,

i know i didnt write correct the codes but i do that mby u will understand about what i talking...

 

and on web page must lookiong

 

Currency: Festival Adena Adena: 20bilion Status: -

 

i hope u understand what i need and mby someone can help me.....

 

 

 

 

look here i want to add that in ths file

 

"

<?php  include "config/stats.php" ?>

<?php

 

//Online Players

$query = ("SELECT * FROM characters WHERE online=1 and accesslevel>=0");

 

$result = mysql_query($query) or die(mysql_error());

 

$num2=mysql_numrows($result);

$sum=$num2;

 

//Currency

i dont know what to write here

 

?>

Online Players: <?php print ("$num2"); ?><br>

Currency: "  dont know " Adena: "dont know " Status : "dont know" <br> "

Currency: "  dont know " Adena: "dont know " Status : "dont know" <br> "

[claww]

nobody  wanna help ?  sry for double post but i want to do that.... :<

[Realtek2]

I can't understand your request :(

Try one more time

[xAddytzu]

He wants to get values from table and put them on website :\

[claww]

so you dont know how to do it ? :/

[Realtek2]

He wants to get values from table and put them on website :\

 

I cant understand couse he is giving me an example for greather value..

I mean if the item is more expensive it should be at top or what ?

[claww]

nop... just print dates from tabel which i post in my 1st post here

 

and i want as all time when dates changes in this table to change on webpage too.... i dont want to print by top which is expensive....  just print the dates from table on webpage

 

look i want to print dates from

 

HERE

 

 

TO HERE ON WEBPAGE

 

http://img149.imageshack.us/i/75679269.png/

 

[claww]

i did it... i will post the code mby someone wanna print information from database on website

 

 

<?php
$db_host = 'localhost';
$db_user = 'root';
$db_pwd = 'database_password';

$database = 'database_name';
$table = 'table_name'; <!-- table name which you wanna print on website.... -->

if (!mysql_connect($db_host, $db_user, $db_pwd))
   die("Can't connect to database");

if (!mysql_select_db($database))
   die("Can't select database");

// trimitere interogare
$result = mysql_query("SELECT * FROM {$table}");
if (!$result) {
   die("Query to show fields from table failed");
}

$fields_num = mysql_num_fields($result);

echo "<h1>Table: {$table}</h1>";
echo "<table border='1'><tr>";
// printeaza titlu tabelului
for($i=0; $i<$fields_num; $i++)
{
   $field = mysql_fetch_field($result);
   echo "<td>{$field->name}</td>";
}
echo "</tr>\n";
// printeaza randurile tabelului
while($row = mysql_fetch_row($result))
{
   echo "<tr>";
    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
   foreach($row as $cell)
       echo "<td>$cell</td>";

   echo "</tr>\n";
}
mysql_free_result($result);
?>