The reason is that mysql_fetch_array() does not fetch the whole result set, but instead, a single row in the form of an array, unless you specify otherwise, you'll get an both an indexed array, and an associative array (where the keys are the column names)
You will need to establish a loop to repeatedly call mysql_fetch_array(), process the resulting array, then get the next one ... something like:
$rows = mysql_num_rows($recResult);
echo "<b>Rows returned</b>: $rows<br />\n";
for ($i = 0; $i < $rows; $i++) {
$recRow = mysql_fetch_array($recResult);
// suppose you have columns 'id', and 'name' in the result set
extract($recRow); //now you have variables $id, and $name
echo "ID# $id belongs to $name"<br />\n";
}
Make sense?
