output data stored in mysql table with php

hi experts,

i have a mysql table that holds information of events like name, date, location, etc. so each mysql table row is one event with its details.

now i want to output each event in its own html table (with 2 columns) that has some hardcoded labels like [B]Name[/B], [B]Date[/B], [B]Location[/B], etc in its left column and the respective data from the mysql table in the right column.

what i got so far is connecting to the db, selecting the table and echoing a message if there´s no event found.

[code=php]
<?php

/* Connecting, selecting database */

$link = mysql_connect(“localhost”, “root”, “”)
or die(“Error connecting to database”);
mysql_select_db(“mydatabase”) or die(“Database mydatabase not found.”); ?>

<h4 class=”events”>This is the Events Headline</h4>

<?php
$sql = “SELECT * FROM eventstable”;
$result = mysql_query($sql,$link);

/* Printing results in HTML */

if (! ($line = mysql_fetch_array($result))) {echo(“<br>”); echo (“Sorry, no events in the database”);}
else {THIS IS WHERE YOU SHOULD HELP ME PLEASE[/code]

thanks in advance,
jogol

Also in #PHP _↴