sql database

szafar

how can i load data from sql database for a field

Rawland_Hustle

I'm a total noob and I don't know if this is right for you. This is how I did it though.

I use the code below which I found. Replace "hidden" and "country", "city" and "population" with your information.

[code]
<?php
$dbhost = 'hidden';
$dbuser = 'hidden';
$dbpass = 'hidden';
$dbname = 'hidden';

// Create connection
$con=mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);

$result = mysqli_query($con,"SELECT * FROM world");

echo "


Column1
Column2
Column3

";

while($row = mysqli_fetch_array($result))
{
echo "";
echo "" . $row['country'] . "";
echo "" . $row['city'] . "";
echo "" . $row['population'] . "";
echo "";
}
echo "";

mysqli_close($con);
?>
[/code]