You are viewing our Forum Archives. To view or take place in current topics click here.
php sql help please
Posted:

php sql help pleasePosted:

Nvidia-980
  • New Member
Status: Offline
Joined: Oct 06, 201410Year Member
Posts: 40
Reputation Power: 3
Status: Offline
Joined: Oct 06, 201410Year Member
Posts: 40
Reputation Power: 3
can anyone help quide me into what query might work please? i have tried all sorts and i cant seem to get it to work, if need be i can send my files if someone could help?

code -------
<?php
include('connect.php');

/*SQL COMMAND TO FIND ALL OF THE ORDERS FOR THE PARTICULAR CUSTOMER*/

$orderDetailsSQL = "";

$orderInfoResults = mysqli_query($dbconnect, $orderDetailsSQL);
$counter = 0;
while($orderInfoRows = mysqli_fetch_array($orderInfoResults)) {
if($counter == $orderInfoRows[0]) {
echo "<tr>
<td>$orderInfoRows[1]</td>
<td>$orderInfoRows[2]</td>
</tr>";
} else
echo "<table class='table table-striped'>
<h4>$orderInfoRows[0]</h4>
<tr>
<td>$orderInfoRows[1]</td>
<td>$orderInfoRows[2]</td>
</tr>";
$counter = $orderInfoRows[0];
}
echo "</table>";
?>
-------------------------------
Jump to:
You are viewing our Forum Archives. To view or take place in current topics click here.