PHP/MySQL - Displaying an Entire table...

[onlinegs]

Okay, I have a table (lets call it table1), and I want to display the entire contents of one row in this table (lets call the row Moo), this table also as a Primary Key ID row that Auto_Incremented. Now I want to print out the contents of every 'Moo'...the script I used is: But it only prints out the first one.

$inc = 1;
while(!$result) {
$MQuery = "SELECT * FROM Table1
                     WHERE ID = '$inc'";
                     $result = mysql_query($MQuery);
                     $data = mysql_fetch_array($result);
                     print("$data[Moo] <BR>");
                     $inc++
                                  }

TIA, Bryce

[Kudose]

Try

$MQuery = "SELECT * FROM Table1
                     WHERE ID = '$inc'";
                     $result = mysql_query($MQuery);
                     $data = mysql_fetch_array($result);
for($inc=1; $inc < $data; $inc++){
                     print("$data[Moo] <BR>");
}

[onlinegs]

Thanks, Kudose for your help, I couldn't get your script to work as posted, but I slightly modified, and was able to get it to work, I have included the commented segment below for future reference.

//Okay, first we pull the entire table into $MQuery
$MQuery = "SELECT * FROM Table1";
$result = mysql_query($MQuery);
//mysql_num_rows($result) counts the number of rows returned by mysql_query()
$rows = mysql_num_rows($result);
//A simple for loop starts the var $inc at 1, and contiunes to increase it until it it becomes greater then the number of rows returned by mysql_query 
for($inc=1; $inc <= $rows; $inc++){
//Each time the loop loops, this will keep putting the contents of each consecutive row into an array, and then displaying the 'Moo' colume
$data = mysql_fetch_array($result);
print("$data[Moo] <BR>");
}

Hope this helps some people, and thanks for the help Kudose