Warning: mysql_fetch_assoc():

[pally]

I have writte this code to allow me to remove orders within my database, however i am getting an "Warning" between these lines of code

the code only output 1 order, i would like it 2 output all the orders???

Warning: mysql_fetch_assoc(): 4 is not a valid MySQL result resource in on line 30

?>
<table border="1">
  <tr>
    <td>Order ID </td>
    <td>Username</td>
    <td>Total</td>
    <td>Order Status </td>
    <td>&nbsp;</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><?php echo $row_rsorders['orderid']; ?></td>
      <td><?php echo $row_rsorders['username']; ?></td>
      <td><?php echo $row_rsorders['total']; ?></td>
      <td><?php echo $row_rsorders['order_status']; ?></td>
      <td><a href="confirmDelete.php?recordID=<?php echo $row_rsorders['orderid']; ?>">Delete</a></td>
    </tr>

   <?php } 

   while ($row_rsorders = mysql_fetch_assoc($rsorders)); ?> 
</table>

[pally]

line 30 is the line

"while ($row_rsorders = mysql_fetch_assoc($rsorders));"

[Houdini]

Where is the code that you connect and perform the original query because what you have shown does not help much.

[pally]

<?php require_once('Connections/Shop.php'); ?>
<?php
mysql_select_db($database_Shop, $Shop);
$query_rsorders = "SELECT orderid, username, total, order_status FROM orders";
$rsorders = mysql_query($query_rsorders, $Shop) or die(mysql_error());
$row_rsorders = mysql_fetch_assoc($rsorders);
$totalRows_rsorders = mysql_num_rows($rsorders);

mysql_free_result($rsorders);
?>
<table border="1">
  <tr>
    <td>Order ID </td>
    <td>Username</td>
    <td>Total</td>
    <td>Order Status </td>
    <td>&nbsp;</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><?php echo $row_rsorders['orderid']; ?></td>
      <td><?php echo $row_rsorders['username']; ?></td>
      <td><?php echo $row_rsorders['total']; ?></td>
      <td><?php echo $row_rsorders['order_status']; ?></td>
      <td><a href="confirmDelete.php?recordID=<?php echo $row_rsorders['orderid']; ?>">Delete</a></td>
    </tr>

   <?php } 

   while ($row_rsorders = mysql_fetch_assoc($rsorders)); ?> 
</table>

[Houdini]

try using this

mysql_select_db($database_Shop, $Shop)
	or die("Could not select the angel_test database");
$query_rsorders = "SELECT orderid, username, total, order_status FROM orders";
$rsorders = mysql_query($query_rsorders, $Shop)
	 or die(mysql_error());
//$row_rsorders = mysql_fetch_assoc($rsorders);//This is done in the while, not needed here
//$totalRows_rsorders = mysql_num_rows($rsorders);//Unless you are just curious then this is not necessary
//echo "There are $totalRows_rsorders rows in the table<br />";//but if you want to know then uncomment these two lines
//mysql_free_result($rsorders);//not necessary
?>
<table border="1">
  <tr>
    <th>Order ID </th>
    <th>Username</th>
    <th>Total</th>
    <th>Order Status </th>
    <td>&nbsp;</td>
  </tr>
  <?php while ($row_rsorders = mysql_fetch_assoc($rsorders)){ ?>

<tr>
  <td><?php echo $row_rsorders['orderid']; ?></td>
  <td><?php echo $row_rsorders['username']; ?></td>
  <td><?php echo $row_rsorders['total']; ?></td>
  <td><?php echo $row_rsorders['order_status']; ?></td>
  <td><a href="confirmDelete.php?recordID=<?php echo $row_rsorders['orderid']; ?>">Delete</a></td>
</tr>

   <?php 
 }
?>
</table>

[pally]

Thanks alot mate 🙂