/SQL/How to get button for every record from mysql

How to get button for every record from mysql

<html>
<form method = "GET" action = "copytrade.php">

<?php 
require('connect.php');
$query = "SELECT * FROM trade_history1 "; //You don't need a ; like you do in SQL
$result = mysql_query($query);

echo "<table border = '1px'>"; // start a table tag in the HTML
echo "<tr><td>" . "ID" . "</td><td>" . "Date" . "</td><td>" . "Type" . "</td><td>" . "Size" . "</td><td>" . "Currency Pair" . "</td><td>" . "Entry" . "</td><td>" . "Stoploss" . "</td><td>". "Take Profit" . "</td><td>" . "Date Close" . "</td><td>" ."Close" . "</td><td>" ."Profit/Loss"."</td><td>" ."Copy"."</td><td>Copy</td></tr>" ;  //$row['index'] the index here is a field name

while($row = mysql_fetch_array($result)){   //Creates a loop to loop through results
echo "<tr><td>" . $row['id'] . "</td><td>" . $row['date'] . "</td><td>" . $row['type'] . "</td><td>" . $row['size'] ."</td><td>" . $row['currency_pair'] ."</td><td>" . $row['entry'] ."</td><td>" . $row['stoploss'] ."</td><td>" . $row['takeprofit'] ."</td><td>" . $row['dateclose'] ."</td><td>" . $row['close'] ."</td><td>" . $row['profitloss'] . "</td><td>a href='copytrade.php?id=" .$row['id'].'">copy</a></td></tr>";  //$row['index'] the index here is a field name
}

echo "</table>"; //Close the table in HTML

mysql_close(); //Make sure to close out the database connection
?>

<input type = "submit" name = "copy" value = "copy"/></form>
</html>

Source: stackoverflow.com

Similar codes

0 vote253 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
1 vote275 views1 answer
Alphabetical order mysql
SQL
0 vote368 views1 answer
Oracle db timestamp auto add
SQL
0 vote315 views1 answer
Copy from one table to another postgres using matching column
SQL
9 votes296 views2 answers
Nosql databases
SQL
1 vote266 views2 answers
Sql select only first occurrence
SQL
0 vote268 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
2 votes292 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote282 views1 answer
Sql date between one week
SQL
0 vote302 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL