07-08-2003
143,
0
Join Date: Aug 2002
Last Activity: 30 March 2011, 8:28 AM EDT
Location: Ireland
Posts: 143
Thanks Given: 0
Thanked 0 Times in 0 Posts
PHP:page.php?id= ????
Hi, i have this script to read from mysql (layout below) and the script will display the course title, and a url to the id, but when i click on the url it just goes back to that page(displaying all the course titles)but when u click on a course title i want it to read from detail table in php and display all the data in detail. how would i modifie the script to do that??
<html>
<body>
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("compulearn",$db);
// display individual record
if ($id) {
$result = mysql_query("SELECT * FROM courses WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
printf("First name: %s\n<br>", $myrow["courses"]);
} else {
// show employee list
$result = mysql_query("SELECT * FROM courses",$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
do {
printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["id"], $myrow["courses"], $myrow[""]);
} while ($myrow = mysql_fetch_array($result));
} else {
echo "Sorry, no records were found!";
}
}
MYSQL TABLE
+------+-------------------+-------------------+
| ID | Courses | detail |
+------+--------------------+------------------+
| intro | Intoductions | This course....|
+------+--------------------+------------------+
Please someone tell me.i hope u understand what iam lookin for,.