webguync Posted May 16, 2011 Share Posted May 16, 2011 apparently I am doing this wrong. I want my string results from a form that searches DB content to appear within HTML table, tr, td tags. I get the results fine, but the HTML part isn't appearing. How should I be doing this? <?php $string = ''; $result = mysql_query($sql); /// This is the execution if (mysql_num_rows($result) > 0){ while($row = mysql_fetch_object($result)){ echo "<table>"; echo "<tr>"; $string .= "<td>".$row->last_name."</td> "; $string .= "<td>".$row->first_name."</td>"; $string .= "<td>".$row->employee_id."</td>"; $string .= "<td>".$row->title."</b>"; $string .= "<td>".$row->territory."</td>"; $string .= "<td>".$row->district."</td>"; $string .= "<td>".$row->Phase1A_Score."</td>"; $string .= "<td>".$row->Phase1B_Score."</td>"; $string .= "<td>".$row->Phase1_Average."</td>"; $string .= "<td>".$row->Phase1A_HS_Exam."</td>"; $string .= "<td>".$row->Phase1A_HS_Exam_RT."</td>"; $string .= "<td>".$row->Phase1B_HS_Exam."</td>"; $string .= "<td>".$row->Phase1B_HS_Exam_RT."</td>"; $string .= "<td>".$row->Class_Date."</td>"; $string .= "<td>".$row->Awards."</td>"; $string .= "<br/>\n"; echo "</tr>"; echo "</table>"; } }else{ $string = "No matches found!"; } echo $string; ?> Link to comment https://forums.phpfreaks.com/topic/236579-displaying-html-in-my-string-variable/ Share on other sites More sharing options...
zer0day Posted May 16, 2011 Share Posted May 16, 2011 I don't know for sure that I understand exactly what you're asking, but maybe this will help: <?php $string = "<table>"; $result = mysql_query($sql); if (mysql_num_rows($result) > 0) { while($row = mysql_fetch_object($result)) { $string .= "<tr>"; $string .= "<td>".$row->last_name."</td>"; $string .= "<td>".$row->first_name."</td>"; $string .= "<td>".$row->employee_id."</td>"; $string .= "<td>".$row->title."</td>"; $string .= "<td>".$row->territory."</td>"; $string .= "<td>".$row->district."</td>"; $string .= "<td>".$row->Phase1A_Score."</td>"; $string .= "<td>".$row->Phase1B_Score."</td>"; $string .= "<td>".$row->Phase1_Average."</td>"; $string .= "<td>".$row->Phase1A_HS_Exam."</td>"; $string .= "<td>".$row->Phase1A_HS_Exam_RT."</td>"; $string .= "<td>".$row->Phase1B_HS_Exam."</td>"; $string .= "<td>".$row->Phase1B_HS_Exam_RT."</td>"; $string .= "<td>".$row->Class_Date."</td>"; $string .= "<td>".$row->Awards."</td>"; $string .= "</tr>"; } $string .= "</table>"; } else { $string = "No matches found!"; } echo $string; ?> Link to comment https://forums.phpfreaks.com/topic/236579-displaying-html-in-my-string-variable/#findComment-1216218 Share on other sites More sharing options...
webguync Posted May 16, 2011 Author Share Posted May 16, 2011 yes, that gives me what I need, thx! Link to comment https://forums.phpfreaks.com/topic/236579-displaying-html-in-my-string-variable/#findComment-1216232 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.