$sql="SELECT P.id as Id,
P.pointOfSale as [Description],
P.printerExtrat1 as PrinterExtrat1,
P.printerExtrat1FonteTicket as PrinterExtrat1Font,
P.printerExtrat2 as PrinterExtrat2,
P.printerExtrat2FonteTicket as PrinterExtrat2Font,
P.printerExtrat3 as PrinterExtrat3,
P.printerExtrat3FonteTicket as PrinterExtrat3Font,
T.id as IdTable,
T.tableDescription as TableDescription
FROM PointOfSale P LEFT
JOIN PointOfSalesTables T ON P.id=T.idPointOfSale and T.isActive=1
WHERE P.isActive=1
ORDER BY P.pointOfSale";
$result = sqlsrv_query($conn, $sql);
$row[0] = "";
$i = 0;
$conf = 0;
while ($row1 = sqlsrv_fetch_array( $result, SQLSRV_FETCH_NUMERIC)) {
for($j = 0; $j < $i; $j++) {
if($row[$j] == $row1[1]) {
$conf = 1;
}
else {
}
}
if($conf == 1) {
$conf = 0;
}
else {
$resultado1 = $row1[1];
$row[$i] = $row1[1];
?>
<body>
<div>
<a href="geral.php?id=<?php echo $i;?>" class="banquetes"><?php echo $resultado1; ?></a>
</div>
</body>
<?php
$i = $i +1;
}
}
?>
.banquetes {
background-color:#60b0df;
-webkit-border-top-left-radius:0px;
-moz-border-radius-topleft:0px;
border-top-left-radius:0px;
-webkit-border-top-right-radius:0px;
-moz-border-radius-topright:0px;
border-top-right-radius:0px;
-webkit-border-bottom-right-radius:0px;
-moz-border-radius-bottomright:0px;
border-bottom-right-radius:0px;
-webkit-border-bottom-left-radius:0px;
-moz-border-radius-bottomleft:0px;
border-bottom-left-radius:0px;
text-indent:0;
display:inline-block;
color:#ffffff;
font-family:Arial;
font-size:15px;
font-weight:bold;
font-style:normal;
font:15px arial, sans-serif;
height:95px;
line-height:95px;
width:157px;
text-align:center;
float: left;
}
.banquetes:hover {
background-color:#60b0df;
}.banquetes:active {
position:relative;
top:1px;
}
I have this button format that when it fetches the data from the description table to the database, inserts the names of the data and forms it as it is in the image. It turns out I need to separate the buttons, can you help me?