hmmm. I just installed the abyss webserver and mysql and php. I found a great tutorial explaining it all. howver it hasnt got a troubleshooting section :evil:.
I was just getting into it and how to use the GET method and the querystring when ut all went wrong. The code is supposed to create a document that shows a list of names taken from an mysql database called mydb and display the names as links where the link = "$PHP_SELF?id=x" where x is the primary key the person/record in question.
when clicked on it should show the data held about that person. howver, it never does this! it just displays the list of people again! I checked it more simply by using
echo($id);
and just got a blank document. Does anyone know why this is????? i'm stumped!
below is a copy of the code i was usin'
thanks :wink:
<html>
<body>
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
// display individual record
if ($id) {
$result = mysql_query("SELECT * FROM employees WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
printf("First name: %s\n ", $myrow["first"]);
printf("Last name: %s\n ", $myrow["last"]);
printf("Address: %s\n ", $myrow["address"]);
printf("Position: %s\n ", $myrow["position"]);
} else {
// show employee list
$result = mysql_query("SELECT * FROM employees",$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> \n", $PHP_SELF, $myrow["id"], $myrow["first"], $myrow["last"]);
} while ($myrow = mysql_fetch_array($result));
} else {
// no records to display
echo "Sorry, no records were found!";
}
}
?>
</body>
</html>