Writing a php script to select data from mysql data base and populate a html table. continue getting the following message
Parse error: syntax error, unexpected T_LNUMBER in /home/chewson1/public_html/nurse_certification/dept_rpt.php on line 11
code is:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2
3 <html xmlns="http://www.w3.org/1999/xhtml">
4 <head>
5 <title>DEPARTMENT REPORT</title>
6 </head>
7 <body>
8
9 <?php
10
11 include_once('connectvars.php');
12 $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
13 or die('Error connecting to MySQL server.');
14
15 $query = "SELECT cr_id, cr_empl_num, cr_ci_num, cr_cert_exp_dte, cr_flag, ci_num, ci_desc, ci_authority, ce_dpt, ce_name, ce_email, ce_phone_ext, ce_empl_num, cd_email, cd_num
16 FROM certification_record, certification_info, certification_employee, cert_department
17 WHERE cr_empl_num = ce_empl_num
18 AND ce_dpt = cd_num
19 AND cr_ci_num = ci_num
20 AND cr_flag > '00'";
21
22
23 $result = mysqli_query($dbc, $query)
24 or die('ERROR querying database');
25 ?>
26
27 <table border=1 style="background-color:#F0F8FF;">
28 <caption><EM>Nurse Certification Report</EM></caption>
29 <tr>
30 <th>Department Number</th>
31 <th>Employeer Number</th>
32 <th>Employee Name</th>
33 <th>Employeer Email</th>
34 <th>Employeer Phone Extention</th>
35
36 </tr>
37
38 <?php
39
40 WHILE ($row = mysqli_fetch_assoc($result)) {
41 echo "</td><td>";
42 echo $row['ce_dpt'];
43 echo "</td><td>";
44 echo $row['ce_empl_num'];
45 echo "</td><td>";
46 echo $row['ce_name'];
47 echo "</td></tr>";
48 echo $row['ce_email'];
49 echo "</td><td>";
50 echo $row['ce_phone_ext'];
51 echo "</td><td>";
52 }
53 echo "</table>";
54
55
56 ?>
57
58 </body>
59 </html>
60