[RESOLVED] display all entries in a table

[ungovernable]

sorry to ask a stupid question like this, but i'm a big newbie

i have a table called "news2" with a row called "bands" and another called "location"

i just want to display all "bands" from this table and print the location next to it!

could anyone hook me up with a part of script? 😃

[rodneykm]

// standard connetion
mysql_connect("localhost", "admin", "1admin") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("test") or die(mysql_error());
echo "Connected to Database";


// get stuff
$result = mysql_query("SELECT bands, location FROM news2")
or die(mysql_error());

// echo stuff
while($row = mysql_fetch_array( $result )) {
echo  $row[0] . " " . $row[1] . "<br>"; 
}