MySQL Result in PHP/HTML Generated Table - Click Row To Edit?

[kolax]

My website shows results from a MySQL database using PHP into an HTML table.

What I want, at the end of each row, is an 'edit' link, which takes you to a page called edit.php and posts the variables of the row which you clicked edit on.

This is my code so far:

$result = mysql_query("SELECT * FROM name_number_table");

while($row = mysql_fetch_array($result))
{
    echo "<tr>";
    echo '<td>' . $row['name'] . "</td>";
    echo '<td>' . $row['number'] . "</td>";
    [b]echo '<td><a href="edit.php">' . $row . "</td>";[/b]
    echo "</tr>";
}
echo "</table>";

The bit in bold is what I need to get working. Right now, it works as a link to edit.php, but I need it to post the row variables too.

Any ideas? Thanks.

 

[Darth.Titan]

How I'd go about it, assuming that each row has a unique 'id':

<?php
$result = mysql_query("SELECT * FROM name_number_table");

while($row = mysql_fetch_array($result)): ?>
<tr>
<td><?=$row['name']?></td>
<td><?=$row['number']?></td>
<td><a href="edit.php?id=<?=$row['id']?>">Edit</a></td>
</tr>
<?php endwhile; ?>
</table>

Then in 'edit.php' you can use the row id from $_GET['id'] to query the database for the field values and populate your edit form. To me, this method is cleaner.

However, if passing the field values to the form is the way you want to go, each edit link will need to contain all the field values in the query string. It can be kind of ugly...

<?php
while($row = mysql_fetch_array($result)): ?>
<tr>
<td><?=$row['name']?></td>
<td><?=$row['number']?></td>
<td><a href="edit.php?name=<?=$row['name']?>&number=<?=$row['number']?>">Edit</a></td>
</tr>
<?php endwhile; ?>

In edit.php the values can be gotten from $_GET['name'] and $_GET['number']

I apologize if my use short open tags offends anyone...

 

[kolax]

Perfect, thanks.

 

[618537]

Remember SQL Injection Protection for all user generated variables.

 

[kolax]

My table is just blank now (it has the correct amount of rows, just no data).

The only thing I've changed is instead of embedding the HTML code within PHP and using echo, I've embedded the PHP code like in your example with the HTML code.

<?=$row['name']?>

Is that definitely correct?


EDIT:

Got it working with:

<?php echo $row['name']?>

 

[Darth.Titan]

Your server may not allow short tags. I probably shouldn't use them either, but I do anyway. What you did is definitely correct though.