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 Link to comment https://forums.phpfreaks.com/topic/251668-parse-error/ 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. Link to comment https://forums.phpfreaks.com/topic/251668-parse-error/#findComment-1290691 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.