Code: Select all
<?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<br>", $myrowї"first"]);
printf("Last name: %s\n<br>", $myrowї"last"]);
printf("Address: %s\n<br>", $myrowї"address"]);
printf("Position: %s\n<br>", $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><br>\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!";
}
}
?>Notice: Undefined variable
dawho
?>