Hi Mac,
Can you please give me some hint on where I may be doing something wrong on the following script, because it gives me an error : undefined index error.
Language: PHP
include "connect.php";
//making a query
$query = "SELECT * FROM fixtures";
$results = mysql_query($query);
echo "<table>";
echo "<tr><th>OPPONENTS</th><th>DATE</th><th>VENUE</th><th>ACTION</th></tr>";
while ($rows = mysql_fetch_array($results)) {
$fixture_id = $rows[';FIXTURE_ID';];
$opponents = $rows[';OPPONENTS';];
$date = $rows[';DATE';];
$venue = $rows[';VENUE';];
echo "<tr><td>$opponents</td><td>$date</td><td>$venue</td><td><a href=fixtures.php?fixture_id=$fixture_id>Delete</a></td><td><a href=fixtures.php?fixture_id=$fixture_id>Update</a></td></tr>";
}
echo "</table>";
$fixt_id = $_GET[';fixture_id';];