I am struggling to put the data that is pulled from my database into a table layout.
This is the echo result:
echo "<p><h3>".$results['ID Number']."</h3>".$results['id_number']."</p>";
echo "<p><h3>".$results['Card Status']."</h3>".$results['card_status']."</p>";
echo "<p><h3>".$results['Full Name']."</h3>".$results['full_name']."</p>";
echo "<p><h3>".$results['DBS/CRB Number']."</h3>".$results['dbs_number']."</p>";
echo "<p><h3>".$results['Job Title']."</h3>".$results['job_title']."</p>";
echo "<p><h3>".$results['Card Start Date']."</h3>".$results['card_start_date']."</p>";
echo "<p><h3>".$results['Card Expiry']."</h3>".$results['card_expiry_date']."</p>";
echo "<img src='photos/".$results['photo_name']."'>";
Please can someone help me, its driving me crazy, also the Name of the result isn't showing, e.g. 'ID Number' as a title then 'id_number' result.
or is there an easier way to show all the data from the record rather than having multiple echo's
I have a search box to find a record matching the id_number and then the data connected to a id_number is then shown