newbie loops

[t-man]

i can get the data for the db and put it into an array, but how can i get a loop to display what's in the array, plus some extra bits that i want to add?

[Yamakazi]

Simple example.

$queryTest= "select FileId, ContentType from fileupload where TaskId = $testId ";
$resultTest = mysql_query($queryTest);
while($TestResult = mysql_fetch_array($resultTest)){
print("$TestResult[FileId]");
}

[michael]

I use the null= ... it keeps you from having a redundant loop.

<?php
    mysql_connect("localhost", "mysql_user", "mysql_password") or
        die("could not connect");
    mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while (NULL !=($row = mysql_fetch_array($result, MYSQL_ASSOC))) {
    printf ("ID: %s  Name: %s", $row["id"], $row["name"]);
}

mysql_free_result($result);
?>