link rows for edit

[I-AM-OBODO]

hi all.

how can i link each row so that when i click the edit, it takes me to a new page where i can edit the row associated with the edit link?

thanks in advance.

 

my code

 

<?php 

$result = mysql_query("SELECT * FROM domain_info") 
or die(mysql_error());

echo "<table border='0' cellspacing='2' cellpadding='2'>";
echo "<tr> <th bgcolor='#0cc' align='center'><font color='#fff'>Id</th> <th bgcolor='#0cc' align='center'><font color='#fff'>Clients' Name</font></th> <th bgcolor='#0cc' align='center'><font color='#fff'>Domain Name</th> <th bgcolor='#0cc' align='center'><font color='#fff'>Size</th><th bgcolor='#0cc' align='center'><font color='#fff'>Cost</th><th bgcolor='#0cc' align='center'><font color='#fff'>Created Date</th><th bgcolor='#0cc' align='center'><font color='#fff'>Last Renew</th><th bgcolor='#0cc' align='center'><font color='#fff'>Expiry Date</th></tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td width='25'>"; 
echo "$row['id'];
echo "</td><td width='150'>"; 
echo $row['client'];
echo "</td><td width='250'>"; 
echo $row['domain_name'];
echo "</td><td width='50'>"; 
echo $row['size'];
echo "</td><td width='50'>"; 
echo $row['cost'];
echo "</td><td width='100'>"; 
echo $row['create_date'];
echo "</td><td width='100'>"; 
echo $row['last_renewed'];
echo "</td><td width='100'>";
echo $row['expiry_date'];
echo "</td><td width='100'>"; 
echo "<a href='www.dis.com'> edit</a>"; // this is the edit link that should be linked to the rows
echo "</td></tr>"; 
} 

echo "</table>";

?>

[trq]

Just pass the id via the link then use that id in the next page to lookup the same data, this time displaying it in an editable html element.

[ManiacDan]

	echo "<a href='edit.php?id={$row['id']}'> edit</a>"; // this is the edit link that should be linked to the rows

Also, note that your code is colored wrong, you have an errant double quote in your second echo inside the loop.

 

You're also going to have to actually write an edit page.

 

[I-AM-OBODO]

	echo "<a href='edit.php?id={$row['id']}'> edit</a>"; // this is the edit link that should be linked to the rows

Also, note that your code is colored wrong, you have an errant double quote in your second echo inside the loop.

 

You're also going to have to actually write an edit page.

 

 

thanks. but what's the right way for my coloring?

[ManiacDan]

The coloring indicates that your quotes are misplaced, so the auto-coloring function "breaks" because your code is broken.  This code will not even run due to the extra quote.

[I-AM-OBODO]

thanks guys