PHP file that pulls from beatty2.sql
which is tblemps joined to tbldps as in your handout
";
mysql_select_db("beatty2");
// from Antharia: $sql="SELECT staff.*, title_types.type FROM staff, title_types
//WHERE staff.title_type_id= title_types.id ORDER by staff.last_name";
$query = "SELECT * FROM tblemps";
$result = mysql_query ($query);
if($result) {
echo "We have selected:
";
}
else {
echo "Sorry";
}
while ($row = mysql_fetch_array($result)) {
echo $row['fldName'] . " " . $row['fldTitle'] . $row['tbldeps.fldDep_id'] . "
";
}
$query = "SELECT * FROM tbldeps";
$result = mysql_query ($query);
if($result) {
echo "
We have selected:
";
}
else {
echo "Sorry";
}
while ($row = mysql_fetch_array($result)) {
echo $row['fldName'] . " " . $row['fldDep_id'] . "
";
}
//$query3 = "SELECT tbldeps.fldDep_id, tbldeps.fldName AS depart, tblemps.fldName, tblemps.fldTitle,
//FROM tbldeps, tblemps WHERE tbldeps.fldDep_id=tblemps.fldDep_id"; This returns no result
$query3 = "SELECT tbldeps.fldDep_id, tbldeps.fldName AS depart, tblemps.fldName, tblemps.fldTitle, tblemps.fldPicture FROM tbldeps, tblemps WHERE tbldeps.fldDep_id=tblemps.fldDep_id";
$result = mysql_query ($query3);
if($result) {
echo "
We have selected:
";
}
else {
echo "
Sorry" . mysql_error();
}
while ($row = mysql_fetch_array($result)) {
echo $row['depart'] . " " . $row['fldName'] . " " . $row['fldTitle'] . "
";
}
?>
| Staff
|
| Name
|
Title
|
Department
|
Picture
|
";
echo "" . $row ["fldName"] . " | ";
echo "" . $row ["fldTitle"] . " | ";
echo "" . $row ["depart"] . " | ";
echo " ![](" . $row ["fldPicture"] . ") | ";
echo "";
$count++;
}
?>