SQL and loops

[MacMyDay]

I have this form which consists of the following:


<TR><TD><input type=text name='name' style='width:80px;'></TD>
<TD><input type=text name='blah' style='width:90px;'></TD>
<TD><input type=text name='blahblah' style='width:200px;'></TD>
<TD><select NAME='rating'>
<option VALUE=''> -- Rating --
<OPTION VALUE='Blah'>Blah
<OPTION VALUE='Blah'>Blah
</select><br>



What I want to do is to have it displayed as many times as there are results in the database for that user. All I know at the moment is it'd start with $query = mysql_query ("select * from list where username='$blah'");

Thanks in advance.

[pyro]

Ok, what we do then is loop through the values that it returns, with something like this:

while($row = mysql_fetch_array($query)) {
echo $row[0]; #will echo the value of the first column in each row
}

[MacMyDay]

Thanks for the start. Thing is that only selects the first column, for me. I need it to select everything and display it.

[pyro]

Try this out:

while($row = mysql_fetch_array($query)) {
foreach ($row as $value) {
echo $value." "; #the ." " is to add a space after each item it prints
}
echo "<br>";
}

[MacMyDay]

Getting there ;) It now just displays everything twice.

[pyro]

Can I see your complete code?

[MacMyDay]

Sure, but it's really only what you've given me.

<?
include ("header.php");
include ("connect.php");

$username = getusername();
$result = mysql_query ("select * from list where username='$username'");
while ( $row = mysql_fetch_array ($result)) {
foreach ( $row as $value ) {
echo $value." " ;
}
echo "<br>" ;
}
?>