chewson Posted November 23, 2011 Share Posted November 23, 2011 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 Quote Link to comment Share on other sites More sharing options...
trq Posted November 23, 2011 Share Posted November 23, 2011 What is within connectvars.php? And please, we have tags. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.