Hi there,
sorry tobug again but this is what I have so far...
Page 1...
<!--submit button -->
<?php
// get all records from the database
$sqlquery = "select course_name, course_date from trainee_courses";
$dataresult = mysql_query($sqlquery);
while ($datarow = mysql_fetch_array($dataresult)) {
$coursename = stripslashes($datarow['course_name']);
$courseid = $datarow['course_id'];
echo "<p><a href=\"individual_course_info2.php?course_id=$courseid\" title=\"Click to read more on $coursename\">$coursename</a></p>";
}
mysql_free_result($dataresult);
?>
Page 2...
<?php
$con = mysql_connect("localhost","root","joanne");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("training", $con);
$course_id = $_GET['course_id'];
$sqlquery = "select course_name, course_date from trainee_courses where course_id= '$course_id' ";
$dataresult = mysql_query($sqlquery);
while ($datarow = mysql_fetch_array($dataresult)) {
$coursename = stripslashes($datarow['course_name']);
$coursedate = $datarow['course_date'];
echo "Course Name: $course_name <br /> Course Date: $course_date<br />";
}
mysql_free_result($dataresult);
?>
But I am stil getting no results back from my database 🙁
Cheers
