Displaying mySQL with PHP

programming
1

Hi,

I have this chunk of code that is pretty standard. Checks for the DB connection, then searchrs for the table and displays the data, but it will only display one row. I’m not sure how to have it display one after another?

<?php

// Get the PHP file containing the DbConnector class
require_once('DbConnector.php');

// Create an instance of DbConnector
$connector = new DbConnector();

// Use the query function of DbConnector to run a database query
// (The arrow -> is used to access a function of an object)
$result = $connector->query('SELECT * FROM yea_Contacts ORDER BY ID ASC');

// Get the result
$row = $connector->fetchArray($result);


// Show it to the user
echo "Contact Name:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Contact Email:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Contact Service:<br /><table cellspacing='2' style='border:1px solid #000000' cellpadding='15' bgcolor='#CCCCCC'><tr><td>";
echo $row['contactName'];
echo "</td><td>";
echo $row['contactEmail'];
echo "</td><td>";
echo $row['contactService'];
echo "</td></tr></table><br><br>To Add A Contact <a href='addContacts.html'>Click Here</a>";




?>