integrate two forms & array display

Anon

Hope this doesn't sound too lame. I have a form, code shown here that has input fields for each row. I'd like to do two things: 1.) Change a couple of these fields to just echo the row & not have an input field (I've tried to do this & it just echoes my code back to me). 2.) Integrate a second form here that uses the same $result, but points to another page to 'modify entry'. Is this possible?

Thanks for any help in advance, it is MUCH appreciated.

while ($row = mysql_fetch_assoc($result)) {

echo('

<table border=1 cellpadding=5>
<form name="remove" method="post" action="remove_entry.php">
<tr>
<td>
<b>
<font face="arial" size="2">
Name
</font>
</b>
</td>
<td><input type="text" size="25" name="phone" value="'.$row["realname"].'"></td>
<tr>
<td>
<b>
<font face="arial" size="2">
Office Phone
</font>
</b>
</td>
<td>
<input type="text" size="25" name="phone" value="'.$row["phone"].'">
</td>
</tr>
<tr>
<td>
<input type="submit" name="remove" value="Remove Entry"></td>
</tr>
</form>
</table>');
}
?>

juschillin

I'm not sure what you were asking but...

if you just want to echo the row, don use
<tr>
<td>
echo $row["realname"];
//what would probably work better is if you selected a row not an association while($row = mysql_fetch_row($result)){....}

and echo $row[0];
This way you could also use

print("<input type=\"text\" name=\"phone\" value=\"$row[0]\">");

put this at the top of the page

if($remove)
{
echo $phone;
}

again i'm not sure if this is what you want

Anon

Thanks for the response. At this point i've decided to just have one form on the page but i still cannot get the array results to display properly.

i have about 15 fields that i need to display, some 'echo' and some as 'input' fields.

if i use all 'input' fields, the data updates fine in the database. when i use some input and some echo fields, it doesn't write to the database, but i don't get an error anywhere.

basically, i'm trying to achieve a form w/ a two column table that displays the heading on the left and result on the right with one button to modify the data.

I guess I'm just not understanding the best way to set this up. I've tried mysql_fetch_array, mysql_fetch_assoc and mysql_fetch_row but cannot get the results to display properly and/or if it does, the data doesn't write to the database. If I use mysql_fetch_row, how do I echo different columns (besides the first) since there is no other value except for 0?

I suspect I'm missing a crucial piece that is causing this not to work. Sorry if I just completely confused everyone - but I'm kind of confused myself.