Breaking News: Grepper is joining You.com. Read the official announcement!

how to get button for every record from mysql

Super Skylark answered on March 5, 2021 Popularity 1/10 Helpfulness 1/10

answer how to get button for every record from mysql

how to get button for every record from mysql

Comment

<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>

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: button get mysql record sql

Link to this answer
Share Copy Link

Contributed on Mar 05 2021

Super Skylark

0 Answers Avg Quality 2/10

how to get button for every record from mysql

Contents

More Related Answers

how to get button for every record from mysql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.